php实现数据库表单的增删改查
时间: 2024-01-05 07:04:12 浏览: 39
好的,下面是一个简单的例子:
1. 首先,连接数据库,选择数据库,建立表单。
```
<?php
//连接数据库
$con=mysqli_connect("localhost","my_user","my_password","my_db");
//选择数据库
mysqli_select_db($con,"my_db");
//建立表单
$sql="CREATE TABLE Persons(FirstName CHAR(30),LastName CHAR(30),Age INT)";
mysqli_query($con,$sql);
?>
```
2. 插入数据。
```
<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
mysqli_select_db($con,"my_db");
//插入数据
$sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter', 'Griffin', '35')";
mysqli_query($con,$sql);
?>
```
3. 查询数据。
```
<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
mysqli_select_db($con,"my_db");
//查询数据
$result=mysqli_query($con,"SELECT * FROM Persons");
while($row=mysqli_fetch_array($result)){
echo $row['FirstName'].' '.$row['LastName'].' '.$row['Age'].'<br />';
}
?>
```
4. 更新数据。
```
<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
mysqli_select_db($con,"my_db");
//更新数据
$sql="UPDATE Persons SET Age='36' WHERE FirstName='Peter' AND LastName='Griffin'";
mysqli_query($con,$sql);
?>
```
5. 删除数据。
```
<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
mysqli_select_db($con,"my_db");
//删除数据
$sql="DELETE FROM Persons WHERE FirstName='Peter' AND LastName='Griffin'";
mysqli_query($con,$sql);
?>
```
以上是一个基本的增删改查的例子,具体的实现可能会因为实际需求的不同而有所变化。