PHP如何毗連的SQLite數據庫 - 新竹網站架設

Contents ...

udn網路城邦

PHP如何毗連的SQLite數據庫

2024/06/21 09:25

迴響0

推薦0

引用0

網站架設

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
$sql =<<<EOF
CREATE TABLE company
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Table created successfully \n";
}
$db->close();

複製代碼

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表语句
$sql =<<<EOF
CREATE TABLE if not exists company
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
$db->close();

複製代碼

如今，運行上面的法式在當前目錄中建立指定命據庫：phpdb.db。可以根據需要更改路徑。如果數據庫成功創建，則會供應以下消息：

<?php
$db = new SQLite3('db/chinhook.db');
$tablesquery = $db->query("SELECT name FROM sqlite_master WHERE type='table';");
while ($table = $tablesquery->fetchArray(SQLITE3_ASSOC)) {
echo $table['name'] . ' ';
}
?>

複製代碼

參考文章
https://www.yiibai.com/sqlite/php-with-sqlite.html
https://stackoverflow.com/questions/17997722/sqlite3-query-to-list-all-tables-in-database-only-shows-one-table

http://www.sqlitetutorial.net/sqlite-tutorial/sqlite-show-tables/

執行上述法式時，會產生以下了局：

更新操作以下PHP顯示代碼若何了利用UPDATE語句來更新記實，從然後company表中並電子雜誌更新顯示的紀錄：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表
$sql =<<<EOF
CREATE TABLE if not exists company
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
// 更新ID小于等于2的数据记录
$sql =<<<EOF
DELETE from COMPANY where ID<=2;
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo $db->changes(), " Record(ID<=2) deleted successfully \n";
}
// 查询表中的数据
echo " Select Data from company table :<hr/>";
$sql =<<<EOF
SELECT * from COMPANY;
EOF;
$ret = $db->query($sql);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
echo "ID = ". $row['ID'] . " \n";
echo "NAME = ". $row['NAME'] ." \n";
echo "ADDRESS = ". $row['ADDRESS'] ." \n";
echo "SALARY = ".$row['SALARY'] ." \n\n";
echo '---------------------------------- ';
}
echo "Operation done successfully\n";
$db->close();

複製代碼

在履行上面語句後，應當也會在相同的目次下主動建立一個名稱為：phpdb.db的數據庫文件。如下所示 -

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表
$sql =<<<EOF
CREATE TABLE if not exists company
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
// 更新ID=1的薪水为：29999
$sql = 'UPDATE COMPANY set SALARY = 29999.00 where ID=1';
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo $db->changes(), " Record(ID=1) updated successfully \n";
}
// 查询表中的数据
echo " Select Data from company table :<hr/>";
$sql =<<<EOF
SELECT * from COMPANY;
EOF;
$ret = $db->query($sql);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
echo "ID = ". $row['ID'] . " \n";
echo "NAME = ". $row['NAME'] ." \n";
echo "ADDRESS = ". $row['ADDRESS'] ." \n";
echo "SALARY = ".$row['SALARY'] ." \n\n";
echo '---------------------------------- ';
}
echo "Operation done successfully\n";
$db->close();

複製代碼

插入數據操作以下PHP顯示法式如何了上述在示例中建立³³的company表中插入數據記實：

當履行上述程序時，它將在數據庫（phpdb.db）中建立一個名稱為：company的表，並顯示以下新聞：

創建表以下PHP法式將用於在上面建立的數據庫（phpdb.db）中建立一個表：

執行上述法式時，會產生以下成績：

最後如要列出資料庫內有多少Table name

當履行上述法式時，將向company表中插入給定的記錄，並顯示如下：

選擇操作以下PHP顯示程序如何了上述從示例中創建³³的company表中並電子雜誌數據顯示紀錄：

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully \n";
}
// 先删除后创建表
$sql = "DROP table company";
$ret = $db->exec($sql);
// 创建表
$sql =<<<EOF
CREATE TABLE if not exists company
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Table created successfully \n";
}
// $db->close();
$sql =<<<EOF
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Maxsu', 26, 'Haikou', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Allen', 25, 'Guangzhou', 15000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'Tenny', 23, 'Shanghai', 20000.00 );
INSERT INTO company (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Weiwang', 25, 'Beijing ', 65000.00 );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Yes, Some Records has Inserted successfully \n";
}
// 查询表中的数据
echo " Select Data from company table :<hr/>";
$sql =<<<EOF
SELECT * from COMPANY;
EOF;
$ret = $db->query($sql);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
echo "ID = ". $row['ID'] . " \n";
echo "NAME = ". $row['NAME'] ." \n";
echo "ADDRESS = ". $row['ADDRESS'] ." \n";
echo "SALARY = ".$row['SALARY'] ." \n\n";
echo '---------------------------------- ';
}
echo "Operation done successfully\n";
$db->close();

複製代碼

執行上述法式時，會產生以下了局：

刪除操作以下PHP顯示代碼如何了使用DELETE語句刪除任何記錄，從然後company表中並電子雜誌剩餘顯示的記實：

sqlite3的名擴展在PHP 5.3.0+以上城市默許啟用。在可以compile-時利用--without-sqlite3來禁用它。
視窗柯林斯用戶通過啟用php_sqlite3.dll才能使用此擴大。php_sqlite3.dll默許所有遊戲在PHP 5.3.0之後的PHP刊行版中。
有關具體的安裝說明，請查看PHP教程及其官方網站。
毗連到的SQLite數據庫以下PHP代碼顯示若何毗鄰到SQLite數據庫。如果數據庫不存在，那麼它將創建一個新的數據庫，最後將返回一個數據庫對象。

<?php
class SQLiteDB extends SQLite3
{
function __construct()
{
$this->open('phpdb.db');
}
}
$db = new SQLiteDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Yes, Opened database successfully\n";
}
?>

複製代碼

回覆引用

有誰引用
我要引用
引用網址

列印

全站分類：不分類｜不分類

自訂分類：不分類

上一則：網站架設 ESP32若何行使可變電阻讀取外部電壓數值
下一則：解鎖右鍵 Chrome 免任何外掛，用書籤一秒消弭，破解右鍵鎖定網站架設

你可能會有興趣的文章：

帶排序功能的js masonry瀑布流插件網站架設
網站架設在 Arduino IDE 上面安裝 ESP32
bootstrap 在小銀幕下若何把導覽列下移不致蓋住LOGO 網站架設

限會員,要發表迴響,請先登入

粉絲團