問題描述
感謝答案，我發現我無法使用 fetch_all() 因為我使用的是 PHP 5.2.17 - fetch_assoc> 使用 while 循環工作.
Thanks to the answers I have figured out that I am unable to use fetch_all() because i am using PHP 5.2.17 - fetch_assoc with while loop worked.
我正在使用的函數 fetch_all 返回此錯誤:
The function I am using fetch_all is coming back with this error:
致命錯誤:調用未定義的方法mysqli_result::fetch_all()
Fatal error: Call to undefined method mysqli_result::fetch_all() in
$mysqli = new mysqli($host, $username, $password, $database);
$query = "LONG QUERY that works, tested in phpmyadmin"
$result = $mysqli->query($query);
$result->fetch_all(); or $mysqli->fetch_all() tried both
mysqli_fetch_all() was already tried.
$mysqli->close();
我能夠連接到數據庫并且我已經提取了單行.當我將查詢放在 PHPMYADMIN 中時，我得到 5 行.
I am able to connect to the DB and I have pulled single rows. When I place the query in PHPMYADMIN I get 5 rows back.
這個功能還能用嗎?有沒有辦法可以自己將數據放入關聯數組中?
Does this function even work? Is there a way I can place my data into an assoc array on my own?
推薦答案
該函數自 PHP 5.3.0 起可用.可能你的版本比較舊.改用 fetch_assoc().
This function is available since PHP 5.3.0. Possibly your version is older. Use fetch_assoc() instead.
while ($row = $result->fetch_assoc()) {
// do what you need.
}
這篇關于mysqli fetch_all() 不是一個有效的函數?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！