php期末作业增删改查
时间: 2024-01-20 10:15:38 浏览: 22
以下是一个使用PHP实现增删改查操作的示例:
1. 增加功能(add.php)
```php
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 获取表单提交的数据
$name = $_POST['name'];
$age = $_POST['age'];
// 执行插入操作
$sql = "INSERT INTO students (name, age) VALUES ('$name', '$age')";
mysqli_query($conn, $sql);
// 关闭数据库连接
mysqli_close($conn);
?>
```
2. 删除功能(delete.php)
```php
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 获取要删除的记录的ID
$id = $_GET['id'];
// 执行删除操作
$sql = "DELETE FROM students WHERE id = $id";
mysqli_query($conn, $sql);
// 关闭数据库连接
mysqli_close($conn);
?>
```
3. 修改功能(update.php)
```php
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 获取表单提交的数据
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
// 执行更新操作
$sql = "UPDATE students SET name = '$name', age = '$age' WHERE id = $id";
mysqli_query($conn, $sql);
// 关闭数据库连接
mysqli_close($conn);
?>
```
4. 查询功能(search.php)
```php
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 执行查询操作
$sql = "SELECT * FROM students";
$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><br>";
}
// 关闭数据库连接
mysqli_close($conn);
?>
```
请注意,上述示例中的数据库连接信息需要根据实际情况进行修改。