I use the sqlite 3 PDO driver that comes with PHP. An example:
<?php
$handle = new PDO('sqlite:your_database_file.db');
$handle->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));
$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> 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?
>
> Thanks,
>
> Jerry Tilsley
> St. Claire Regional Medical Center
> Sr Systems Analyst | Interfaces
>
> ________________________________
>
> Disclaimer****
> This email is confidential and intended solely for the use of the individual
> to whom it is addressed. Any views or opinions presented are solely those of
> the author and do not necessarily represent those of St. Claire Regional
> Medical Center. If you are not the intended recipient, be advised that you
> have received this email in error and that any use, dissemination,
> forwarding, printing or copying of the email is strictly prohibited. If you
> received this email in error please notify the St. Claire Regional Helpdesk
> by telephone at 606-783-6565.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
