Hi,
it's the first time I use sqlite in PHP script.
All read requests work perfectly but I don't get on execute write
requests.
Example :
<?php
try { $dbh = new PDO("sqlite:../example1.sqlite", '', ''); }
catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); }
var_dump($dbh);
$firstname = "foobarbbar";
$lastname = "barbarbar";
try {
$sql = "INSERT INTO contact (firstname, lastname)
VALUES('".addslashes($firstname)."', '".addslashes($lastname)."')";
$result = $dbh->exec($sql);
var_dump($result);
} catch(PDOExecption $e) {
print "Error!: " . $e->getMessage() . "</br>";
}
?>
$ ls ../ -lha
...
-rw-rw-rw- 1 stephane stephane 237K 2008-08-19 21:09 example1.sqlite
...
When I launch this script INSERT request don't work, nothing is inserted in
contact table.
var_dump($result) return : bool(false)
Have you already see this issue ? What is my mistake ?
Thanks for your help,
Stephane
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
