Display count of values in PHP array

Question

I can not seem to come over this easy problem.

I have the following code, where I select the column "status" from a table. There's three different values of "status", 0, 1 and 3.

I would like to count how many 0's there are, 1's and 2's, so that I can display them via <?php echo $accepted; ?> etc.

<?php 

    $sql = "SELECT status FROM applications";
    $result = mysqli_query($db, $sql);
    $row = mysqli_fetch_array($result, MYSQLI_NUM);
    $array = array_count_values($row);
    $pending = $array[0];
    $accepted = $array[1];
    $denied = $array[2];


?>

MYSQL_NUM changed to MYSQLI_NUM accordingly to comment, thank you.

I got this: Array ( [2] => 1 ) The sql table contains 4 rows, 2 with status=2, 2 with status=1. — introzen
– introzen, Commented Feb 3, 2017 at 20:11
now you went and used code from an answer below but didn't include "The code I used given in an answer did not work....". What you should have done was, left the question intact and place a comment under the answer. Now that person could get downvoted because of that. Edit: as you seem to have done now. IMHO, you should have left your code the way it was. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 3, 2017 at 20:17

Mm-Art-In · Accepted Answer · 2017-02-03 20:25:31Z

5

A simple way is get these count using SQL

  $sql = "SELECT `status`, COUNT(*) as cnt FROM applications GROUP BY `status`";

you have an array of so you should

 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
 {
   echo "status = " . $array['status'] . ' = ' . $array['cnt'] .'<br />';
 }

edited Feb 3, 2017 at 20:25

Mm-Art-In

23.1k13 gold badges81 silver badges144 bronze badges

answered Feb 3, 2017 at 20:11

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

8 Comments

user5491906 Over a year ago

You should accept this answer it's the correct way to go but honestly you need to better you code in small applications this is fine but if you r looking to scale up you will regret this sorta code later

ScaisEdge Over a year ago

@JoséphFlames your comment if for me or for the OP ... and if you can please explain better .. ..

introzen Over a year ago

I've updated the questions with my new code, The array result is now: Array ( [0] => 1 [1] => 2 ) , how comes?

user5491906 Over a year ago

It was for Adam and I mean for one he is using sql which is depreciated and secondly he needs to use prepared statementz

Funk Forty Niner Over a year ago

OP is using mysqli_ and you have mysql_fetch_array and MYSQL_ASSOC both missing I's Edit: where Martin missed one. Edit: there we go ;-)

|

Collectives™ on Stack Overflow

Display count of values in PHP array

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related