Check if the fetched array is empty or not PHP?

Question

I am trying to check if the mysql_fetch_array() function returns an empty array or not. But my code doesn't seem to work. Here I want to ensure that if the array is empty I want to display under construction message.

Code :

$queryContents= queryMembers();
$exeQuery = mysql_query($queryContents);
while($fetchSet = mysql_fetch_array($exeQuery)) {
   if(count($fetchSet) == 0) {
     echo "This Page is Under Construction";
   }else{
     // something else to display the content
   }
}

How do I check to acheive such feature ?

What is in $fetchSet? (try a var_dump() and inspect)

Chris Trahey
– Chris Trahey

2012-08-03 06:50:27 +00:00
Commented Aug 3, 2012 at 6:50 — Chris Trahey
– Chris Trahey, Commented Aug 3, 2012 at 6:50

pahan · Accepted Answer · 2012-08-03 07:03:47Z

14

use mysql_num_rows to count number of rows. try this.

$exeQuery = mysql_query($queryContents);

if(mysql_num_rows($exeQuery)== 0){
   echo "This Page is Under Construction";
}
else{
   while($fetchSet = mysql_fetch_array($exeQuery)) {

     // something else to display the content

   }
}

edited Aug 3, 2012 at 7:03

answered Aug 3, 2012 at 6:49

pahan

2,4531 gold badge28 silver badges37 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 20:38:18Z

5

You really should be using mysql_num_rows https://www.php.net/manual/en/function.mysql-num-rows.php

However, on a side note, you should use php empty() instead. https://www.php.net/empty

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Aug 3, 2012 at 6:49

jeremy

10.1k4 gold badges41 silver badges61 bronze badges

Comments

SHAKIR SHABBIR · Accepted Answer · 2012-08-03 07:13:01Z

4

When you use mysql_fetch_array(), it returns the rows from the data set one by one as you use the while loop.

If there will be no record, while loop wont execute. In this case, declare a boolean variable and make it true if it enters the while loop. Like:

$queryContents= queryMembers();
$exeQuery = mysql_query($queryContents);
$recordExists = 0;
while($fetchSet = mysql_fetch_array($exeQuery)) {
     if($recordExists == 0 )
       $recordExists = 1;
     // something else to display the content

}

if($recordExists == 0 ){
    echo "This Page is Under Construction";
}

Hope this works!

edited Aug 3, 2012 at 7:13

answered Aug 3, 2012 at 6:53

SHAKIR SHABBIR

1,2952 gold badges14 silver badges28 bronze badges

3 Comments

pahan Over a year ago

what is the point of running the loop if there are no results?

SHAKIR SHABBIR Over a year ago

You are absolutely right. This was just another implementation. However, yours good! or to be specific, your;s right!

pahan Over a year ago

I am not trying to say my answers is the only way of doing this. here if the number of rows are 0 there is no need of going to a while loop. so it is more efficient to have inside else part.

Prasanth · Accepted Answer · 2012-08-03 06:52:18Z

1

You can do it this way:

while($r[]=mysql_fetch_array($sql));
// now $r has all the results
if(empty($r)){
  // do something
}

source: php doc

answered Aug 3, 2012 at 6:52

Prasanth

5,2962 gold badges31 silver badges63 bronze badges

Comments

AndrewR · Accepted Answer · 2012-08-03 06:55:42Z

0

Your code inside the while loop never runs if there are no results. mysql_fetch_array returns null/false if there are no more results. What you need yo do is check with mysql_num_rows first, before the while.

$queryContents= queryMembers();
$exeQuery = mysql_query($queryContents);

 if(mysql_num_rows ($exeQuery) == 0) {
     echo "This Page is Under Construction";
 }

while($fetchSet = mysql_fetch_array($exeQuery)) {
    // something else to display the content
}

answered Aug 3, 2012 at 6:55

AndrewR

6,7781 gold badge26 silver badges38 bronze badges

1 Comment

pahan Over a year ago

what is the point of running the loop if there are no results?

Bhuvan Rikka · Accepted Answer · 2012-08-03 07:01:08Z

0

Try this

if(empty($fetchSet) 
{
   echo "This Page is Under Construction";
}
else
{
 // something else to display the content
}

edited Aug 3, 2012 at 7:01

answered Aug 3, 2012 at 6:49

Bhuvan Rikka

2,7031 gold badge19 silver badges28 bronze badges

Collectives™ on Stack Overflow

Check if the fetched array is empty or not PHP?

6 Answers 6

Comments

Comments

3 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

3 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related