How to check if a MySQL result is empty

Question

    // Populate headers
    $fields = $result->fetch_fields();
    foreach ($fields as $field)
        printf("<th>%s</th>", $field->name);

    printf("</tr>");

    // Write to table
    while ($myvar = $result->fetch_row()) {

        $date = $myvar[0];
        $room_ID = $myvar[1];
        $description = $myvar[2];
        $firstname = $myvar[3];
        $lastname = $myvar[4];
        $message = $myvar[5];
        $period = $myvar[6];

        printf("<tr>");
        printf("<td>%s</td><td>%s</td>", $date, $room_ID);
        printf("<td>%s</td><td>%s</td>", $description, $firstname);
        printf("<td>%s</td><td>%s</td><td>%s</td>", $lastname, $message, $period);
        printf("</tr>");

  }

I'm trying to echo "No results to display" if my MySQLi result returns empty. The problem is the headers are returned as part of the array, how can I achieve this?

num_rows() would help. php.net/manual/en/mysqli-result.num-rows.php — Sougata Bose
– Sougata Bose, Commented Apr 25, 2016 at 11:14

sandeep soni · Accepted Answer · 2016-04-25 11:32:47Z

You need to check with number of rows. if it return zero it means table contain no rows. try below code.

// Populate headers
    $fields = $result->fetch_fields();
    foreach ($fields as $field)
        printf("<th>%s</th>", $field->name);

    printf("</tr>");

    // Write to table
    if($result->num_rows== 0){
     echo "No Result to display";
    }else{
    while ($myvar = $result->fetch_row()) {

        $date = $myvar[0];
        $room_ID = $myvar[1];
        $description = $myvar[2];
        $firstname = $myvar[3];
        $lastname = $myvar[4];
        $message = $myvar[5];
        $period = $myvar[6];

        printf("<tr>");
        printf("<td>%s</td><td>%s</td>", $date, $room_ID);
        printf("<td>%s</td><td>%s</td>", $description, $firstname);
        printf("<td>%s</td><td>%s</td><td>%s</td>", $lastname, $message, $period);
        printf("</tr>");

  }

}

KAREN · Accepted Answer · 2016-04-25 11:41:18Z

1

Simple use num_rows

  if($result->num_rows== 0){
 echo "no results to display"
  }
else{
  while ($myvar = $result->fetch_row()) {
  //Your Code here
 }

answered Apr 25, 2016 at 11:41

KAREN

3862 silver badges10 bronze badges

Comments

Ramalingam Perumal · Accepted Answer · 2016-04-25 13:23:16Z

1

You can use num_rows to get the total value of records.

$row_count = $result->num_rows;
if($row_count>0)
{ 
    echo "Data Available";
}
else
{
    echo "No Data Available";
}

answered Apr 25, 2016 at 13:23

Ramalingam Perumal

1,4283 gold badges18 silver badges47 bronze badges

Comments

marc_s · Accepted Answer · 2018-07-16 04:35:11Z

1

You can use num_rows to get the total value of records retrieved from the query.

$row_cnt = $result->num_rows;
if($row_cnt>0){ echo "Have data";}else{echo "No data";}

edited Jul 16, 2018 at 4:35

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 25, 2016 at 11:29

Mujahidh

4704 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to check if a MySQL result is empty

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related