php数据如何实现数据的增删改查操作_php数据CRUD功能完整实现

$host = 'localhost';
$username = 'root';
$password = '';
$dbname = 'test_db';
<p>$conn = new mysqli($host, $username, $password, $dbname);</p><p>if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}</p>

function createUser($conn, $name, $email) {
    $stmt = $conn->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
    $stmt->bind_param("ss", $name, $email);
<pre class='brush:php;toolbar:false;'>if ($stmt->execute()) {
    echo "用户添加成功";
} else {
    echo "错误: " . $stmt->error;
}
$stmt->close();

function getUsers($conn) {
    $result = $conn->query("SELECT id, name, email FROM users");
<pre class='brush:php;toolbar:false;'>if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . " - 名字: " . $row["name"] . " - 邮箱: " . $row["email"] . "<br>";
    }
} else {
    echo "暂无数据";
}

function updateUser($conn, $id, $name, $email) {
    $stmt = $conn->prepare("UPDATE users SET name = ?, email = ? WHERE id = ?");
    $stmt->bind_param("ssi", $name, $email, $id);
<pre class='brush:php;toolbar:false;'>if ($stmt->execute()) {
    echo "用户更新成功";
} else {
    echo "更新失败: " . $stmt->error;
}
$stmt->close();

function deleteUser($conn, $id) {
    $stmt = $conn->prepare("DELETE FROM users WHERE id = ?");
    $stmt->bind_param("i", $id);
<pre class='brush:php;toolbar:false;'>if ($stmt->execute()) {
    echo "用户删除成功";
} else {
    echo "删除失败: " . $stmt->error;
}
$stmt->close();

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE
);