php使用sqlite(超简单版)
一、直接上代码
查询:
public function select()
{
try {
$maindir = 'D:\xxx.db';
$main = new \SQLite3($maindir);
if (!$main) {
echo 'code:' . $main->lastErrorCode();
echo 'Error:' . $main->lastErrorMsg();
$main->close();
die;
}
$sql = 'select * from 表名';
$result = $main->query($sql);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$arr = $row['字段名'];
var_dump($arr);
}
$main->close();
} catch (\Exception $e) {
if (isset($main)) {
$main->close();
}
var_dump($e->getMessage());
}
}
添加:
public function insert()
{
try {
$maindir = 'D:\xxx.db';
$main = new \SQLite3($maindir);
if (!$main) {
echo 'code:' . $main->lastErrorCode();
echo 'Error:' . $main->lastErrorMsg();
$main->close();
die;
}
$sql = "INSERT INTO 表名 (xxx,xxx) VALUES ('xxx','xxx')";
$result = $main->exec($sql);
var_dump($result);
$main->close();
} catch (\Exception $e) {
if (isset($main)) {
$main->close();
}
var_dump($e->getMessage());
}
}
修改:
public function update()
{
try {
$maindir = 'D:\xxx.db';
$main = new \SQLite3($maindir);
if (!$main) {
echo 'code:' . $main->lastErrorCode();
echo 'Error:' . $main->lastErrorMsg();
$main->close();
die;
}
$sql = "UPDATE 表名 set xxx = 'xxx' where xxx = 'xxx'";
$result = $main->exec($sql);
var_dump($result);
$main->close();
} catch (\Exception $e) {
if (isset($main)) {
$main->close();
}
var_dump($e->getMessage());
}
}
删除:
public function delete()
{
try {
$maindir = 'D:\xxx.db';
$main = new \SQLite3($maindir);
if (!$main) {
echo 'code:' . $main->lastErrorCode();
echo 'Error:' . $main->lastErrorMsg();
$main->close();
die;
}
$sql = "DELETE FROM 表名 where xxx = 'xxx'";
$result = $main->exec($sql);
var_dump($result);
$main->close();
} catch (\Exception $e) {
if (isset($main)) {
$main->close();
}
var_dump($e->getMessage());
}
}