I downloaded 5.3.6 from here -- I used the Thread Safe version Installer.
http://windows.php.net/download/
And you're script ran just fine and created this:
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE tbl2 (one varchar(10),two varchar(10));
COMMIT;
I the modified your script to run a bit better as you will see "false" the 2nd
time your script is run as the table already exists.
<?php
try {
$dbh = new PDO('sqlite:db1.db');
$result=$dbh->query("drop table if exists tbl2");
$result=$dbh->query("create table tbl2 (one varchar(10),two varchar(10));");
var_dump($result);
}
catch(PDOException $e)
{
print "Oops!\n";
print 'Exception : '.$e->getMessage()."\n";
}
?>
So now every time I run it we get this:
D:\php>php <db.php
object(PDOStatement)#3 (1) {
["queryString"]=>
string(52) "create table tbl2 (one varchar(10),two varchar(10));"
}
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
________________________________
From: [email protected] [[email protected]] on
behalf of James_21th [[email protected]]
Sent: Thursday, July 07, 2011 8:50 PM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Insert not working for sqlite3
Dear all,
Thank you for all your valuable suggestion, it's good idea to put the whole
script here, also good idea everytime to check the result, so I put the whole
script here:
The $result always return false, it don't allow me to create a simple table, the
table name surely not exist, I change tbl3, 4, 5, all not able to create. (that
could be the same reason why insert is not working, if not even able to create
table, let alone insert.)
<?php
$dbh = new PDO('sqlite:db1.db');
$result=$dbh->query("create table tbl2 (one varchar(10),two varchar(10));");
var_dump($result);
?>
----- Original Message ----
From: Stephan Beal <[email protected]>
To: General Discussion of SQLite Database <[email protected]>
Sent: Thu, 7 July, 2011 9:18:07 PM
Subject: Re: [sqlite] Insert not working for sqlite3
On Thu, Jul 7, 2011 at 2:17 PM, Simon Slavin <[email protected]> wrote:
> For each operation you should test the $result and check to see it's
> SQLITE_OK.
>
Or enable exceptions and you don't have to check for errors (because they
will cause an exception).
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
