php使用sqlite(超简单版)

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());
        }
    }