mysqli_fetch_all raising undefined function error in PHP 7.3

Asked May 12 '20 at 17:47

Active May 12 '20 at 22:43

Viewed 18 times

I'm trying to get my website working publicly (my host is Namecheap), but I'm having some trouble with my sign-in-page. After I submit my log-in-form 500 Internal Server Error appears. I checked my error logs and found the following error:

PHP Fatal error:  Uncaught Error: Call to undefined function mysqli_fetch_all()

My PHP version is 7.3 and I have mysqlnd on. Here is the line that raises the error:

$user_data = mysqli_fetch_all($query_result, MYSQLI_ASSOC)[0];

$query result is the value of this expression:

mysqli_query($conn, "SELECT * FROM `users` WHERE `email` = '$email';");

The website works flawlessly locally using XAMPP.

edited May 12 '20 at 22:43

Dharman

30,962
25
85
135

asked May 12 '20 at 17:47

Juho Pesonen

1

Think about moving to PDO https://www.php.net/manual/en/pdostatement.fetchall.php – AbraCadaver May 12 '20 at 17:51
@Dharman Thanks for informing me. I wasn't aware of ```mysqli_real_escape_string``` not being enough necessary. – Juho Pesonen May 17 '20 at 18:12

mysqli_fetch_all raising undefined function error in PHP 7.3

0 Answers0