If Array is Empty PHP - Highcharts [duplicate]

Question

I am creating a form to filter the data on my database (Mysql) with queries based on the user's selections.

I am using this code to generate the "data.json" file:

How can I improve the code and check if the array returns empty values? and instead of drawing a chart without bars tells the user to change the selections.

 <?php
   $rows1 = array();
       $rows1['name'] = $varLabel;
       while($rr = mysqli_fetch_array($TableData)) {
       $rows1['data'][] = $rr[$varLabel];
      }

      $rows = array();
      $rows['name'] = "Registros";
      foreach($TableData as $r) {
        settype($r['cnt'], "integer");
        $rows['data'][] = $r['cnt'];

      } 
      $result = array();
      array_push($result,$rows);
      array_push($result,$rows1);

      file_put_contents("data.json", json_encode($result));

?>

Hanky Panky · Accepted Answer · 2015-05-20 17:40:18Z

2

Since your array is created by looping over your database result set which you access using mysqli, Use mysqli_num_rows

if(mysqli_num_rows($TableData)==0)
{
       // no data
}

answered May 20, 2015 at 17:40

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

If Array is Empty PHP - Highcharts [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related