php mysqli 操作数据库

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();                     
}