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 "插入成功"."
";
echo "插入行数:".$myslqli->affected_rows."
";
echo "
";
}else{
echo "";
}
//del
$sqlStr="delete from user where id in(2,3)";
if($myslqli->query($sqlStr)){
echo "删除成功"."
";
echo "删除行数:".$myslqli->affected_rows."
";
echo "
";
}else{
echo "";
}
//update
$sqlStr="update user set psw='123' where id=5";
if($myslqli->query($sqlStr)){
echo "更新成功"."
";
echo "更新行数:".$myslqli->affected_rows."
";
echo "
";
}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 "
";
}
}
?>