I’m trying to learn to use php interacting with db.
To connect to sqlite3 I’m using the ADOdb library.
This is the PHP snippet I’m using.
require_once 'ADOdb/adodb.inc.php';
$db = NewADOConnection('sqlite3');
$databasePath = 'test.db';
$db->Connect($databasePath);
$query = $_GET['table'];
$result = $db->Execute($query);
echo $result;
?>
Using this script I’m able to run queries without any problem, but until I try to run a query like this,
PRAGMA table_info('test');SELECT 1;,
I’m unable to retrieve the value of the second query. Could anyone tell me why? Thanks in advance.