mysqli_query() expects parameter 1 to be mysqli, null given
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in H:\Software\wamp\www\shop\lib\mysql.func.php on line 74
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in H:\Software\wamp\www\shop\lib\mysql.func.php on line 75
上面是網頁錯誤的信息 下面是代碼:
鏈接數據庫
function connect(){
$link=mysqli_connect(DB_HOST,DB_USER,DB_PWD) or die("數據庫連接失敗Error:".mysql_errno().":".mysql_error());
mysqli_set_charset($link,DB_CHARSET);
mysqli_select_db($link,DB_DBNAME) or die("指定數據庫打開失敗");
? return $link;
?}
搜索指定的一條記錄
function fetchOne($sql,$result_type=MYSQLI_ASSOC){
$result_type=mysqli_query($link, $sql);
$row=mysqli_fetch_array($result, $result_type);
return $row;
}
2016-05-19
function fetchOne($link,$sql,$result_type=MYSQLI_ASSOC);
2016-03-29
$result_type=mysqli_query($link, $sql);
$row=mysqli_fetch_array($result, $result_type);
應該將$result_type=mysqli_query($link, $sql);改為$result=mysqli_query($link, $sql);