php this db get,php – Codeigniter $this-> db-> get(),如何返回特定行的值？

解决方案一

$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']);

解决方案二

// 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']);

解决方案三

$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']);

解决方案四(无活动记录)

$q = $this->db->query('SELECT age FROM my_users_table WHERE id = ?',array(3));

$data = array_shift($q->result_array());

echo($data['age']);