(CodeIgniter 2) Get mysql function result using active record class

Question

I'm using CodeIgniter 2 (latest build)...let's say I have this query:

$CI->db->select("FileName, GUID, Count(GUID)");
$query = $CI->db->get('Files');

I know I can get GUID & FileName columns using this syntax:

foreach ($query->result() as $row) {
    $file_name = $row->FileName;
}

But how can I get the Count(GUID)?

PS. This is a simple example to explain my question. All I need to know is how to get the composed / mysql function result using codeigniter active record

user1745750 · Accepted Answer · 2012-10-16 00:27:55Z

1

I'm guessing it's this

$CI->db->select("FileName, GUID, Count(GUID) as guidCount");

foreach ($query->result() as $row) {
    $file_name = $row->guidCount;
}

answered Oct 16, 2012 at 0:27

user1745750

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

Comments

Stack Programmer · Accepted Answer · 2019-03-11 07:12:12Z

1

    $this->db->select('FileName, GUID, Count(GUID) as guidCount');
    $query = $this->db->get('Files');
    // this will call function once and speed up performance not every time in loop
    $rows = $query->result(); 
    foreach ($rows as $row)
    {
       echo $row->FileName;
       echo $row->GUID;
       echo $row->guidCount;
    }

See more @ https://www.codeigniter.com/userguide2/database/active_record.html

edited Mar 11, 2019 at 7:12

Stack Programmer

6796 silver badges18 bronze badges

answered Oct 16, 2012 at 0:42

MagePal Extensions

17.7k2 gold badges50 silver badges62 bronze badges

Collectives™ on Stack Overflow

(CodeIgniter 2) Get mysql function result using active record class

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related