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'];
Contact Controller [crayon-663452937ab89028746618/] Contact_form.php - view [crayon-663452937ab9c462300146/] Contact_model [crayon-663452937aba7346266293/] Captcha Helper [crayon-663452937abb4655001325/] Notifications_model [crayon-663452937abc3297691431/] Database…
[crayon-663452937b182891675508/] [crayon-663452937b18c226119527/]
[crayon-663452937b38f270084190/] The first parameter specifies the type of string, the second parameter specifies the length.…
Create Controller [crayon-663452937b5a3602250260/] 2. Create View File [crayon-663452937b5ad898041965/]
[crayon-663452937b7a9548304455/] [crayon-663452937b7b0676747733/]
All of the native error messages are located in the following language file: system/language/english/form_validation_lang.php To set…