php开启支持sqlite:打开php.ini开启
打开php.ini开启
extension=php_sqlite.dll
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
php创建sqlite数据
/*数据操作全局变量*/
global $db;
$db = new PDO("sqlite:data/account.sqlite");
if (!$db) exit("服务器不支持sqlite数据库");
常用语法:
查询:
$res = $db->query("select * from user where id=1")->fetch();
修改:
$db->exec("update user set username='{$username}', password='{$password}' where id=$id");
下载管理软件SQLiteSpy:http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
创建数据表: create table if not exists user(id integer primary key autoincrement, username text,password varchar(32))
添加表字段: alter table zh add email varchar(256)
插入表数据: insert into user(username, password) values ('admin', '3d9188577cc9bfe9291ac66b5cc872b7' )
修改表数据: update user set username='aa'
查询表数据: select * from user where id=1