使用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(); } ?>
下一篇:
php十进制转换三十六进制转换
友情提示:垃圾评论一律封号...