基本信息
$mysql_host = 'localhost'; //域名
$mysql_user = 'exp_root'; //账号
$mysql_pwd = '123456'; //密码
$mysql_dbname = 'exp'; //库名
连接
$con= mysqli_connect($mysql_host, $mysql_user, $mysql_pwd, $mysql_dbname);
// 检查连接
if (!$con)
{
die("连接错误: " . mysqli_connect_error());
}else {
echo 'success';
}
查
$sql = "select * from class";
$result = $con-> query($sql);
// 单条数据
$row = $result-> fetch_assoc();
// 所有数据
$data = $result -> fetch_All();
//var_dump($row);
增
$sql = "insert into class (name, sex, tall) values('李四', 'm', 163)";
$con -> query($sql); // 若插入成功,则返回true
改
$sql = "update class set tall = 177 where name='李四'";
$con -> query($sql); // 若修改成功,则返回true
删
$sql = "delete from class where name='李四'";
$con -> query($sql); // 若删除成功,则返回true