CodeIgniter Select Query

user_772502 0
Viewed 196761

I have a simple CodeIgniter Active record query to select an ID:

$q = $this -> db
           -> select('id')
           -> where('email', $email)
           -> limit(1)
           -> get('users');

How can I assign the above ID to a variable (eg. $id) For example, 

echo "ID is" . $id;

Thanks.

codeigniter select mysql variables php
10 Answers

use Result Rows.
row() method returns a single result row.

$id = $this 
    -> db
    -> select('id')
    -> where('email', $email)
    -> limit(1)
    -> get('users')
    -> row();

then, you can simply use as you want. :)

echo "ID is" . $id;
user_54298730

Here is the example of the code:

public function getItemName()
{
    $this->db->select('Id,Name');
    $this->db->from('item');
    $this->db->where(array('Active' => 1));
    return $this->db->get()->result();
}
user_122615780
Related