php: how to check if array is empty

Question

How to tell if a php array is empty? i tried different methods but it never gets to echo "no content";

while($row = mysql_fetch_array($result))
  {
        if(count($row['link']))
        {
                echo '<a id="link_' . $row['Id'] . '" href="' . $row['link'] . '" data="/short_info.php?id=' . $row['Id'] . '/">' . $row['title'] . '</a><div class="in...
        }
        else
        {
                echo "no content";
        }
  }

Be aware that the mysql_xxx() functions are considered obsolete and insecure. It is recommended to switch to using the newer mysqli_xxx() functions, or the PDO library instead. See stackoverflow.com/questions/12859942/… — SDC
– SDC, Commented Dec 3, 2012 at 11:56

Michael Krelin - hacker · Accepted Answer · 2012-12-03 11:45:04Z

9

It is never empty. But when data is exhausted, mysql_fetch_array returns false and your loop ends, so you're not going to see it in the loop, anyway.

answered Dec 3, 2012 at 11:45

Michael Krelin - hacker

144k25 gold badges200 silver badges177 bronze badges

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

2 Comments

Hugo Delsing Over a year ago

Your awnser is correct. Unfortunatly it doesnt tell teslasimus how he should check it outside the loop.

Michael Krelin - hacker Over a year ago

Yes, I also find your answer useful. Strictly speaking, it is not even necessary to tell — you can handle no content situation if your loop body has never been executed. I am assuming the OP is acquainted with some programming basics, so what I was doing here is not doing programming for OP, but explaining the phenomenon.

Hugo Delsing · Accepted Answer · 2012-12-03 11:45:01Z

5

$row is an array. $row['link'] is just a string. So you could you use:

if (strlen($row['link'])==0) {
  //do something
}

But if you want to check for no result (no data rows from mysql) then you could use:

if (mysql_num_rows($result)==0)
  echo "no content"
else {
  //your while loop
}

answered Dec 3, 2012 at 11:45

Hugo Delsing

14.3k5 gold badges50 silver badges76 bronze badges

3 Comments

GolezTrol Over a year ago

If that is what you want, yes, but probably OP wants to check if a record was fetched.

Michael Krelin - hacker Over a year ago

+1, I also think the OP wants to see if there's any content at all. Why doing it in the loop is beyond me.

Hugo Delsing Over a year ago

I guess thats just basic knowledge. The difference between knowing what you write and trying to find the right parts from examples and tutorials. But thats what makes this site great, people tell you why you should do something and not just what to do.

Uttam Kadam · Accepted Answer · 2012-12-03 11:52:53Z

2

update your code like:

$num=mysql_num_rows($result);
    if ($num>0) {
        echo '$var is either 0, empty, or not set at all';
    }
    else{
        echo "no content";
    }

edited Dec 3, 2012 at 11:52

answered Dec 3, 2012 at 11:47

Uttam Kadam

4581 gold badge7 silver badges20 bronze badges

Comments

Shadi · Accepted Answer · 2012-12-03 11:48:49Z

1

if there is not any row returned from the query this code will never enter the while block because the condition is false .... you can write :

$num=mysql_num_rows($result);

this will return the rows num then you write :

if($num==0) {echo "no content";}
else
{
while(
.........
}

answered Dec 3, 2012 at 11:48

Shadi

1,5463 gold badges11 silver badges15 bronze badges

Collectives™ on Stack Overflow

php: how to check if array is empty

4 Answers 4

2 Comments

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related