逐步教程：如何使用php扩展SQLite进行数据库管理

extension=sqlite3

<?php
$db = new PDO("sqlite:mydatabase.db");
?>

<?php
// 创建users表格
$sql = "CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    email TEXT
    )";
$db->exec($sql);

// 插入数据
$sql = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";
$db->exec($sql);
$sql = "INSERT INTO users (name, email) VALUES ('Jane Smith', 'jane@example.com')";
$db->exec($sql);
$sql = "INSERT INTO users (name, email) VALUES ('Bob Johnson', 'bob@example.com')";
$db->exec($sql);
?>

<?php
// 查询数据
$sql = "SELECT * FROM users";
$result = $db->query($sql);

// 输出数据
while ($row = $result->fetch()) {
    echo "ID: " . $row['id'] . "<br>" .
         "Name: " . $row['name'] . "<br>" .
         "Email: " . $row['email'] . "<br><br>";
}
?>

<?php
// 更新数据
$id = 1;
$newName = "Updated Name";
$newEmail = "updated@example.com";

$sql = "UPDATE users SET name='$newName', email='$newEmail' WHERE id=$id";
$db->exec($sql);
?>

<?php
// 删除数据
$id = 2;

$sql = "DELETE FROM users WHERE id=$id";
$db->exec($sql);
?>