PHP DB Connection questions

Question

I am getting the error:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/mjcrawle/public_html/home/index.php on line 23

Line 23 turns out to be $num_results = mysqli_num_rows($result); but I am thinking the error is further up but I am having trouble finding it.

The actual code that I am using to connect to the DB is (I do understand there is a redundancy if the database cannot connect):

Any help would be wonderful and a reason for the error would be awesome!

/*Connect To DB*/
$conn = mysqli_connect($host, $user, $pwd)
        or die("Could not connect: " . mysql_error()); //connect to server
    mysqli_select_db($conn, $database)
        or die("Error: Could not connect to the database: " . mysql_error());

    /*Check for Connection*/
    if(mysqli_connect_errno()){
        /*Display Error message if fails*/
        echo 'Error, could not connect to the database please try again later.';
    exit();
    }

/* Query for states */
$query = "SELECT StateAbbreviation, StateName, FROM USState ORDER BY StateName";
$result = mysqli_query($conn, $query);
$num_results = mysqli_num_rows($result);
?>

emco · Accepted Answer · 2011-03-25 02:28:57Z

3

You have an extra comma before the FROM in query = "SELECT StateAbbreviation, StateName, FROM USState ORDER BY StateName";, you may be getting an error and not having a result when you execute the query.

answered Mar 25, 2011 at 2:28

emco

4,7493 gold badges20 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

timdev · Accepted Answer · 2011-03-25 02:32:39Z

0

If the query fails, mysqli_query returns boolean false

After $result = mysqli_query($conn, $query);, you should test the return value before continuing:

if ( ! $result){
   $error = mysqli_error($conn);
   //do something with the error message
}

See EmCo's answer for why your query is failing.

answered Mar 25, 2011 at 2:32

timdev

63.1k6 gold badges86 silver badges93 bronze badges

1 Comment

Marc B Over a year ago

better to check if ($result !== FALSE). If for whatever reason mysqli_query could return a 0, your test would indicate it failed, though only an actual boolean FALSE indicates that.

Vijayendran.R · Accepted Answer · 2015-09-05 12:00:25Z

0

<?php $con=mysqli_connect('localhost','root','','dbname') or die ("Connection Failed"); ?>

This is the simple method of DB Connection

edited Sep 5, 2015 at 12:00

answered Jul 22, 2015 at 10:30

Vijayendran.R

413 bronze badges

Collectives™ on Stack Overflow

PHP DB Connection questions

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related