当前位置：首页 > PHP

php实现增删改查

2026-01-13 12:48:33PHP

以下是在PHP中实现增删改查（CRUD）操作的详细方法，以MySQL数据库为例：

数据库连接配置

创建config.php文件存储数据库连接信息：

<?php
$host = 'localhost';
$user = 'username';
$password = 'password';
$database = 'dbname';

$conn = new mysqli($host, $user, $password, $database);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>

创建数据（Create）

向数据库插入新记录：

php实现增删改查

<?php
require 'config.php';

$name = $_POST['name'];
$email = $_POST['email'];

$sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>

读取数据（Read）

查询并显示数据库记录：

<?php
require 'config.php';

$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>

更新数据（Update）

修改现有记录：

php实现增删改查

<?php
require 'config.php';

$id = $_POST['id'];
$newName = $_POST['name'];
$newEmail = $_POST['email'];

$sql = "UPDATE users SET name='$newName', email='$newEmail' WHERE id=$id";
if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}
$conn->close();
?>

删除数据（Delete）

从数据库移除记录：

<?php
require 'config.php';

$id = $_POST['id'];
$sql = "DELETE FROM users WHERE id=$id";

if ($conn->query($sql) === TRUE) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . $conn->error;
}
$conn->close();
?>

安全注意事项

使用预处理语句防止SQL注入：

<?php
require 'config.php';

$stmt = $conn->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
$stmt->bind_param("ss", $name, $email);

$name = $_POST['name'];
$email = $_POST['email'];
$stmt->execute();

$stmt->close();
$conn->close();
?>

前端表单示例

HTML表单用于提交数据：

<form action="create.php" method="post">
    Name: <input type="text" name="name"><br>
    Email: <input type="text" name="email"><br>
    <input type="submit" value="Submit">
</form>

以上代码实现了完整的PHP增删改查功能，建议在实际应用中使用PDO或ORM框架提高安全性和可维护性。

标签: php