how to check if mysql query return no result(record not found) using php?

Question

i am passing images file names via textarea to php script to find information about each image in mysql db .The problem is i am trying to output those image file names that not found in mysql db and inform the user which image file names not found in mysql. my current code fails to output those missing records in db but it correctly outputs information about those images found in db. could any one tell me what i am doing wrong ?

foreach ($lines as $line) {


$line = rtrim($line);


$result = mysqli_query($con,"SELECT ID,name,imgUrl,imgPURL FROM testdb WHERE imgUrl like '%$line'");            



 if (!$result) {
             die('Invalid query: ' . mysql_error());
            }
//echo $result;

  if($result == 0) 
    {

       // image not found, do stuff..
      echo "Not Found Image:".$line; 
    }



while($row = mysqli_fetch_array($result))
  {
  $totalRows++;

  echo "<tr>";
  echo "<td>" . $row['ID'] ."(".$totalRows. ")</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['imgPURL'] . "</td>";
  echo "<td>" . $row['imgUrl'] . "</td>";  echo "</tr>";


}

};

echo "</table>";

echo "<br>totalRows:".$totalRows;

ʇolɐǝz ǝɥʇ qoq · Accepted Answer · 2017-06-09 03:58:08Z

21

You can use mysqli_num_rows() in mysqli

if(mysqli_num_rows($result) > 0){

    while($row = mysqli_fetch_array($result))
    {
        $totalRows++;

        echo "<tr>";
        echo "<td>" . $row['ID'] ."(".$totalRows. ")</td>";
        echo "<td>" . $row['name'] . "</td>";
        echo "<td>" . $row['imgPURL'] . "</td>";
        echo "<td>" . $row['imgUrl'] . "</td>";  
        echo "</tr>";         
    }
} else {
    echo "<tr><td colspan='4'>Not Found Image:".$line.'</td></tr>';
}

edited Jun 9, 2017 at 3:58

ʇolɐǝz ǝɥʇ qoq

7421 gold badge16 silver badges31 bronze badges

answered Nov 19, 2013 at 4:17

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

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

1 Comment

user1788736 Over a year ago

thanks all for replies. @Chinu R your solution worked well now i could inform the user about missing records!

Machavity · Accepted Answer · 2013-11-19 04:17:05Z

2

You want to use mysqli_num_rows

if(mysqli_num_rows($result)) {
   // Do your while loop here
}

answered Nov 19, 2013 at 4:17

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 20:42:18Z

0

Use mysqli_num_rows to compare the number of rows in the result set.

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Nov 19, 2013 at 4:17

esqew

45k28 gold badges139 silver badges180 bronze badges

Collectives™ on Stack Overflow

how to check if mysql query return no result(record not found) using php?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related