MySQL基础 #

<?php
$conn = new mysqli('localhost', 'root', 'password', 'mydb');

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

<?php
$result = $conn->query("SELECT * FROM users");

while ($row = $result->fetch_assoc()) {
    echo $row['name'];
}

<?php
$sql = "INSERT INTO users (name, email) VALUES ('John', 'john@example.com')";
$conn->query($sql);
echo $conn->insert_id;

<?php
$conn->close();