php操作sqlite

傷城~ 2022-09-10 03:09 186阅读 0赞

<?php
 class MyDB extends SQLite3
 {
 function __construct()
 {
 $this->open('test.db');
 }
 }
 $db = opensql();
 
 tablesql($db);
 
 insertsql($db);
 
 selectsql($db);
 
 updatesql($db);
 
 selectsql($db);
 
 deletesql($db);
 $db->close();
 
 function opensql()
 {
 $db = new MyDB();
 if(!$db){
 echo $db->lastErrorMsg();
 } else {
 echo "Opened database successfully ";
 }
 return $db;
 }
 
 function tablesql($db)
 {
 $sql =<<<EOF
 CREATE TABLE COMPANY
 (ID INTEGER PRIMARY KEY,
 DATE DATETIME NOT NULL,
 TEMP REAL NOT NULL,
 HUMIDITY REAL,
 REMARK TEXT);
 EOF;
 
 $ret = $db->exec($sql);
 if(!$ret){
 echo $db->lastErrorMsg();
 } else {
 echo "Table created successfully ";
 }
 }
 
 function insertsql($db)
 {
 $sql =<<<EOF
 INSERT INTO COMPANY (DATE,TEMP,HUMIDITY)
 VALUES ("2021-9-3 16:33:00", 25.6, 55.7);
 
 INSERT INTO COMPANY (DATE,TEMP,HUMIDITY)
 VALUES ("2021-9-3 16:34:00", 25.3, 55.5);
 
 INSERT INTO COMPANY (DATE,TEMP,HUMIDITY)
 VALUES ("2021-9-3 16:35:00", 25.3, 53.7);
 EOF;
 
 $ret = $db->exec($sql);
 if(!$ret){
 echo $db->lastErrorMsg();
 } else {
 echo "Records created successfully ";
 }
 }
 
 function selectsql($db)
 {
 $sql = "SELECT * from COMPANY;";
 $ret = $db->query($sql);
 while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
 echo "ID = ". $row['ID'] ." ";
 echo "DATE = ". $row['DATE'] ." ";
 echo "TEMP = ". $row['TEMP'] ." ";
 echo "HUMIDITY = ".$row['HUMIDITY'] ." ";
 }
 echo "Operation done successfully ";
 }
 
 function updatesql($db)
 {
 $sql = "UPDATE COMPANY set TEMP = 23.7 where DATE='2021-9-3 16:35:00';";
 $ret = $db->exec($sql);
 if(!$ret){
 echo $db->lastErrorMsg();
 } else {
 echo $db->changes(), " Record updated successfully ";
 }
 }
 
 function deletesql($db)
 {
 $sql = "DELETE from COMPANY where ID=2;";
 $ret = $db->exec($sql);
 if(!$ret){
 echo $db->lastErrorMsg();
 } else {
 echo $db->changes(), " Record updated successfully ";
 }
 }
 ?>

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYW5keWxhdXJlbg_size_16_color_FFFFFF_t_70_g_se_x_16][]

参考：

[https://www.runoob.com/sqlite/sqlite-php.html][https_www.runoob.com_sqlite_sqlite-php.html]

[https://www.php.net/manual/zh/book.sqlite3.php][https_www.php.net_manual_zh_book.sqlite3.php]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAYW5keWxhdXJlbg_size_16_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/f0e8135f50da4a3aa71b1eacc44d3989.png
[https_www.runoob.com_sqlite_sqlite-php.html]: https://www.runoob.com/sqlite/sqlite-php.html
[https_www.php.net_manual_zh_book.sqlite3.php]: https://www.php.net/manual/zh/book.sqlite3.php