php mysqli 操作数据库
//连接数据库
$Ip = '119.23.70.107';
$User = 'root';
$Pwd = '123456';
$db = 'filetest';
$con = new mysqli($Ip,$User,$Pwd,$db);
//判断连接
if ($con->connect_errno) {
echo "db Connect failed: ".$con->connect_error);
exit();
}
//设置编码
$con ->set_charset("utf8");
//执行sql
$sql = "select * from base_file where file_upload = 0";
$result = $con->query($sql);
//判断查询
if(!$result){
writeLog("db Select failed".$con->error);
exit();
}
while($row = $result->fetch_assoc()){
echo $row['name'];
}
//事务处理
//关闭自动提交
$con ->autocommit(FALSE);
//执行sql
$res1 = $con->query($sql);
//成功提交,失败回滚
if($res1){
$con->commit(); //提交事务
}else{
//事务回滚
$con->rollback();
}