PHP和Microsoft Access数据库 - 连接和CRUD

$db_path = "C:/path/to/your/database.mdb";
$dsn = "odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db_path; Uid=; Pwd=;";
$dbh = new PDO($dsn);

$stmt = $dbh->prepare("INSERT INTO users (name, email) VALUES (:name, :email)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':email', $email);
$name = "John Doe";
$email = "john@example.com";
$stmt->execute();

$stmt = $dbh->prepare("SELECT * FROM users WHERE id = :id");
$stmt->bindParam(':id', $id);
$id = 1;
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
print_r($result);

$stmt = $dbh->prepare("UPDATE users SET name = :name, email = :email WHERE id = :id");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':id', $id);
$name = "Jane Doe";
$email = "jane@example.com";
$id = 1;
$stmt->execute();

$stmt = $dbh->prepare("DELETE FROM users WHERE id = :id");
$stmt->bindParam(':id', $id);
$id = 1;
$stmt->execute();