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 Quote 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 (edited) 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 Edited December 20, 2014 by Barand Quote 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. Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.