PHP：mysqli对数据库进行CURD增删改查

CREATE TABLE `student` (
  `id` int(11) PRIMARY key auto_increment,
  `name` varchar(10) default "",
  `age` int(11) default 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8

<?php
$server_name = "127.0.0.1";
$username = "root";
$password = "123456";
$database = "demo";
$port = 3306;
// 创建连接
$conn = new mysqli($server_name, $username, $password, $database, $port);
// 插入数据
$result = $conn->query("insert student(name, age) values('小明', 23), ('小红', 24), ('小白', 25)");
echo $result; // 1
// 读取数据
$result = $conn->query("select * from student;");
// 按照行读取
while ($row = $result->fetch_assoc()) {
    echo $row["name"], $row["age"];
}
// 小明23小红24小白25
// 获取数据列表
$rows = $result->fetch_all(MYSQLI_ASSOC);
// 关闭连接
$conn->close();

// 更新数据
$result = $conn->query("update student set age=30 where id=3");
echo $result; // 1
// 删除数据
$result = $conn->query("delete from student where id=3");
echo $result; // 1