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);