php讀取sqlite數據庫入門實例代碼_javascript技巧

<?php
 
//臨時目錄 在Windows環境中，如果出現上述錯誤，請使用putenv("TMP=C:/temp");指定臨時文件夾。
//putenv("TMP=C:/temp");
 
//打開數據庫
if ($db = sqlite_open("test.db",0666,$sqliteerror)) {
 
//創建表
sqlite_query($db, "create table user(id integer primary key,name text);");
 
//INSERT語句
$sql = "insert into user values(NULL, '名字')";
 
//執行SQL語句
$res = sqlite_query($db, $sql);
 
//SELECT語句
$sql = "select * from user order by id desc limit 20";
 
//執行SQL語句
$res = sqlite_unbuffered_query($db, $sql);
 
//顯示結果
while ($item = sqlite_fetch_array($res, SQLITE_ASSOC)) {
print "ID:".$item["id"] ."NAME:".$item["name"];
print "
";
};
 
//關閉數據庫
sqlite_close($db);
 
} else {
print $sqliteerror;
}
?>

<?php
 //設置腳本最大執行時間
 set_time_limit(0);
 //sqlite數據庫文件名
 $db_name = 'md5.db';
 //打開sqlite數據庫
 $db = sqlite_open($db_name);
 //異常處理
 if( !$db ) {
 echo '不能連接SQlite文件：',$db_name,'
';
 }else{
 echo '成功連接SQlite文件：',$db_name,'
';
 }
 //創建數據表：MD5密碼表
 sqlite_query($db, "CREATE TABLE md5 (s int(4) PRIMARY KEY,d varchar(32))");
 //插入記錄
 $s = 0;
 while($s <= 999999){
 $d = md5($s);
 sqlite_query($db, "INSERT INTO md5 VALUES ($s,'{$d}')");
 $s++;
 }
 //檢索所有記錄
 $result = sqlite_query($db, 'SELECT * FROM md5');
 echo '
';
 while ($row = sqlite_fetch_array($result, SQLITE_BOTH)) {
 echo 'Md5:',$row['d'],' Src:',$row['s'], '
';
 }
 echo '

<?php
//打開sqlite數據庫
//$db = @sqlite_open("MM.sqlite", 0666, $error); // 不支持
//$db = new PDO('sqlite:MM.sqlite');
//異常處理
if (!$db) die("Connection Sqlite failed.\n");
//添加一個叫做foo的數據庫
//@sqlite_query($db, "CREATE TABLE foo (bar varchar(10))");
//插入一條記錄
//@sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
//檢索所有記錄
$result = $db->query('select BottleEncryptUsrName from BottleTable4');
//打印獲取的結果
foreach($result as $row){
	echo $row[0];
	echo "
";
}
?>