note 89809 deleted from intro.sqlite3 by aharvey

Note Submitter: pomax at nihongoresources dot com ---- If you use PHP5, the currently advised approach to natively (ie, without using a third party library) interfacing with sqlite3 databases is through the use of a PDO object: <?php $dbh = new PDO('sqlite:yourdatabase.db'); ?> Any execution of functions and commands supported by sqlite3 can then be called through the PDO query and exec functions. For instance, a broad select would be achieved as follows: <?php foreach($dbh->query('SELECT * FROM table WHERE column = criterium') as $row) { 　foreach($row as $key=>$val) 　 { 　 　// PDO has no built in fetch_assoc equivalent 　 　if(!is_numeric($key)) print "$key: $val\n"; 　 } } ?> when done consulting or administrating a database that relies on PDO access, it is generally a good idea to either issue a <?php $dbh = null; ?> or <?php unset($dbh); ?> statement, as the PDO class does not come with a function for closing a connection, and so any PDO connection will sit idle until you explicitly dispose of it.