php数据库语法

echo gettype($query)

echo sizeof($query)

is_string( $row )

$this->db->where('name', $name);  等同于  select * from table where name = $name

二、循环输出处理结果 

foreach( $query->result() as $row ){
echo $row->name;
}

三、链式方法

$this->db->select('title')->from('mytable')->where('id', $id)->limit(10, 20);

四、输出

$this->load->database();
$this->db->from('users');
$this->db->where('name','lz');
$query = $this->db->get();
$row = $query->row();
echo $row->name;

或者$row = $query->row(4);