Check if array is empty [duplicate]

Question

The following code shows an array of records in the $rows array from the MySQL query. I have added also an if statement to check if $rows turns up empty, but it is not working.

$rows = array();

$result1 = mysql_query("SELECT * FROM TestPhase where Pid<10", $db) or die("cannot select");
while($row = mysql_fetch_array($result1)) {
  $rows []= array(
    'id' => $row['id'],
    'parent' => $row['parent'],
    'name' => $row['name'],
  );

}


if($rows == ""){
    echo "No Data";

    }

This if statement is not working. How do I check if the array returns empty and echo "No Data".

How would I check to see if the array is empty in javascript? I have placed the $rows array in a var treeData.

if (treeData) is empty{
$("button").hide();
     }

How do I check if treeData is empty to hide the button.

How did you place the data from php into javascript? With json or from php? — Awemo
– Awemo, Commented Sep 25, 2012 at 15:20

Havelock · Accepted Answer · 2012-09-26 09:12:56Z

28

PHP
Simply use empty(), i.e.

if(empty($rows)){
    echo 'No Data';
}

Alternatively you could also use count(), i.e.

if(count($rows) < 1){ // or if(count($rows) === 0)
    echo 'No Data';
}

JavaScript
You can use the length property

if(treeData.length == 0){
    $("button").hide();
}

edited Sep 26, 2012 at 9:12

answered Sep 25, 2012 at 14:46

Havelock

7,0044 gold badges37 silver badges42 bronze badges

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

1 Comment

user1684586 Over a year ago

Thanks this worked great. But please see the updated question. How do I do this in javascript?

Muthu Kumaran · Accepted Answer · 2012-09-25 15:53:25Z

3

Use count to check

if(!count($rows)){
    echo "No Data";
}

Using JavaScript, here is the example

var arr = new Array('one', 'two', 'three'); //assume you have list of values in array
if(!arr.length){ //if no array value exist, show alert()
   alert('No Data');
}

edited Sep 25, 2012 at 15:53

answered Sep 25, 2012 at 14:46

Muthu Kumaran

18k5 gold badges50 silver badges72 bronze badges

Comments

BenM · Accepted Answer · 2012-09-25 14:46:49Z

1

You can't treat an array like a string (i.e. $rows == ""). Use count() or empty() instead:

if(count($rows) == 0)
{
    echo "No Data";
}

answered Sep 25, 2012 at 14:46

BenM

53.3k26 gold badges116 silver badges172 bronze badges

Comments

moonwave99 · Accepted Answer · 2012-09-25 14:46:54Z

0

Use empty:

if( empty( $rows) ) { ... }

answered Sep 25, 2012 at 14:46

moonwave99

22.9k3 gold badges48 silver badges71 bronze badges

Comments

Gustav Barkefors · Accepted Answer · 2012-09-25 14:46:57Z

0

if ( count( $rows ) == 0 ) {...}

answered Sep 25, 2012 at 14:46

Gustav Barkefors

5,0861 gold badge29 silver badges30 bronze badges

Collectives™ on Stack Overflow

Check if array is empty [duplicate]

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Linked

Related