Re: [sqlite] PHP ODBC Question

2012-12-03 Thread Ty ...
e(array(3, 3)); $statement = $handle->prepare('SELECT a, b FROM example WHERE a > ?'); $statement->execute(array(1)); $results = $statement->fetchAll(PDO::FETCH_ASSOC); var_dump($results); ?> ~Ty On Mon, Dec 3, 2012 at 8:38 AM, Tilsley, Jerry M. <jmtils...@st-claire.org> wrot

Re: [sqlite] Sqlite2 vs Sqlite3 issues

2009-01-29 Thread Ty ...
b: http://www.tonybibbs.com > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- ~Ty ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] numRows undefined function?

2008-05-01 Thread Ty ...
$db->exec( 'DROP TABLE pdo' ); $db->exec( 'CREATE TABLE pdo (id, string)' ); $db->exec( 'INSERT INTO pdo VALUES ("1","1")' ); $db->exec( 'INSERT INTO pdo VALUES ("1","2")' ); $result = $db->query( 'SELECT * FROM pdo' ); echo $result->rowCount() . "\n\n"; -- ~Ty ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] numRows undefined function?

2008-04-30 Thread Ty
. I don't know how it works with sqlite). ~Ty ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PHP Code That Can Store and Retrieve Images

2008-03-12 Thread Ty
Robert L Cochran <[EMAIL PROTECTED]> writes: > > Is there open source PHP code (PHP 5.x compatible) that can store and > retrieve images from an SQLite 3.5.6 database? > Here's a quick example I came up with... it's using sqlite2 (I guess I have an old version of php or something like that