使用pdo创建一个sqlite数据库<?php
/**
* 创建sqlite数据库
* by www.junphp.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();
}
?>