How to use array_count_values() in the codeigniter

Question

I need to get the count of each countries by the database.

Here my coding is

    $query = $this->db->query("SELECT country FROM list");
    echo"<pre>"; print_r($query->result());

The select query returns object as result and array_count_values need array in the parameter

So how can I use array_count_values to dynamically pass values in CodeIgniter.

The array_count_values function will not work with multidimensional arrays. You will most likely need to find another solutions or make your own — mic
– mic, Commented Jan 13, 2014 at 9:21

Muhammad Raheel · Accepted Answer · 2014-01-13 09:27:32Z

2

SELECT
    country,
    count(country) as `Total`
FROM list
GROUP BY country

answered Jan 13, 2014 at 9:27

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:29:16Z

2

Try this:

SELECT country, Count(*) FROM list GROUP BY country

Also you can find a full and detailed answer here

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Jan 13, 2014 at 9:21

PeterRing

1,81713 silver badges21 bronze badges

1 Comment

user2451266 Over a year ago

This query will execute total number of distinct country in the table. But I need for India - 5, Mexico- 2 like wise i need

Adarsh M Pallickal · Accepted Answer · 2014-01-13 10:40:27Z

0

you can following code

function fun_name() 
    {
        $this->db->where('id !=',0);// like this you can set conditions
        return $this->db->count_all_results('table_name');
    }

answered Jan 13, 2014 at 10:40

Adarsh M Pallickal

8213 gold badges16 silver badges38 bronze badges

Comments

Azam Alvi · Accepted Answer · 2014-01-13 14:33:48Z

0

You can use num_row() function for this

  $this->db->select('country');
  $this->db->from('list');
  $query = $this->db->get();

  echo $query->num_rows(); // this will print the count of all countries
  echo"<pre>"; print_r($query->result()); // this can be used for fetching countries name(else)

answered Jan 13, 2014 at 14:33

Azam Alvi

7,0958 gold badges67 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to use array_count_values() in the codeigniter

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related