Print array keys and values

Question

Given a table called "people" where names of people are associated to their city, I need to retrieve the number of people who come from the same city.

PEOPLE CITY John Baltimore David London Paula Baltimore Mark Baltimore Alex London

My code is as follows:

$array_cities = array(); $query = "SELECT * FROM people"; $result = mysql_query($query); if ($result) { while ($record = mysql_fetch_array($result)) $array_cities[] = $record['city']; } print_r(array_count_values($array_cities));

And what I get in my browser is:

Array ( [Baltimore] => 3 [London] => 2 )

The output is correct, but it is not graphically good. What I would want is something like:

Baltimore => 3 London => 2

Are there any other options to get it?

Loop it and correct graphically good

Narendrasingh Sisodia
– Narendrasingh Sisodia

2015-07-08 11:51:44 +00:00
Commented Jul 8, 2015 at 11:51 — Narendrasingh Sisodia
– Narendrasingh Sisodia, Commented Jul 8, 2015 at 11:51
So where are we with this question ?

Rizier123
– Rizier123

2015-07-08 12:16:20 +00:00
Commented Jul 8, 2015 at 12:16 — Rizier123
– Rizier123, Commented Jul 8, 2015 at 12:16
Rizier, your answer worked like a charm.

Alessandro
– Alessandro

2015-07-08 12:27:06 +00:00
Commented Jul 8, 2015 at 12:27 — Alessandro
– Alessandro, Commented Jul 8, 2015 at 12:27

Rizier123 · Accepted Answer · 2015-07-08 12:06:26Z

That's just the output from print_r(). If you want something else, just loop through the array an print it:

foreach(array_count_values($array_cities) as $k => $v) echo $k . " => " . $v . " ";

Sidenote:

Besides print_r() there are also var_dump() and var_export(), which are all "debugging functions". So use them for debugging and not for printing "nice formatted output".

PrestaShopDeveloper · Accepted Answer · 2015-07-08 14:22:19Z

You need to use the MySQL function COUNT(*) & the GROUP BY clause:

$array_cities = array(); $query = 'SELECT COUNT(*) AS `persons`, `city` FROM `people` GROUP BY `city`'; $result = mysql_query($query); if ($result) { while ($record = mysql_fetch_array($result)) { $array_cities[$record['city']] = $record['persons']; } } print_r($array_cities);

Collectives™ on Stack Overflow

Print array keys and values

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related