-
insert_id:得到自增長的值 affected_rows值為三種： 1.受影響記錄條數(shù) 2.-1，代表sql語句有問題 3.0，代表沒有受影響記錄的條數(shù)查看全部
-
mysqli 比 pdo 的效率快多了查看全部
-
數(shù)據(jù)庫建表查看全部
-
insert_id:得到自增長的值 affected_rows值為三種： 1.受影響記錄條數(shù) 2.-1，代表sql語句有問題 3.0，代表沒有受影響記錄的條數(shù)查看全部
-
...查看全部
-
<?php header('content-type:text/html;charset=utf-8'); $mysqli = new mysqli('localhost','root','root','test'); if($mysqli->connect_errno){ die($mysqli->connect_error); } $mysqli->set_charset('utf8'); //關(guān)閉自動提交功能 $mysqli->autocommit(FALSE); $sql = "UPDATE account SET money = money-200 WHERE username = 'king'"; $res1 = $mysqli->query($sql); $res1_rows = $msyqli->affected_rows; $sql2 = "UPDATE account SET money = money+200 WHERE username = 'queen'"; $res2 = $mysqli->query($sql2); $res2_rows = $mysqli->affected_rows; if($res1 && $res1_rows>0 && $res2 && $res2_rows>0){ //提交 $msyqli->commit(); echo 'success'; $mysqli->autocommit(TRUE); } else{ //事務(wù)回滾 $mysqli->rollback(); echo 'fail'; } $mysqli->close(); ?>查看全部
-
<?php header('content-type:text/html;charset=utf-8'); $mysqli = new mysqli('localhost','root','root','test'); if($mysqli->connect_errno){ die($mysqli->connect_error); } $mysqli->set_charset('utf8'); $sql = "select userid,username,userjob from user where userid >=?"; $mysqli_stmt = $mysqli->prepare($sql); $id = 20; $mysqli_stmt->bind_param('i',$id); if($mysqli_stmt->excute() ){ //bind_result()綁定結(jié)果集中的值到變量 $mysqli_stmt->bind_result($id, $name, $job); while($msyqli_stmt->fetch() ){ //通過fetch()遍歷結(jié)果集 echo 'ID'.$id.'<br/>'; echo '昵稱'.$name.'<br/>'; echo '身份'.$job.'<br/>'; echo '<hr/>'; } } $mysqli_stmt->free_result(); $mysqli_stmt->close(); $mysqli->close(); ?>查看全部
-
sql查看全部
-
$mysqli->multi_query($sql); 必須第一條成功，后面兩條才能執(zhí)行查看全部
-
escape_string轉(zhuǎn)義查看全部
-
法規(guī)查看全部
-
$mysqli = new musqli('localhost','root','test'); if($mysqli->connect_errno){ die('connect error:'.$mysqli->connect_error); } $mysqli->set_charset ('utf8'); //執(zhí)行單條查詢語句 $sql = "INSERT user(username,password) VALUES('king','king')，('king2','king2')，('king3','king3')，('king4','king4');"; $res = $mtsqli->query($sql); if($res){ echo'恭喜您注冊成功，您是網(wǎng)站的第'.$mysqli->insert_id().位用戶 echo '有'.$mysqli->affectd_rows.'記錄被影響'. //id子增長，提取最新插入的 }else{ echo 'ERROR'.$mysqli->errno.":"$mysqli->error; }查看全部
-
1.建立到mydql數(shù)據(jù)的鏈接 $mysqli = @new mysqli('localhost','root','root','test'); 或者$mysqli = new mysqli() $mysqli->connect('127.0.0.1','root','root','text'); 2.打開指定的數(shù)據(jù)庫 $musqli->select_db('test'); //$mysqli->connect_errno 錯誤編號 //$mysqli->connect_error 錯誤信息 if($mysqli->connect_errno){ die('connect error:'$mysqli->connect_error); }查看全部
-
extension_loaded("mysqli");查看全部
-
配置php配置文件開啟php_mysqli,dll擴展 配置extension_dir = ext目錄所在位置 重啟服務(wù)器 wanp已經(jīng)默認打開mysqli查看全部
舉報
0/150
提交
取消