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