-
防sql 注入查看全部
-
execute查看全部
-
store_result(),獲得第一條結果集查看全部
-
more_result查看全部
-
escape_string轉義查看全部
-
獲取結果集中記錄fetch_all()返回索引或關聯黑夜返回索引 是二維數組 fetch_row返回帶索引的一維數組,第一條記錄, fetch_assoc()取得結果集中的一條記錄,是一維數組,關聯, fetch_array(),返回一維數組,帶關聯與索引 fetch_object()作為對象返回的一維數組 移動結果集內部指針 data_seek(0);得到第一條 close() free(),free_result(),關閉或釋放結果集 在關閉連接$mysqli_close()查看全部
-
1.受影響的記錄行數 2.-1代表SQL有問題,0 代表沒有受影響的記錄行數查看全部
-
affected_rows返回-1表示語句有錯誤查看全部
-
delete查看全部
-
insert_id:得到自增長的值 affected_rows值為三種： 1.受影響記錄條數 2.-1，代表sql語句有問題 3.0，代表沒有受影響記錄的條數查看全部
-
檢測MySQLi擴展是否開啟： 1.驗證MySQLi擴展是否已經開啟 phpinfo(); 2.檢測擴展是否已經加載 var_dump(extension_loaded('mysqli')); 3.檢測函數是否存在 var_dump(function_exists('mysqli_connect')); 4.得到當前已經開啟的擴展 print_r(get_loaded_extension());查看全部
-
<?php ?class Comment{ private $data = array(); ?function __construct($data){ $this->data = $data; } public static function validate(){ if(!(filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL))){ $errors['email'] = '請輸入郵箱'; } if(!(filter_input(INPUT_POST,'url',FILTER_VALIDATE_URL))){ $url = ''; } if(!(fileter_input(INPUT_POST,'content',FILTER_CALLBACK,array('op tions'=>'Comment::validate_str') ))){ $errors['content'] = '請輸入內容'; } if( !(filter_input(INPUT_POST,'username',FILTER_CALLBACK,array('options'=>'Comment::validate_str'))) ){ $errors['username'] = '請輸入用戶名'; } $options = array('option'=>array('min_range'=>1,'max_range'=>5)); if(!(filter_input(INPUT_POST,'face',FILTER_VALIDATE_INT,$options))){ $errors['face'] = '請選擇合法頭像'; } if(!empty($errors)){ $arr = $errors; return false; } $arr = $data; $arr['eamil'] = trim($arr['email']); return true; } } ?>查看全部
-
<?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'); //關閉自動提交功能 $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{ //事務回滾 $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()綁定結果集中的值到變量 $mysqli_stmt->bind_result($id, $name, $job); while($msyqli_stmt->fetch() ){ //通過fetch()遍歷結果集 echo 'ID'.$id.'<br/>'; echo '昵稱'.$name.'<br/>'; echo '身份'.$job.'<br/>'; echo '<hr/>'; } } $mysqli_stmt->free_result(); $mysqli_stmt->close(); $mysqli->close(); ?>查看全部
-
<?php header('Content-type:text/html;charset=utf-8'); $mysqli = @new mysqli('localhost','root','root','test'); if($mysqli->connect_errno){ echo 'Connect Error:'.$mysqli->connect->error; } $mysqli->set_charset('utf8'); $username = $_POST['username']; $password = md5( $_POST[''password] ); //$sql = "select * from user where username = '$username' and //password = '$password' "; //$mysqli_result = $mysqli->query($sql); //if($mysqli_result && $mysqli_result->num_rows > 0){ // echo '登陸成功!'; //} //else{ // echo '登錄失敗!'; //} //以上查詢方式容易被SQL注入 $sql = "select * from user where username = ? and password = ?"; $mysqli_stmt = $mysqli->prepare($sql); $mysqli_stmt->bind_param('ss', $username, $password); if($mysqli_stmt->excute() ){ $mysqli_stmt->store_result(); if($mysqli_stmt->num_rows > 0){ echo '登陸成功'; } else{ echo '登錄失敗'; } } $mysqli_stmt->free_result();//釋放結果集 $mysqli_stmt->close();//關閉預處理語句 $mysqli->close();查看全部
舉報
0/150
提交
取消