代码片段仓库

<?php
$stmt = $db->prepare("DELETE FROM users WHERE id = ?");
$stmt->bind_param('i', $id);
$stmt->execute();

<?php
$stmt = $db->prepare("CALL GetUserById()");
$stmt->bind_param('i', $id);
$stmt->execute();

<?php
$backupFile = 'backup-sql.sql';
$result = $db->query('SHOW TABLES');
while ($row = $result->fetch_assoc()) {
    $table = $row['Table'];
    $create = $db->query("SHOW CREATE TABLE {$table}");
    $data = $db->query("SELECT * FROM {$table}");
    // Save to file
    file_put_contents($backupFile, "-- TABLE $table\n", FILE_APPEND);
}

<?php
$mysqli = new mysqli('localhost', 'user', 'pass', 'db');
echo $mysqli->server_info;

<?php
$result = $db->query('SELECT * FROM users');
$data = [];
while ($row = $result->fetch_assoc()) {
    $data[] = $row;
}
header('Content-Type: application/json');
echo json_encode($data);