e-mazed Posted February 13, 2012 Share Posted February 13, 2012 HI I have completed chapter 4 and when I try and test my login script i get the following error, I have re-done my Login.inc.php script and and login_form.inc.php but still get the following error: An error occurred in script '/Applications/MAMP/htdocs/html/includes/login.inc.php' on line 16: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given Array ( [0] => Array ( [function] => my_error_handler [args] => Array ( [0] => 2 [1] => mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [2] => /Applications/MAMP/htdocs/html/includes/login.inc.php [3] => 16 [4] => Array ( [GLOBALS] => Array *RECURSION* [_ENV] => Array ( [sHELL] => /bin/bash [TMPDIR] => /var/folders/fq/jj0y633n07d9c_98t1ymj26h0000gn/T/ [Apple_PubSub_Socket_Render] => /tmp/launch-GCuAgg/Render [__AUTHORIZATION] => auth 6 [uSER] => Booboo [COMMAND_MODE] => unix2003 [sSH_AUTH_SOCK] => /tmp/launch-2V4a3o/Listeners [__CF_USER_TEXT_ENCODING] => 0x1F5:0:0 [_BASH_IMPLICIT_DASH_PEE] => -p [PATH] => /usr/bin:/bin:/usr/sbin:/sbin [PWD] => / [HOME] => /Users/Booboo [sHLVL] => 2 [DYLD_LIBRARY_PATH] => /Applications/MAMP/Library/lib: [LOGNAME] => Booboo [DISPLAY] => /tmp/launch-mA8mph/org.x:0 [_] => /Applications/MAMP/Library/bin/httpd ) [HTTP_ENV_VARS] => Array ( [sHELL] => /bin/bash [TMPDIR] => /var/folders/fq/jj0y633n07d9c_98t1ymj26h0000gn/T/ [Apple_PubSub_Socket_Render] => /tmp/launch-GCuAgg/Render [__AUTHORIZATION] => auth 6 [uSER] => Booboo [COMMAND_MODE] => unix2003 [sSH_AUTH_SOCK] => /tmp/launch-2V4a3o/Listeners [__CF_USER_TEXT_ENCODING] => 0x1F5:0:0 [_BASH_IMPLICIT_DASH_PEE] => -p [PATH] => /usr/bin:/bin:/usr/sbin:/sbin [PWD] => / [HOME] => /Users/Booboo [sHLVL] => 2 [DYLD_LIBRARY_PATH] => /Applications/MAMP/Library/lib: [LOGNAME] => Booboo [DISPLAY] => /tmp/launch-mA8mph/org.x:0 [_] => /Applications/MAMP/Library/bin/httpd ) [_POST] => Array ( => info@e-mazed.com [pass] => Fairmont0302 ) [HTTP_POST_VARS] => Array ( => info@e-mazed.com [pass] => Fairmont0302 ) [_GET] => Array ( ) [HTTP_GET_VARS] => Array ( ) [_COOKIE] => Array ( [phpSESSID] => b0d81cd727b5673a2ede40c1752e3524 ) [HTTP_COOKIE_VARS] => Array ( [phpSESSID] => b0d81cd727b5673a2ede40c1752e3524 ) [_SERVER] => Array ( [HTTP_HOST] => localhost [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:9.0.1) Gecko/20100101 Firefox/9.0.1 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7 [HTTP_CONNECTION] => keep-alive [HTTP_REFERER] => http://localhost/html/includes/register.php [HTTP_COOKIE] => PHPSESSID=b0d81cd727b5673a2ede40c1752e3524 [CONTENT_TYPE] => application/x-www-form-urlencoded [CONTENT_LENGTH] => 42 [PATH] => /usr/bin:/bin:/usr/sbin:/sbin [sERVER_SIGNATURE] => [sERVER_SOFTWARE] => Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8r DAV/2 PHP/5.3.6 [sERVER_NAME] => localhost [sERVER_ADDR] => ::1 [sERVER_PORT] => 80 [REMOTE_ADDR] => ::1 [DOCUMENT_ROOT] => /Applications/MAMP/htdocs [sERVER_ADMIN] => you@example.com [sCRIPT_FILENAME] => /Applications/MAMP/htdocs/html/includes/index.php [REMOTE_PORT] => 52089 [GATEWAY_INTERFACE] => CGI/1.1 [sERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => POST [QUERY_STRING] => [REQUEST_URI] => /html/includes/index.php [sCRIPT_NAME] => /html/includes/index.php [php_SELF] => /html/includes/index.php [REQUEST_TIME] => 1329160928 [argv] => Array ( ) [argc] => 0 ) [HTTP_SERVER_VARS] => Array ( [HTTP_HOST] => localhost [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:9.0.1) Gecko/20100101 Firefox/9.0.1 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5 [HTTP_ACCEPT_ENCODING] => gzip, deflate [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7 [HTTP_CONNECTION] => keep-alive [HTTP_REFERER] => http://localhost/html/includes/register.php [HTTP_COOKIE] => PHPSESSID=b0d81cd727b5673a2ede40c1752e3524 [CONTENT_TYPE] => application/x-www-form-urlencoded [CONTENT_LENGTH] => 42 [PATH] => /usr/bin:/bin:/usr/sbin:/sbin [sERVER_SIGNATURE] => [sERVER_SOFTWARE] => Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8r DAV/2 PHP/5.3.6 [sERVER_NAME] => localhost [sERVER_ADDR] => ::1 [sERVER_PORT] => 80 [REMOTE_ADDR] => ::1 [DOCUMENT_ROOT] => /Applications/MAMP/htdocs [sERVER_ADMIN] => you@example.com [sCRIPT_FILENAME] => /Applications/MAMP/htdocs/html/includes/index.php [REMOTE_PORT] => 52089 [GATEWAY_INTERFACE] => CGI/1.1 [sERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => POST [QUERY_STRING] => [REQUEST_URI] => /html/includes/index.php [sCRIPT_NAME] => /html/includes/index.php [php_SELF] => /html/includes/index.php [REQUEST_TIME] => 1329160928 [argv] => Array ( ) [argc] => 0 ) [_FILES] => Array ( ) [HTTP_POST_FILES] => Array ( ) [_REQUEST] => Array ( => info@e-mazed.com [pass] => (removed for post) [phpSESSID] => b0d81cd727b5673a2ede40c1752e3524 ) [live] => [contact_email] => info@e-mazed.com [HTTP_SESSION_VARS] => Array ( ) [_SESSION] => Array ( ) [dbc] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.9 [client_version] => 50509 [connect_errno] => 0 [connect_error] => [errno] => 1064 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM users WHERE (email='info@e-mazed.com' and pass'ځ?,??~W|څ????Lԏ,??,t' at line 1 [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.9 [server_version] => 50509 [sqlstate] => 42000 [protocol_version] => 10 [thread_id] => 34 [warning_count] => 0 ) [login_errors] => Array ( ) [e] => info@e-mazed.com [p] => (removed for post) [q] => SELECT id, username, type, IF(date_expries>NOW(), true, FROM users WHERE (email='info@e-mazed.com' and pass'ځ�,��~W|څ����Lԏ,�,t���\\) [r] => ) ) ) [1] => Array ( [file] => /Applications/MAMP/htdocs/html/includes/login.inc.php [line] => 16 [function] => mysqli_num_rows [args] => Array ( [0] => ) ) [2] => Array ( [file] => /Applications/MAMP/htdocs/html/includes/index.php [line] => 19 [args] => Array ( [0] => /Applications/MAMP/htdocs/html/includes/login.inc.php ) [function] => include ) ) Knowledge is Power and it pays to know Home About Contact Register Welcome Welcome to Knowledge is Power, a site dedicated to keeping you up to date on the Web security and programming information you need to know. Blah, blah, blah. Yadda, yadda, yadda. Login The email address and password do not match those on file. Email Address Password Forgot? Content Site Map | Policies © Knowledge is Power | Design by spyka webmaster Link to comment Share on other sites More sharing options...
Larry Posted February 13, 2012 Share Posted February 13, 2012 If you look at your query, you'll see that you have a syntax error. This book does assume comfort with PHP and MySQL, by the way. Link to comment Share on other sites More sharing options...
Recommended Posts