怎么实现增删改查php
时间: 2023-07-07 17:12:29 浏览: 56
增删改查(CRUD)是指对数据库数据的基本操作,其中“增”是指添加数据,“删”是指删除数据,“改”是指修改数据,“查”是指查询数据。以下是使用 PHP 实现增删改查的简单示例:
添加数据(增):
```php
<?php
//连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
//获取表单提交的数据
$name = $_POST['name'];
$age = $_POST['age'];
//向数据库插入数据
$sql = "INSERT INTO users (name, age) VALUES ('$name', '$age')";
mysqli_query($conn, $sql);
//关闭数据库连接
mysqli_close($conn);
?>
```
删除数据(删):
```php
<?php
//连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
//获取要删除的数据 ID
$id = $_GET['id'];
//从数据库删除数据
$sql = "DELETE FROM users WHERE id = $id";
mysqli_query($conn, $sql);
//关闭数据库连接
mysqli_close($conn);
?>
```
修改数据(改):
```php
<?php
//连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
//获取表单提交的数据
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
//更新数据库中的数据
$sql = "UPDATE users SET name = '$name', age = '$age' WHERE id = $id";
mysqli_query($conn, $sql);
//关闭数据库连接
mysqli_close($conn);
?>
```
查询数据(查):
```php
<?php
//连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
//从数据库中查询数据
$sql = "SELECT * FROM users";
$result = mysqli_query($conn, $sql);
//输出查询结果
while ($row = mysqli_fetch_assoc($result)) {
echo "ID: " . $row['id'] . "<br>";
echo "Name: " . $row['name'] . "<br>";
echo "Age: " . $row['age'] . "<br>";
}
//关闭数据库连接
mysqli_close($conn);
?>
```
以上示例仅供参考,实际使用时还需要进行安全验证和错误处理等操作。