PHP中常见的CRUD函数

PHP中常见的CRUD函数

创建（Create）：创建一个新的数据记录

function create($name, $age, $email) {
    $conn = mysqli_connect("localhost", "username", "password", "myDB");
    $sql = "INSERT INTO users (name, age, email) VALUES ('$name', '$age', '$email')";
    mysqli_query($conn, $sql);
    mysqli_close($conn);
}

读取（Read）：从数据库中读取数据

function read($id) {
    $conn = mysqli_connect("localhost", "username", "password", "myDB");
    $sql = "SELECT * FROM users WHERE id=$id";
    $result = mysqli_query($conn, $sql);
    $row = mysqli_fetch_assoc($result);
    mysqli_close($conn);
    return $row;
}

更新（Update）：更新数据库中的数据

function update($id, $name, $age, $email) {
    $conn = mysqli_connect("localhost", "username", "password", "myDB");
    $sql = "UPDATE users SET name='$name', age='$age', email='$email' WHERE id=$id";
    mysqli_query($conn, $sql);
    mysqli_close($conn);
}

删除（delete）：从数据库中删除数据

function delete($id) {
    $conn = mysqli_connect("localhost", "username", "password", "myDB");
    $sql = "DELETE FROM users WHERE id=$id";
    mysqli_query($conn, $sql);
    mysqli_close($conn);