php增删改查mysql实例
时间: 2023-06-28 13:14:09 浏览: 57
以下是一个简单的 PHP 增删改查 MySQL 数据库的示例:
连接到 MySQL 数据库:
```php
<?php
// 数据库连接信息
$server = "localhost";
$username = "username";
$password = "password";
$database = "database";
// 创建连接
$conn = mysqli_connect($server, $username, $password, $database);
// 检查连接
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
echo "连接成功";
?>
```
插入数据:
```php
<?php
// 插入数据
$sql = "INSERT INTO users (name, email, phone) VALUES ('John Doe', 'johndoe@example.com', '555-555-5555')";
if (mysqli_query($conn, $sql)) {
echo "新记录插入成功";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
```
查询数据:
```php
<?php
// 查询数据
$sql = "SELECT id, name, email, phone FROM users";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// 输出数据
while($row = mysqli_fetch_assoc($result)) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. " - Phone: " . $row["phone"]. "<br>";
}
} else {
echo "0 结果";
}
mysqli_close($conn);
?>
```
更新数据:
```php
<?php
// 更新数据
$sql = "UPDATE users SET phone='555-123-4567' WHERE name='John Doe'";
if (mysqli_query($conn, $sql)) {
echo "记录更新成功";
} else {
echo "Error updating record: " . mysqli_error($conn);
}
mysqli_close($conn);
?>
```
删除数据:
```php
<?php
// 删除数据
$sql = "DELETE FROM users WHERE name='John Doe'";
if (mysqli_query($conn, $sql)) {
echo "记录删除成功";
} else {
echo "Error deleting record: " . mysqli_error($conn);
}
mysqli_close($conn);
?>
```