ci的常用操作
来源:互联网 发布:python相对路径import 编辑:程序博客网 时间:2024/06/06 10:46
- ----------------------------------------------------
- 链接数据库
- -------
- $this->load->database();
-
- $DB1 = $this->load->database('group_one', TRUE);
- $DB2 = $this->load->database('group_two', TRUE);
- -----------------------------------------------------
- 查询
- -------
-
- $sql = "SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?";
- $this->db->query($sql, array(3, 'live', 'Rick'));
-
- $query = $this->db->query($sql);
- $query = $this->db->get('tablename');
- $query = $this->db->get('tablename', 10, 20);
- $query->result()
- $query->result_array()
-
-
-
-
-
-
-
-
- $query->num_rows()
- $query->num_fields()
-
- $row = $query->row();
- $row = $query->row_array();
-
-
-
-
-
- -----------------------------------------------------
- 插入
- -------
- $data = array(
- 'title' => $title,
- 'name' => $name
- );
- $this->db->insert('tablename', $data);
- $this->db->insert_string('tablename', $data);
- $this->db->insert_id()
- $this->db->affected_rows()
- -----------------------------------------------------
- 更新
- -------
- $data = array(
- 'name' => $name,
- 'email' => $email
- );
- $where = "id = 1";
- $this->db->update('tablename', $data);
- $this->db->update_string('tablename', $data, $where);
- -----------------------------------------------------
- 删除
- -------
- $array = array(
- 'name' => $name,
- 'title' => $title
- );
- $this->db->delete('tablename', $array);
-
-
- $this->db->truncate('tablename');
-
-
- -----------------------------------------------------
- (where)
- -------
- $array = array(
- 'name' => $name,
- 'title' => $title
- );
- $this->db->where($array);
-
- -----------------------------------------------------
- $this->db->count_all('tablename');
- -----------------------------------------------------
- $query->free_result()
- 文章来源:http://blog.csdn.net/linvo/article/details/3906900