You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
50 lines
1.4 KiB
50 lines
1.4 KiB
<?php
|
|
//创建链接
|
|
$myslqli = new mysqli('localhost','root','','db_php');
|
|
if(mysqli_connect_errno()){
|
|
echo "连接失败".mysqli_connect_error();
|
|
}else{
|
|
echo "连接成功";
|
|
}
|
|
$myslqli->query("set user 'utf8'");
|
|
//insert
|
|
$sqlStr="insert into user (name,psw) value ('jianghu','123456'),('jianghu','123456'),('jianghu','123456'),('jianghu','123456')";
|
|
if($myslqli->query($sqlStr)){
|
|
echo "插入成功"."<hr>";
|
|
echo "插入行数:".$myslqli->affected_rows."<br>";
|
|
echo "<hr>";
|
|
}else{
|
|
echo "";
|
|
}
|
|
//del
|
|
$sqlStr="delete from user where id in(2,3)";
|
|
if($myslqli->query($sqlStr)){
|
|
echo "删除成功"."<hr>";
|
|
echo "删除行数:".$myslqli->affected_rows."<br>";
|
|
echo "<hr>";
|
|
}else{
|
|
echo "";
|
|
}
|
|
//update
|
|
$sqlStr="update user set psw='123' where id=5";
|
|
if($myslqli->query($sqlStr)){
|
|
echo "更新成功"."<hr>";
|
|
echo "更新行数:".$myslqli->affected_rows."<br>";
|
|
echo "<hr>";
|
|
}else{
|
|
echo "";
|
|
}
|
|
//select
|
|
$sqlStr="select * from user";
|
|
$res = $myslqli->query($sqlStr);
|
|
if($res->num_rows>0){
|
|
while ($row =$res->fetch_assoc()) {
|
|
echo $row['name'].":".$row["psw"];
|
|
echo "<br>";
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
?>
|