how to check empty array from mysql in php

Question

I have an array in php, this array is fetched from database. sometimes the array structure is like

array(""=>NULL)

but sometimes it's also contain actual data from the DB. but one thing for sure, it is never be an empty array (array())

how do i check if array is contain actual data?.

Awlad Liton · Accepted Answer · 2014-03-05 05:42:28Z

2

check that array size ==1 and it contains a "" array key and NULL is in the array.

Try like this:

   if(array_key_exists("",$array) && count($array) == 1 && in_array(NULL,$array)){
    echo "invalid";
   }

demo

edited Mar 5, 2014 at 5:42

answered Mar 5, 2014 at 5:34

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

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

Comments

Nishant Solanki · Accepted Answer · 2014-03-05 05:40:37Z

1

if you are using mysql use mysql_num_rows().. this will give you the count of fetched results from table .. so if the count is 0 than your array is empty....

or you are using PDO than use PDOstatement->rowCount() ... and if you are using mysqli than use mysqli_num_rows to get the count...

edited Mar 5, 2014 at 5:40

answered Mar 5, 2014 at 5:33

Nishant Solanki

2,1283 gold badges19 silver badges32 bronze badges

6 Comments

Marty Over a year ago

Yes, use a deprecated method (no, don't really do this).

Nishant Solanki Over a year ago

but he havent provided wether he is using mysql , mysqli or pdo.. Than I would have suggested different function..

Marty Over a year ago

I would update your answer to demonstrate the correct approach with both mysqli and PDO, and put your current answer underneath while flagging that it's deprecated.

Jay Bhatt Over a year ago

PDO rowCount() is not reliable and its use is not suggested.

Dariel Pratama Over a year ago

i forget to say that the value of the column is a serialized array. in select statement i select that field. i don't figure out yet why it always have count() > 0 (probably my bad coding). for now i use @Awlad Liton answer

|

Community · Accepted Answer · 2023-11-20 22:45:59Z

0

You can simply do this.

if ($arr) {
  // there was an error
} else {
  // there wasn't
}

According to PHP Manual the array to Boolean conversion will return false if the array contains only "NULL" as the value.

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Mar 5, 2014 at 5:46

Jay Bhatt

5,6715 gold badges44 silver badges66 bronze badges

Comments

Rajeev Ranjan · Accepted Answer · 2014-03-05 05:47:02Z

0

A very simple answer using php native functions

$input_array = array(""=>NULL);
$is_error=array_filter($input_array);
if (!empty($is_error)) {
    // do your stuff here
}

answered Mar 5, 2014 at 5:47

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

Comments

Boopathi Rajan · Accepted Answer · 2014-03-05 05:35:25Z

-1

try this

if (!empty($result)
{
.....
}

answered Mar 5, 2014 at 5:35

Boopathi Rajan

1,2002 gold badges16 silver badges39 bronze badges

Collectives™ on Stack Overflow

how to check empty array from mysql in php

5 Answers 5

Comments

6 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

6 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related