php sqlite应用

<?php
/**
php.ini启用模块重启apache
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll
 */
$sqlitedb = new SQLiteDatabase("mysqlite.db");
//$c = "create table users(uid integer primary key,uname varchar(200),upwd varchar(200))";
//$i = "insert into users values(null,'zsc','1111111111')";
//$d = "delete from users where uid = 1 ";
//$u = "update users set uname='xhj' where uid > 2";
//$s = "select * from users order by uid desc limit 1";
//$r = "drop table users";
//$sqlitedb->lastInsertRowid() //最后id
$s = "select * from users order by uid desc limit 1";
$query = $sqlitedb->query($s);
//多条
$res = $query->fetchAll();
//单条
//$res = $query->fetch();
var_dump($res);
?>