php mysqli怎么查詢數(shù)據(jù)庫

php mysqli查詢數(shù)據(jù)庫的方法：首先通過mysqli生成一個連接；然后通過select語句獲取查詢結(jié)果；最后通過while循環(huán)取出記錄即可。

本文操作環(huán)境：windows7系統(tǒng)、PHP7.1版，DELL G3電腦

php mysqli怎么查詢數(shù)據(jù)庫?

phpmysqli連接查詢數(shù)據(jù)

mysqli：

<?php  $code = $_POST['code']; $status = ""; $success = ""; $scookies = ""; try {     $dbname="root";     $dbpass="root";     $dbhost="127.0.0.1";     $dbdatabase="mysql";       //生成一個連接     $db_connect= new mysqli($dbhost,$dbname,$dbpass,$dbdatabase);     // 獲取查詢結(jié)果     $strsql="select * from `go_member_addmoney_record` where `code` = '$code' limit 1";     $result=$db_connect->query($strsql);     // 循環(huán)取出記錄     while ($row=mysqli_fetch_assoc($result))     {      $status = $row['status'];      $scookies = $row['scookies'];     }     // 釋放資源     $result->close();     // 關(guān)閉連接     $db_connect->close();     if($status=="已付款"){         $success = "success";     }     else{         $success = "faild";     }      echo $success.";".$scookies; } catch (Exception $e){}

推薦學(xué)習(xí)：《PHP視頻教程》