ci框架对数据库的操作小结

首先安利下ci官方文档

http://codeigniter.org.cn/user_guide/

常规的一些操作

读数据

$this->load->database();$query = $this->db->query('SELECT * FROM news');//以对象形式foreach ($query->result() as $row){    echo $row->id;    echo $row->title;    echo $row->slug;    echo $row->text;}//以数组形式foreach ($query->result_array() as $row){    echo $row['id'];    echo $row['title'];    echo $row['slug'];    echo $row['text'];}//直接打印 单结果标准查询（对象形式）$query = $this->db->query('select text from news');$row = $query->row();echo $row->text;//直接打印 单结果标准查询（数组形式）$row = $query->row_array();echo $row['text'];//使用查询构造器查询数据  先表名、对象掏出字段$query = $this->db->get('news');$row = $query->row();echo $row->text;

insert&update数据

//写数据$data = array(    'title' => "我是ttle",    'slug' => "我是slug",    'text' => "我是text");$this->db->insert('news', $data);

    public function report_log($id){        // 系统时间        $update_time = date("Y-m-d h:i:s");        $this->load->database();        $data = array("lastRunTime"=>$update_time);        $this->db->update('newactivity', $data);        }

dump数据为csv

    public function dump(){        $this->load->dbutil();        $this->load->database();        $query = $this->db->query("select * from newactivity;");        $data=$this->dbutil->csv_from_result($query);        //写文件        $this->load->helper('file');        if(!write_file('./test.csv',$data)){            echo "unable to write the file";        }else{            echo "file written";        }//        file_get_contents('./test.csv');        //下载文件        $this->load->helper('download');        force_download('test.csv', $data);        }