On Fri, 11 Sep 2009 18:11:42 -0400, Fred Williams <fwilliam...@gmail.com> wrote:
> Thanks for the "awakening." Now where did I leave that, "Learn PHP In > Twenty Minutes" book? I may be biased when it comes to PHP, but I find its SQLite interface perfectly acceptable. Anyway, you'll definitely want to look at the following manual pages: <http://ca2.php.net/manual/en/pdo.construct.php> <http://ca2.php.net/manual/en/ref.pdo-sqlite.connection.php> <http://ca2.php.net/manual/en/pdo.prepare.php> <http://ca2.php.net/manual/en/pdostatement.execute.php> <http://ca2.php.net/manual/en/pdostatement.fetchall.php> That's the basics to get you started on interfacing with SQLite; there's lots more including type binding, transactions and user functions, but you should be able to find that easily enough. The PDO interface doesn't allow for some things like loading extensions (and it's apparently slower, but I haven't taken the time to compare), but there's always <http://ca2.php.net/manual/en/book.sqlite3.php> if you have PHP 5.3 on hand and your existing code works with it. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users