mysqlin的用法

$conn = mysqli_connect("localhost", "username", "password", "database");

$conn = new mysqli("localhost", "username", "password", "database");

$result = mysqli_query($conn, "SELECT * FROM table_name");

$result = $conn->query("SELECT * FROM table_name");

while($row = mysqli_fetch_assoc($result)) {
    // 处理每一行数据
}

while($row = $result->fetch_assoc()) {
    // 处理每一行数据
}

$stmt = mysqli_prepare($conn, "SELECT * FROM table_name WHERE id = ?");
mysqli_stmt_bind_param($stmt, "i", $id);
$id = 1;
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

$stmt = $conn->prepare("SELECT * FROM table_name WHERE id = ?");
$stmt->bind_param("i", $id);
$id = 1;
$stmt->execute();
$result = $stmt->get_result();