文件数据库：

<?php
// 定义数据库文件的路径
$dbFile = 'database.db';

try {
    // 创建或打开 SQLite3 数据库
    $db = new SQLite3($dbFile);

    // 创建一个表格，如果已经存在则跳过
    $db->exec("CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT NOT NULL,
        email TEXT NOT NULL UNIQUE
    )");

    // 插入一些数据
    $insertData = [
        ['name' => 'Alice', 'email' => 'alice@example.com'],
        ['name' => 'Bob', 'email' => 'bob@example.com'],
        ['name' => 'Charlie', 'email' => 'charlie@example.com'],
    ];

    $stmt = $db->prepare("INSERT OR IGNORE INTO users (name, email) VALUES (:name, :email)");
    foreach ($insertData as $data) {
        $stmt->bindValue(':name', $data['name'], SQLITE3_TEXT);
        $stmt->bindValue(':email', $data['email'], SQLITE3_TEXT);
        $stmt->execute();
    }

    // 从数据库读取数据
    $result = $db->query("SELECT * FROM users");

    // 输出数据
    echo "<h1>Users List</h1>";
    echo "<table border='1'>";
    echo "<tr><th>ID</th><th>Name</th><th>Email</th></tr>";
    while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
        echo "<tr>";
        echo "<td>" . htmlspecialchars($row['id']) . "</td>";
        echo "<td>" . htmlspecialchars($row['name']) . "</td>";
        echo "<td>" . htmlspecialchars($row['email']) . "</td>";
        echo "</tr>";
    }
    echo "</table>";

    // 关闭数据库连接
    $db->close();

} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>

内存数据库：

<?php
try {
    // 创建一个 SQLite3 的内存数据库
    $db = new SQLite3(':memory:');

    // 创建一个表
    $db->exec("CREATE TABLE users (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT NOT NULL,
        email TEXT NOT NULL UNIQUE
    )");

    // 插入一些数据
    $db->exec("INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com')");
    $db->exec("INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com')");
    $db->exec("INSERT INTO users (name, email) VALUES ('Charlie', 'charlie@example.com')");

    // 从数据库读取数据
    $result = $db->query("SELECT * FROM users");

    // 输出数据
    echo "<h1>Users List (Memory Database)</h1>";
    echo "<table border='1'>";
    echo "<tr><th>ID</th><th>Name</th><th>Email</th></tr>";
    while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
        echo "<tr>";
        echo "<td>" . htmlspecialchars($row['id']) . "</td>";
        echo "<td>" . htmlspecialchars($row['name']) . "</td>";
        echo "<td>" . htmlspecialchars($row['email']) . "</td>";
        echo "</tr>";
    }
    echo "</table>";

    // 关闭数据库连接
    $db->close();

} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>