On 28 Jul 2010, at 6:56am, Roger Binns wrote:
This works:
create table ( );
The obfuscated SQLite contest closed three months ago.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Tue, 27 Jul 2010 22:56:23 -0700, Roger Binns
rog...@rogerbinns.com wrote:
You can if you quote it. Note use double quotes to quote table column
names, single quotes for strings. You can also quote names using square
brackets - eg [table name].
Thanks Roger for the tip.
Hello
I'm having a problem with this PHP5 script running under Nginx +
PHP5-FPM and PDO-SQLite3:
=
?php
try
{
$dbh = new PDO('sqlite:dummy.sqlite');
$dbh-exec(CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY
KEY AUTOINCREMENT, name VARCHAR(255)));
On Tue, 27 Jul 2010 14:40:11 +0200, Gilles Ganault
gilles.gana...@free.fr wrote:
I'm having a problem with this PHP5 script running under Nginx +
PHP5-FPM and PDO-SQLite3
Found it: For newbies like me... table is a reserved name so cannot
be used as a name to table:
#BAD
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/27/2010 05:48 AM, Gilles Ganault wrote:
Found it: For newbies like me... table is a reserved name so cannot
be used as a name to table:
You can if you quote it. Note use double quotes to quote table column
names, single quotes for strings.
Hello
I'm using the pre-compiled PHP5-FPM/FastCGI (www.php-fpm.org) which
seem to contain the following DB connectors:
PDO drivers mysql, sqlite, sqlite2
pdo_mysql 5.1.48
pdo_sqlite 3.6.22
SQLite 2.8.17
sqlite3 3.6.22
So from the above, it looks like this binary supports access to
MySQL(i)
On 24 Jul 2010, at 9:56am, Gilles Ganault wrote:
So from the above, it looks like this binary supports access to
MySQL(i) and SQLite2/3, in both procedural and (PDO) object-oriented
modes.
If that's correct, and provided the application doesn't need to be
DB-agnostic... why should I
On Sat, 24 Jul 2010 08:33:21 -0400, Simon Slavin slav...@bigfraud.org
wrote:
On 24 Jul 2010, at 9:56am, Gilles Ganault wrote:
So from the above, it looks like this binary supports access to
MySQL(i) and SQLite2/3, in both procedural and (PDO) object-oriented
modes.
If that's correct,
On 24/07/10 14:18, J. King wrote:
PDO_sqlite3 also does have the advantage of being available by default
since PHP 5.0.0, whereas sqlite3 is only available by default since PHP
5.3.0. I'm aware of no other advantages to using PDO, and from what I've
read it's on the slow side.
Right now
On 24/07/10 15:41, Alan Chandler wrote:
On 24/07/10 14:18, J. King wrote:
PDO_sqlite3 also does have the advantage of being available by default
since PHP 5.0.0, whereas sqlite3 is only available by default since PHP
5.3.0. I'm aware of no other advantages to using PDO, and from what I've
On Sat, 24 Jul 2010 09:18:57 -0400, J. King
jk...@jkingweb.ca wrote:
PDO_sqlite3 also does have the advantage of being available by default
since PHP 5.0.0, whereas sqlite3 is only available by default since PHP
5.3.0. I'm aware of no other advantages to using PDO, and from what I've
On Sat, 24 Jul 2010 18:50:05 +0200, Kees Nuyt
k.n...@zonnet.nl wrote:
There's also pdo_sqlite_external which uses the sqlite3.dll
the user provides, so you can use the latest and greatest
sqlite version without having to wait for incorporation in
PHP or PDO itself.
Thanks guys for the input. I'll
As I understand it, SQLite2 files are not compatible with SQLite3. This
poses a dilemma for me and I would guess many others on shared, virtual
webhosts.
The docs say to simply have both versions installed and copy from vers 2
to vers 3. That's OK for dedicated servers; but, most of us who
Hi,
I'm trying to use PHP5 with SQLite 3, but it's not working.
I see then the native PHP only suporte SQLite 2.8, but i can compile last
version of php with SQLite 3 suport.
O compile last PHP version with this line:
make clean ./configure --prefix=/usr/local/php5 --enable-pdo
- Original Message -
From: Rúben Lício [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, November 08, 2006 1:03 PM
Subject: [sqlite] PHP5 with SQLite3
Are you connecting correctly to the database. Which version of sqlite3 was
the database created in. I beleive php5.1
15 matches
Mail list logo