MYSQLI_NUM_ROWS THROWS SERVER ERROR

Question

Can someone please explain to me why I keep getting the following error when I use the mysqli_num_rows() function?

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Here is my php script:

   <?php

    //stores user input as variable
    $username = $_POST['username'];
    $password = $_POST['password'];

    //selects from users table
    $sql = "SELECT * FROM Members WHERE username='$username' and password='$password'";
    $results = mysqli_query($con,$sql);

    $count = mysqli_num_rows($results);
    /*//starts session and sets cookie if count is true
    if($count>=1)
    {
        session_start();
        $_SESSION['username'] = ' ';
        $_SESSION['password'] = ' ';

        header("location: index.html"); 
    }
    //returns message if user input does not match database
    else
    {
        echo "Invalid username or password";
    }*/
    ?>

I get this error at the mysqli_num_rows() function everything before it works fine. I am using Plesk on a Godaddy server by the way.

first thing if your mysql login details are real then change them to fake one. Never post real details in public forum. — Abhik Chakraborty, Apr 21 '14 at 18:00

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

You need to learn how to read php and mysqli errors
You need to learn how to use mysqli properly
You don't heed this function at all

How to get mysqli error in different environments? for the first
and How can I prevent SQL injection in PHP? for the second
just fetch your data and use it as a flag for the last

edited May 23 '17 at 12:05

Community

1
1

answered Apr 21 '14 at 18:02

Your Common Sense

156,878
40
214
345

score -1 · Answer 2 · answered Apr 21 '14 at 18:03

-1

As far as I can see there is no function as mysqli_num_rows().

answered Apr 21 '14 at 18:03

user1402647

480
4
9

score -1 · Answer 3 · answered Apr 21 '14 at 18:04

-1

Is the $con variable declared elsewhere? I don't see it being declared. Also, you are subject to injection attacks with this current code. Make sure you escape your parameters before using this publicly.

answered Apr 21 '14 at 18:04

Paronity

372
2
12

i have it declared i did not post it to protect my information it is valid though it works on my other scripts. This is just a site for school so I am not to worried about injection since it will be coming down in a week. – Brandon Apr 21 '14 at 18:06
You could try doing a var_dump on the results to see what (if anything) the object looks like. Could point you in the right direction. – Paronity Apr 21 '14 at 18:33

MYSQLI_NUM_ROWS THROWS SERVER ERROR

3 Answers3