代码片段仓库

<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'user', 'pass');
    $pdo->beginTransaction();
    // Execute multiple queries
    $pdo->commit();
} catch (PDoException $e) {
    $pdo->rollback();
}

<?php
function getPagedData($page = 1, $limit = 10) {
    $offset = ($page - 1) * $limit;
    $stmt = $db->prepare("SELECT * FROM products LIMIT ?, ?");
    $stmt->bind_param('i', $offset, $limit);
    $stmt->execute();
    return $stmt->get_result();
}

<?php
$name = mysqli_real_escape_string($db, $_POST['name']);
$sql = "SELECT * FROM users WHERE name = '$name'";

<?php
$mysqli->real_query("INSERT INTO users (name, email) VALUES ('John', 'john@example.com'), ('Jane', 'jane@example.com')");

<?php
$db = new SQLite3('mydb.sqlite');
$db->exec('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)');

<?php
$stmt = $db->prepare("UPDATE users SET name = ? WHERE id = ?");
$stmt->bind_param('s', $name, $id);
$stmt->execute();