-
/檢測mysqli是否開啟，其他擴(kuò)展也類似 //phpinfo(); var_dump(extension_loaded("mysqli")); echo "<hr/>"; var_dump(function_exists("mysqli_connect")); echo "<hr/>"; print_r( get_loaded_extensions()); echo "<hr/>";查看全部
-
6. 查詢 $sql=“SELECT id,username,password,email FROM user”; $res=mysqli_query($link,$sql); //echo mysqli_num_rows($res); if($res && mysqli_num_rows($res)>0){ while($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){ //print_r($row); $rows[]=$row; } } print_r($rows); mysqli_free_result($res); //釋放結(jié)果集 7. 關(guān)閉連接 mysqli_close($link);查看全部
-
4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 預(yù)處理語句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);查看全部
-
//mysqli_func.php <?php //1.連接 $link = mysqli_connect(‘localhost’,’root’,’root’,’test’) or die(‘Connect Error:’.mysqli_connect_errno().”:”.mysqli_connect_error()); //2.編碼 mysqli_set_charset($link,’UTF8’); //3.查詢 $sql=“INSERT user(username,password,age) VALUES(‘a(chǎn)’,’a’,11);”; $res=$mysqli_query($link,$sql); if($res){ echo ‘AUTO_INCREAMENT:’.$mysqli_insert_id($link); echo ‘<hr/>’; echo ‘AFFECTED_ROWS:’.$mysqli_affected_rows($link); }else{ echo ‘ERROR:<br/>’; echo mysqli_errno($link).”:”.mysqli_error($link); } print_r($link); ?>查看全部
-
//輸出到html,顯示評論內(nèi)容 public function output(){ if($this->data[‘url’]){ $link_start=“<a href=‘”.$this->data[‘url’].”’ target=‘_blank’>”; $link_end=“</a>”; } $dateStr=date(“Y年m月d日 H:i:s”,$this->data[‘pubTime’]); $res=<<<EOF <div class=‘comment’> <div class=‘face’> {$link_start} <img width=’50’ height=’50’ src=“img/{$this->data[‘face’]}.jpg”> {$link_end} </div> <div class=‘username’></div> <div class=‘date’>{$dateStr}</div> <p>{$this->data[‘content’]}</p> </div> }查看全部
-
//comment.class.php <?php class Comment{ private $data=array(); function __construct($data){ $this->data=$data; } public static function validate(&$arr){ if(!($data[‘email’]=filter_input(INPUT_POST,’email’,FILTER_VALIDATE_EMAIL))){ $errors[‘email’]=‘請輸入合法郵箱’; } if(!($data[‘url’]=filter_input(INPUT_POST,’url’,FILTER_VALIDATE_URL))){ $url=‘’; } if(!($data[‘content’]=filter_input(INPUT_POST,’content’,FILTER_CALLBACK,array(‘options’=>’Comment::validate_str’)))){ $errors[‘content’]=‘請輸入核實(shí)內(nèi)容’; } //username,face,FILTER_VALIDATE_INT, $options = array('option'=>array('min_range'=>1,'max_range'=>5)); $arr = $data; $arr[‘email’] = strtolower(trim($arr[‘email’])); } //過濾用戶輸入的特殊字符 public static function validate_str($str){ if(mb_strlen($str,’UTF8’)<1){ return false; } $str=nl2br(htmlspecialchars($str,ENT_QUOTES)); //nl2br,前后加入回車換行 return $str; } } ?>查看全部
-
16. MySQLi評論系統(tǒng) //doAction.php <?php //header require_once ‘connect.php’; require_once ‘comment.class.php’; $arr = array(); $res = Comment::validate($arr); if($res){ $sql=“INSERT comments(username,email,url,face,content,pubTime) VALUES(?,?,?,?,?,?)”; $mysqli_stmt =$mysqli->prepare($sql); $arr[‘pubTime’]=time(); $mysqli_stmt->bind_param(‘sssssi’,$arr[‘username’],$arr[‘email’],$arr[‘url’],$arr[‘face’],$arr[‘content’],$arr[‘pubTime’]); $mysqli_stmt->execute(); $comment=new Comment($arr); echo json_encode(array(’status’=>1,’html’=>$comment->output())); }else{ echo ‘{“status”:0,”errors”:’.json_encode($arr).’}’; } ?> //connect.php <?php $mysqli=new mysqli(‘localhost’,’root’,’root’,’test’); if($mysqli->errno){ die(‘Connect Error:’.$mysqli->error); }else{ $mysqli->set_charset(‘UTF8’); } ?>查看全部
-
mysqli的優(yōu)勢查看全部
-
bind_result()中綁定的值的數(shù)量多少等要和 SQL語句中"SELECT u_id,u_username,u_age FROM user WHERE u_id>=?;"返回的列數(shù)對應(yīng)； ----------------------------------------------------------------------------------------- "SELECT u_id FROM user WHERE u_id>=?;" >>>> bind_result($id); ----------------------------------------------------------------------------------------------- "SELECT * FROM user WHERE u_id>=?;" //所有列 >>>> bind_result($id, $name, $password, $age); //事實(shí)上$password不用取，只是例子演示需要。 --------------------------------------------------------------------------------------------------查看全部
-
ssi 表示 第1個(gè)插入數(shù)據(jù)庫列的參數(shù)為字符，第2個(gè)為字符，第3個(gè)為integer整數(shù)數(shù)值 Type specification chars Character Description i corresponding variable has type integer d corresponding variable has type double s corresponding variable has type string b corresponding variable is a blob and will be sent in packets 如果是這樣的 $stmt = $mysqli->prepare("INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)"); $stmt->bind_param('sssd', $code, $language, $official, $percent); 表達(dá)的是： 第1個(gè)到第3個(gè)都是字符，第4個(gè)是double小數(shù)查看全部
-
檢測mysqli擴(kuò)展是否開啟查看全部
-
檢測mysqli擴(kuò)展是否開啟查看全部
-
$sql = "INSERT...;" $SQL.= "UPDATE...;" $sql .="DELETE...;" $mysqli->multi_query($sql); 必須第一條成功，后面兩條才能執(zhí)行 $sql = "SELECT ID,username,age FROM user;"; $sql .= "SELECT * FROM mysql.user;" //use_resuly()/store_result()第一個(gè)結(jié)果集 //通過more_result檢查是否有更多的結(jié)果集 //next_result()將結(jié)果集指針向下移動一位。 $mysqli->multi_query($sql) if($mysqli->multi_query($sql)){ do{ if($mysqli_result=$mysqli->storage_result()){ $rows[]=$muysqli_result->fetch_all(MYSQLI_ASSOC); } WHILE($mysqli->more_results()&&mysqli->next_results()); } }查看全部
-
$sql = "INSERT...;" $SQL.= "UPDATE...;" $sql .="DELETE...;" $mysqli->multi_query($sql); 必須第一條成功，后面兩條才能執(zhí)行 $sql = "SELECT ID,username,age FROM user;"; $sql .= "SELECT * FROM mysql.user;" //use_resuly()/store_result()第一個(gè)結(jié)果集 //通過more_result檢查是否有更多的結(jié)果集 //next_result()將結(jié)果集指針向下移動一位。 $mysqli->multi_query($sql) if($mysqli->multi_query($sql)){ do{ if($mysqli_result=$mysqli->storage_result()){ $rows[]=$muysqli_result->fetch_all(MYSQLI_ASSOC); } WHILE($mysqli->more_results()&&mysqli->next_results()); } }查看全部
-
$mysqli = new mysqli('localhost','root','test') if($mysqli->connect_errno){ die("connect error"$mysqli->connect_error); } $sql = "select ID,username,age from user" $mysqli_result=$mysqli->auery($sql); if($mysqli_result && $mysqli_tesult->num_rows>0){ while($row = $mysqli_result->fetch_assoc()){ $row[]=$row; } }查看全部
舉報(bào)
0/150
提交
取消