EW123 Posted December 20, 2014 Share Posted December 20, 2014 Hi I am a student who is fairly new to PHP and MySQL. I have been working on creating a registration page for a website and I'm getting the following warnings when I've tested the page: Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/ed12e2w/public_html/COMM2735/dynamic_website/registration.php on line 74Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/ed12e2w/public_html/COMM2735/dynamic_website/registration.php on line 80 I think that my query has failed but I'm not completely sure on what to change in order to solve this. Here is the section of code I'm having problems with: register.php Link to comment https://forums.phpfreaks.com/topic/293200-help-warning-mysqli_fetch_array-expects-parameter-1-to-be-mysqli_result/ Share on other sites More sharing options...
Barand Posted December 20, 2014 Share Posted December 20, 2014 That error message is generally a result of your query failing due to an error. See what mysqli_error contains http://php.net/manual/en/mysqli.error.php Link to comment https://forums.phpfreaks.com/topic/293200-help-warning-mysqli_fetch_array-expects-parameter-1-to-be-mysqli_result/#findComment-1500189 Share on other sites More sharing options...
Frank_b Posted December 20, 2014 Share Posted December 20, 2014 A little warning: if your query works fine but the user was not found in the table then you won't get an error. Instead you will get your result with zero rows! You can use mysqli_num_rows($result); to test if there would be a row available. Link to comment https://forums.phpfreaks.com/topic/293200-help-warning-mysqli_fetch_array-expects-parameter-1-to-be-mysqli_result/#findComment-1500196 Share on other sites More sharing options...
EW123 Posted December 21, 2014 Author Share Posted December 21, 2014 Thank you! Link to comment https://forums.phpfreaks.com/topic/293200-help-warning-mysqli_fetch_array-expects-parameter-1-to-be-mysqli_result/#findComment-1500263 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.