how to count values in php array and while loop

Question

I'm using MySQL query "SELECT * FROM ..."

And a while loop:

$rtnjsonobj = array();  
while ($k = @mysql_fetch_array($tmp)) { 
   $rtnjsonobj['status'] = $k['status'];
   $rtnjsonobj['text'] = $k['text'];
   $data[] = $rtnjsonobj;  
}

I need to count all the values in this array that have status == 1. How can I do that?

You shouldn't be using mysql extension, but mysqli instead. mysql is deprecated by PHP. — Luka
– Luka, Commented Jul 31, 2014 at 17:00

Benoit · Accepted Answer · 2014-07-31 17:03:27Z

2

$counter = 0;
$rtnjsonobj = array();  
while ($k = @mysql_fetch_array($tmp)) { 
$rtnjsonobj['status'] = $k['status'];
$rtnjsonobj['text'] = $k['text'];
$data[] = $rtnjsonobj;  
if($k['status'] == 1)
   $counter = $counter + 1;
}

this will save a second query to the databse

answered Jul 31, 2014 at 17:03

Benoit

2083 silver badges13 bronze badges

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

1 Comment

Sergio Over a year ago

Simple and effective :)

Cheruvian · Accepted Answer · 2014-07-31 17:06:46Z

2

No need for a loop. Please explore the SQL Language further.

Select  Count(*)
From    TableName
Where   Status = 1

Edit:

If you have your heart set on counting it in PHP, simply create a counter set to 0 and increment when the value is found.

$Count = 0;
$rtnjsonobj = array();  
while ($k = @mysql_fetch_array($tmp)) { 
   $rtnjsonobj['status'] = $k['status'];
   $rtnjsonobj['text'] = $k['text'];
   if($k['status'] == 1)
       $Count++;
   $data[] = $rtnjsonobj;  
}

edited Jul 31, 2014 at 17:06

answered Jul 31, 2014 at 17:01

Cheruvian

5,9071 gold badge28 silver badges36 bronze badges

1 Comment

Sergio Over a year ago

@Cheruvian: I can not use "WHERE status = 1" because I need other values in the result where status != 1

Loïc · Accepted Answer · 2014-07-31 17:09:37Z

0

In your select you can imbricate another query as such :

Select *, (select count(*) from mytable where status=1) as myCounter from ...

Or increment a variable in your while loop :

$rtnjsonobj = array();
$myCounter = 0;
while ($k = @mysql_fetch_array($tmp)) { 
   $rtnjsonobj['status'] = $k['status'];
   $rtnjsonobj['text'] = $k['text'];
   $data[] = $rtnjsonobj;
   if($k['status'] == 1){$myCounter++;}
}
echo $myCounter;

answered Jul 31, 2014 at 17:09

Loïc

12k2 gold badges35 silver badges52 bronze badges

1 Comment

Cheruvian Over a year ago

This will replicate the count to every row though. Generally frowned upon in DB queries

Vincenzo Petrucci · Accepted Answer · 2014-07-31 17:18:53Z

0

Use array_reduce:

array_reduce — Iteratively reduce the array to a single value using a callback function

function mycount($carry, $item) {
    $carry += $item['status'] == 1 ? 1 : 0;
    return $carry;
}

$num = array_reduce($rtnjsonobj, "mycount");

By the way you should do the count from SQL.

edited Jul 31, 2014 at 17:18

answered Jul 31, 2014 at 17:10

Vincenzo Petrucci

8651 gold badge8 silver badges16 bronze badges

Collectives™ on Stack Overflow

how to count values in php array and while loop

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related