php版本:7.0.12
mysql版本:5.5.53
![image-20240329213134124](https://img-blog.csdnimg.cn/img_convert/2392f89bece4bb05af368ccda8fba6d0.png)
php操作数据库mysql,增删改查
代码如下:
<?php
// header("content-type:text/html; charset=UTF-8");
//第一步:连接数据库
$link = mysqli_connect("localhost", "root", "root", "mysite") or die("数据库链接失败!");
//第二步:设置字符集
mysqli_set_charset($link, "utf8");
//第三步:准备sql语句
// $sql = "insert into `user` (name,age,hobby)value ('xiaoming',18,'读书')"
;
// $sql = "delete from `user` where id=1";
$sql = "update `user` set name='xiaohong' where id=2";
//第四步:执行sql语句
$query = mysqli_query($link, $sql);
//第五步:提示成功或者失败,并关闭数据库连接
if ($query) {
echo "成功!";
mysqli_close($link);
} else {
echo "失败!";
}
?>