PHP output contains two spaces even no results found

Question

I use below php code to send results of MYSQL databse search to AJAX requests...

$query = $db->query("SELECT name FROM search WHERE qurl = '" . $queryString . "'");


if($query) {

    while ($result = $query ->fetch_object()) {             
           echo $result->name; 
    }
} else { echo 'no results found'; }

but I never get no results found message even there is no results, all I get if there is no result, two empty spaces - I found that using alert(data.length) in AJAX page, result was 2 which means php output has two empty spaces when there is no results...

but when there are results it works fine...

any way of removing these two spaces or why Im not getting no results found message?

I do hope $queryString is properly sanitized, because if it isn't, you're missing the whole point, and should be using prepared statements. — Madara's Ghost
– Madara's Ghost, Commented Nov 28, 2012 at 20:59

Barmar · Accepted Answer · 2012-11-28 20:57:25Z

3

if ($query->num_rows > 0) {
  while ...
} else {
  echo 'no results found';
}

$db->query() only returns false if there was an error performing the query. An empty result set is not an error.

answered Nov 28, 2012 at 20:57

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

2 Comments

Naveen Gamage Over a year ago

Yes, I tried it before but I get this error.. Fatal error: Call to undefined method mysqli_result::num_rows() in C:\wamp\www\7\load.php on line 18

Barmar Over a year ago

Corrected. It's a property, not a method.

Benjamin Powers · Accepted Answer · 2012-11-28 20:57:15Z

0

What you are evaluating is if the statement is valid... which it is, and will always return true. To evaluate the results returned, you'll need to evaluate $query->num_rows

answered Nov 28, 2012 at 20:57

Benjamin Powers

3,2862 gold badges21 silver badges23 bronze badges

2 Comments

Naveen Gamage Over a year ago

I tried using num_row but I get a error.. error is Fatal error: Call to undefined method mysqli_result::num_rows() in C:\wamp\www\7\load.php on line 18

Benjamin Powers Over a year ago

The answer above had parenthesis... make sure you don't have those. php.net/manual/en/mysqli-result.num-rows.php

Collectives™ on Stack Overflow

PHP output contains two spaces even no results found

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related