such a simple thing must let online a bunch of so-called tutorial to get confused, the harm I toss half a day! Write a note for yourself. with PDO (PDO support database porting, if your deployment will have multiple databases in the future, then use it.) PDO is a C design and performs more efficiently. He has encapsulated the extension library component for PHP. Run fast, high efficiency ) to connect SQLite, Make sure that the PHP version supports the extension (I'm using PHP 5.3.6). check that PDO and Pdo_sqlite are enabled in the php.ini.
Remove the previous semicolon comment open
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
OK, test the connection: <?php $db = new PDO ("sqlite:./mydb.sqlite"); //Pay attention to the path format of the Scarlet Letter section, this will error: Newpdo (' mydb.sqlite '); if ($db) {echo ' Connectok ';}else{echo ' Connectbad ';} foreach ($db->query ("select name from Test;") As$row){echo "$row [0]";} ?>
That ' sall~
