Re: [sqlite] PHP ODBC Question

2012-12-03 Thread Tilsley, Jerry M.
SQLite Database > Subject: Re: [sqlite] PHP ODBC Question > > > On 3 Dec 2012, at 3:38pm, "Tilsley, Jerry M." wrote: > > > Any suggestions out there on what ODBC driver to use with PHP, or any > other manner to connect to a SQLite database via PHP? > > Yup. Use

Re: [sqlite] PHP ODBC Question

2012-12-03 Thread Simon Slavin
On 3 Dec 2012, at 3:38pm, "Tilsley, Jerry M." wrote: > Any suggestions out there on what ODBC driver to use with PHP, or any other > manner to connect to a SQLite database via PHP? Yup. Use the SQLite3 object-oriented library: http://php.net/manual/en/book.sqlite3.php The library is pre-ins

Re: [sqlite] PHP ODBC Question

2012-12-03 Thread Ty ...
I use the sqlite 3 PDO driver that comes with PHP. An example: exec('CREATE TABLE example (a INTEGER, b INTEGER)'); $statement = $handle->prepare('INSERT INTO example VALUES (?, ?)'); $statement->execute(array(1, 1)); $statement->execute(array(2, 2)); $statement->execute(array(3, 3)); $statemen

Re: [sqlite] PHP ODBC Question

2012-12-03 Thread Richard Hipp
On Mon, Dec 3, 2012 at 10:38 AM, Tilsley, Jerry M. wrote: > All, > > Any suggestions out there on what ODBC driver to use with PHP, or any > other manner to connect to a SQLite database via PHP? > Doesn't PHP have built-in support for SQLite? > > Thanks, > > Jerry Tilsley > St. Claire Regional

[sqlite] PHP ODBC Question

2012-12-03 Thread Tilsley, Jerry M.
All, Any suggestions out there on what ODBC driver to use with PHP, or any other manner to connect to a SQLite database via PHP? Thanks, Jerry Tilsley St. Claire Regional Medical Center Sr Systems Analyst | Interfaces Disclaimer This email is confidential