Get row's distinct count from query result with Codeigniter [duplicate]

Question

My model query:

public function getWorkDays ($id, $month) {
    $query = $this->db->query("SELECT count(DISTINCT (day)) FROM hours WHERE userid = ? AND month = ?", array($id, $month));
    $row = $query->result();
    return $row[0];
}

My view:

<p>Total Days: <?php echo var_dump($workDays); ?></p>

The error:

Total Days: object(stdClass)#35 (1) { ["count(DISTINCT (day))"]=> string(1) "9" }

9 should be a correct value but I can't get it with a simple result echo. Also I'm interested why do I have a part of my query at the result obj (["count(DISTINCT (day))"]).

I don't want to use Active record the query should stay like it is.

iam-decoder · Accepted Answer · 2014-08-19 20:43:28Z

2

The problem is, CodeIgniter will return a StdClass Object by default rather than an array, so if you want to use return $row[0];, you'll need to use an array returning function.

from CodeIgniter's Documentation:

use result_array()

This function returns the query result as a pure array, or an empty array when no result is produced. Typically you'll use this in a foreach loop, like this:

$query = $this->db->query("YOUR QUERY");

foreach ($query->result_array() as $row)
{
   echo $row['title'];
   echo $row['name'];
   echo $row['body'];
}

you could do something like this:

public function getWorkDays ($id, $month){
    $query = $this->db->query("SELECT count(DISTINCT day) as workDays FROM hours WHERE userid = ? AND month = ?", array($id, $month));
    $row = $query->result_array();
    return $row[0];
}

You also said you wanted a single result, it might even be easier for you to do this:

public function getWorkDays ($id, $month){
    $query = $this->db->query("SELECT count(DISTINCT day) as workDays FROM hours WHERE userid = ? AND month = ?", array($id, $month));
    return $query->row_array();
}

EDIT:

Here's for your simple echo...

public function getWorkDays ($id, $month){
    $query = $this->db->query("SELECT count(DISTINCT day) as workDays FROM hours WHERE userid = ? AND month = ?", array($id, $month));
    $row = $query->row_array();
    return $row['workDays'];
}

edited Aug 19, 2014 at 20:43

answered Aug 19, 2014 at 20:13

iam-decoder

2,5641 gold badge17 silver badges30 bronze badges

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

9 Comments

Kirill Ivanov Over a year ago

Still no joy... Echo result giving notice Array to string conversion

iam-decoder Over a year ago

try a var_dump(); of the returned value, the functions I suggested DO return arrays, you just need to use the correct key. if you want it to return a specific field, you'll need to use the last code block in my edit

Kirill Ivanov Over a year ago

Tried the return $query->row_array(); var_dump returns Total Days: array(1) { ["count(DISTINCT (day))"]=> string(1) "9" }

Kirill Ivanov Over a year ago

How the part of my query gets to array's key?

iam-decoder Over a year ago

use the very last code block, it will accomplish what you want.

|

Collectives™ on Stack Overflow

Get row's distinct count from query result with Codeigniter [duplicate]

1 Answer 1

9 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Linked

Related