Error while trying to write to a DB from PHP

Question

I am invoking a PHP script from and Android client. Here is the PHP script

 <?php
//$user = $_GET['username'];
//$timestamp = $_GET['timestamp'];
//$latitude = $_GET['latitude'];
//$longtitude = $_GET['longtitude'];
//$filename = $_GET['filename'];

$user = "test";
$timestamp = 100;
$latitude = 10;
$longtitude = 10;
$filename = "test.jpg";

$dbname = "sqlite:/".dirname(__FILE__)."/terrapin";
$handle = new PDO($dbname);
if (!$handle) die ($error);

error_log("before exec",0);
$insert = "INSERT INTO information VALUES(NULL,'$user','$latitude','$longtitude','$timestamp','$filename')";
$handle->exec($insert);
error_log("after exec",0);
$handle = null;

$total = $user."\n".$timestamp."\n".$latitude."\n".$longtitude;
$name = "dumpp.txt";
$fh = fopen($name, 'w');
fwrite($fh,$total);
fclose($fh);
?>

The problem is, when I run the script from the command line, it works fine and inserts into the db. But when I remove the comments and get the values from the GET request and invoke the script from the client, nothing gets inserted into the db. There is nothing in the error, however both the error_log statements get printed. Any idea why this is happening?

This started working fine when I did this: $db = new SQLite3("terrapin"); $db->exec($insert); — ACC
– ACC, Commented Nov 2, 2011 at 8:49

James Anderson · Accepted Answer · 2011-11-02 10:21:40Z

1

I think you may have just hit the classic sqlite "Gotcha".

If the file you specify on the open statement does not exists sqllite will quietly create a new empty database. This new database will not have the tables your application expects defined inside.

Have a look in your application directories for an empty sqlite database created in an unexpected location.

edited Nov 2, 2011 at 10:21

answered Nov 2, 2011 at 8:49

James Anderson

27.5k7 gold badges55 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rukmi Patel · Accepted Answer · 2011-11-02 08:23:53Z

0

you should check it by print_r().

echo "<pre>";print_r($_GET);echo "</pre>";

if data is coming then you should check your query...

in short, you need to debug for your answer.

answered Nov 2, 2011 at 8:23

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

Comments

Alix Axel · Accepted Answer · 2011-11-02 08:40:34Z

0

Unless you have constrains in your table something should be inserted, wheter it exists in $_GET or not.

Is the SQLite database file is writable (by Apache/PHP), as well as the dirname(__FILE__) folder?

answered Nov 2, 2011 at 8:40

Alix Axel

155k100 gold badges406 silver badges509 bronze badges

Collectives™ on Stack Overflow

Error while trying to write to a DB from PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related