SQlite Extension not working with PHP V.8 (Puravidaapps)

Discuss
1

I don’t know if there is support for this extension, but I want to use it with php version 8 or higher and it sends me the following error.

Fatal Error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() in /home/adsencio/public_html/mysql.php: 53

My version php: 8.1

2

Confusing…

You are using a mysql.php file?
How are your running php (on your device)?
SQLite extension is for accessing sqlite on a local device

If you want to use sqlite3 / an sqlite database on a server, accessing the database from your device using the web component and calling a php file on the server, see here:

3

Maybe . …
PHP 7.4 deprecated get_magic_quotes_gpc function.
So , Search on Google about This subject.

But, you need to explain better: are you using php script ( to access Mysql) with this function on your server and are you using SQLITE extension?
An observation: Sqlite != Mysql

Hugs

4

A friend helped me and corrected it so that it is compatible with php 8, I leave you the file in case you need it.

mysql.php

<?php
/*
 * Written By: ShivalWolf
 * Date: 2011/06/03
 * Contact: [email protected]
 *
 * UPDATE 2011/04/05
 * The code now returns a real error message on a bad query with the mysql error number and its error message
 * checks for magic_quotes being enabled and strips slashes if it is. Its best to disable magic quotes still.
 * Checks to make sure the submitted form is a x-www-form-urlencode just so people dont screw with a browser access or atleast try to
 * Forces the output filename to be JSON to conform with standards
 *
 * UPDATE 2011/06/03
 * Code updated to use the Web Module instead of tinywebdb
 *
 * UPDATE 2013/12/26 and 2014/02/18
 * minor modifications by Taifun, puravidaapps.com
 *
 * UPDATE 2014/07/11
 * mysql API (deprecated) replaced by mysqli by Taifun
 *
 * UPDATE 2015/04/30
 * SELECT logic adjusted (result stored in temp. file removed) by Taifun
 *
 * UPDATE 2016/02/21
 * Bugfix Undefined variable: csv
 */

/************************************CONFIG****************************************/
//DATABSE DETAILS//
$DB_ADDRESS="localhost";
$DB_USER="ad";
$DB_PASS="Pud";
$DB_NAME="ad";

//SETTINGS//
//This code is something you set in the APP so random people cant use it.
$SQLKEY="Pud";

/************************************CONFIG****************************************/

//these are just in case setting headers forcing it to always expire
header('Cache-Control: no-cache, must-revalidate');

error_log(print_r($_POST,TRUE));

if( isset($_POST['query']) && isset($_POST['key']) ){                                   //checks if the tag post is there and if its been a proper form post
  //set content type to CSV (to be set here to be able to access this page also with a browser)
  header('Content-type: text/csv');

  if($_POST['key']==$SQLKEY){                                                           //validates the SQL key
    $query=urldecode($_POST['query']);
      //check if the worthless pile of cr4p magic quotes is enabled and if it is, strip the slashes from the query
      $query=stripslashes($query);
    
    $conn = new mysqli($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME);    //connect
    mysqli_set_charset($conn, "utf8"); 

    if($conn->connect_error){                                                           //checks connection
      header("HTTP/1.0 400 Bad Request");
      echo "ERROR Database Connection Failed: " . $conn->connect_error, E_USER_ERROR;   //reports a DB connection failure
    } else {
      $result=$conn->query($query);                                                     //runs the posted query
      if($result === false){
        header("HTTP/1.0 400 Bad Request");                                             //sends back a bad request error
        echo "Wrong SQL: " . $query . " Error: " . $conn->error, E_USER_ERROR;          //errors if the query is bad and spits the error back to the client
      } else {
        if (strlen(stristr($query,"SELECT"))>0) {                                       //tests if it's a SELECT statement
          $csv = '';                                                                    // bug fix Undefined variable: csv
          while ($fieldinfo = $result->fetch_field()) {
            $csv .= $fieldinfo->name.",";
          }
          $csv = rtrim($csv, ",")."\n";
          echo $csv;                                                                    //prints header row
          $csv = '';

          $result->data_seek(0);
          while($row = $result->fetch_assoc()){
            foreach ($row as $key => $value) {
              $csv .= $value.",";
            }
            $csv = rtrim($csv, ",")."\n";
          }
          echo $csv;                                                                    //prints all data rows
        } else {
          header("HTTP/1.0 201 Rows");
          echo "AFFECTED ROWS: " . $conn->affected_rows;       //if the query is anything but a SELECT, it will return the number of affected rows
        }
      }
      $conn->close();                                          //closes the DB
    }
  } else {
     header("HTTP/1.0 400 Bad Request");
     echo "Bad Request";                                       //reports if the secret key was bad
  }
} else {
        header("HTTP/1.0 400 Bad Request");
        echo "Bad Request";
}
?>
5

Thanks, but I create my scripts.
:+1:
As I mentioned, the function is deprecated.

and …

Sqlite != Mysql

Hugs

6

This has nothing to do with SQLite :wink:

1 Like