$connect = mysqli_connect("host","user","password","db") or die("Error " . mysqli_error($connect));$result = mysql_query('select * from admin',$connnet);print(mysql_num_rows($result));mysql_close();
報錯:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resourceWarning: mysql_num_rows(): supplied argument is not a valid MySQL result resourceWarning: mysql_close(): no MySQL-Link resource supplied
而使用物件導向方法則沒有問題
請問這是什麼問題?
回複內容:
$connect = mysqli_connect("host","user","password","db") or die("Error " . mysqli_error($connect));$result = mysql_query('select * from admin',$connnet);print(mysql_num_rows($result));mysql_close();
報錯:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resourceWarning: mysql_num_rows(): supplied argument is not a valid MySQL result resourceWarning: mysql_close(): no MySQL-Link resource supplied
而使用物件導向方法則沒有問題
請問這是什麼問題?
因為你寫錯字母了...
第一個變數是 $connect
第二個變數是 $connnect
多了一個n,好不?
當然,也要用mysqli_query而不是mysql_query
mysql_query -> mysqli_query
mysql_num_rows -> mysqli_num_rows
mysql_close -> mysqli_close
哥們你用mysqli_connect建立的串連得用mysqli_xxx來用
mysqli_xxx和mysql_xxx是不能混用的