php pdo及sqlite的简单实例
[*]$db = new SQLite3('test.db');
[*]$re = $db->query('select * from tbl_user');
[*]while ($res = $re->fetchArray(SQLITE3_ASSOC)){
[*]if (!isset($res['user'])) continue;
[*] echo $res['user'] . "=>". $res['password'] ."\n";
[*]}
[*]$dsn = "mysql:host=localhost;dbname=test";
[*]$db = new PDO($dsn, 'root', '123456');
[*]$db->query('set names utf8;');
[*]foreach ($db->query('SELECT * from msl_user') as $row) {
[*] print_r($row);
[*]}
页:
[1]