php实例之创建SQLite数据库
例子:
<?php
/**
* 创建sqlite数据库
* by www.jbxue.com
*/
$db = new PDO('sqlite:/usr/local/zodiac');
$db->beginTransaction();
$q = $db->query("SELECT name FROM sqlite_master WHERE type = 'table' AND name = 'zodiac'");
if ($q->fetch() === false) {
$db->exec(<<<_SQL_
CREATE TABLE zodiac (
id INT UNSIGNED NOT NULL,
sign CHAR(11),
symbol CHAR(13),
planet CHAR(7),
element CHAR(5),
start_month TINYINT,
start_day TINYINT,
end_month TINYINT,
end_day TINYINT,
PRIMARY KEY(id)
)
_SQL_
);
$sql=<<<_SQL_
INSERT INTO zodiac VALUES (1,'Aries','Ram','Mars','fire',3,21,4,19);
INSERT INTO zodiac VALUES (2,'Taurus','Bull','Venus','earth',4,20,5,20);
INSERT INTO zodiac VALUES (3,'Gemini','Twins','Mercury','air',5,21,6,21);
_SQL_;
foreach (explode("\n",trim($sql)) as $q) {
$db->exec(trim($q));
}
$db->commit();
} else {
$db->rollback();
}
?>
您可能感兴趣的文章:
SQLite命令学习
php操作SQLite类的代码分享
php实例之创建SQLite数据库
SQLite 60分钟入门教程
php读取sqlite入门实例
Python中SQLite的简单应用
SQLite数据库的使用
轻型数据库SQLite结合PHP的开发
SQLite编程介绍
asp.net EntityFramework 6连接Sqlite数据库例子