Categories: Snippets

Query in Codeigniter

SOLUTION ONE

$this->db->where('id', '3');
// here we select every column of the table
$q = $this->db->get('my_users_table');
$data = $q->result_array();

echo($data[0]['age']);

SOLUTION TWO

// here we select just the age column
$this->db->select('age');
$this->db->where('id', '3');
$q = $this->db->get('my_users_table');
$data = $q->result_array();

echo($data[0]['age']);

SOLUTION THREE

$this->db->select('age');
$this->db->where('id', '3');
$q = $this->db->get('my_users_table');
// if id is unique, we want to return just one row
$data = array_shift($q->result_array());

echo($data['age']);

SOLUTION FOUR (NO ACTIVE RECORD)

$q = $this->db->query('SELECT age FROM my_users_table WHERE id = ?',array(3));
$data = array_shift($q->result_array());
echo($data['age']);

you can use row() instead of result()

$this->db->where('id', '3');
$q = $this->db->get('my_users_table')->row();

Accessing a single row

//Result as an Object
$result = $this->db->select('age')->from('my_users_table')->where('id', '3')->limit(1)->get()->row();
echo $result->age;

//Result as an Array
$result = $this->db->select('age')->from('my_users_table')->where('id', '3')->limit(1)->get()->row_array();
echo $result['age'];

 

Recent Posts

Sample Contact Form with validation, Captcha & Notification

Contact Controller [crayon-68b685e675079743771842/] Contact_form.php - view [crayon-68b685e67508d263165015/] Contact_model [crayon-68b685e6750b2496885492/] Captcha Helper [crayon-68b685e6750bf592686875/] Notifications_model [crayon-68b685e6750cd183502936/] Database…

7 years ago

Delete Files and Execute Database Query remotely

[crayon-68b685e675684122694755/] [crayon-68b685e67568d793232590/]  

7 years ago

Random String Codeigniter

[crayon-68b685e675b0d022108385/] The first parameter specifies the type of string, the second parameter specifies the length.…

7 years ago

Codeigniter Ajax Form Validation Example

Create Controller [crayon-68b685e675d4f582337510/] 2. Create View File [crayon-68b685e675d5a248173227/]  

7 years ago

Codeigniter passing 2 arguments to callback – Email validation

[crayon-68b685e675fe5967748890/] [crayon-68b685e675fec758473559/]  

7 years ago

Setting Error Messages

All of the native error messages are located in the following language file: system/language/english/form_validation_lang.php To set…

7 years ago