Check if returned array from mysql is empty in php

Question

I've been trying to do this for a while but to no avail basically I have a function SelectRowByName that returns the mysql array result and I want to validate if it returns a record or not but it's not working. My code is:

$fileInfo = selectRowByName("SELECT ID,Mime,IconIMG FROM tblattachment_filetypes WHERE Active=1 AND Extension = '".$extension."'");

// I want to validate that $fileInfo got filled before trying to fill the below variables to avoid errors

$fileType = $fileInfo[1];
$fileTypeID = $fileInfo[0];
$fileIcon = $fileInfo[2];

I have tried using empty, isset and array count functions but they don't seem to work. Basically the query might not return any records and $fileInfo might not be filled and I want to validate that.

SelectRowByName code is:

      function selectRowByName($query)
      {
          global $server,$dbusername,$dbpassword,$db,$connection,$dbCon;
          $theQuery = mysql_query($query);
          $result = mysql_fetch_array($theQuery) or die(mysql_error());
          return $result;   
      }

As you can see, it is filled by 3 fields from a db record. but it won't be an array if it doesn't return a record, which is what im trying to do here. I tried using the is_array function but it also didn't work — Zakaria Alami
– Zakaria Alami, Commented Jul 19, 2013 at 12:12

David Jashi · Accepted Answer · 2013-07-19 12:12:09Z

1

Inside your SelectRowByName function you may use one of the following (depending on the way you access MySQL):

mysql_num_rows()
mysqli_stmt_num_rows()
PDOStatement::rowCount()

to get number of rows returned.

answered Jul 19, 2013 at 12:12

David Jashi

4,5091 gold badge23 silver badges26 bronze badges

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

4 Comments

Zakaria Alami Over a year ago

Can't I simply validate the returned variable?

David Jashi Over a year ago

"Simply" is not the word I would use in that case. You want working solution or your question is theoretical?

Zakaria Alami Over a year ago

:) I want a working solution, but I want the best solution that doesn't require additional db hits if possible

David Jashi Over a year ago

mysql_num_rows() and others do not make any additional calls to RDBMS. They are working on PHP's buffer.

Ryan Lund · Accepted Answer · 2013-07-19 12:20:54Z

1

This should do the trick:

function selectRowByName($query){
      $q=mysql_query($query);

      if($q!=false){
          $result=mysql_fetch_array($q);

          if(is_array($result)&&count($result)>0){
              return $result;
          }
          else{
              return false;
          }
      }
      else{
           return false;
      }
  }

I wouldn't exactly advise using this code though. Firstly the mysql_ functions are now deprecated so you would be better off using mysqli or PDO. The other thing is that this function is only able to return a singular row from the query.

Either way, hope this helps.

Ryan

edited Jul 19, 2013 at 12:20

answered Jul 19, 2013 at 12:13

Ryan Lund

1381 silver badge9 bronze badges

Collectives™ on Stack Overflow

Check if returned array from mysql is empty in php

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related