/** * 批量读取数据 * @param array|string $where 条件 * @param string $order 排序字段 * @param int $limit 查询数量 * @param int $offset 查询起始偏移量 * @return array */ public function fetchAll($cols = '*', $where, $order, $limit = NULL, $offset = NULL) { $this->db->select($cols); $this->where($where); if (!empty($order)) { $this->db->order_by($order); } return $this->db->get($this->_name, $limit, $offset)->result_array(); }
/** * Load a record, by a specific ID, and by any attributes specified * * @param mixed $ID * @return bool */ public function load($ID = null) { if (is_object($ID)) { //Used by load many to initialise new objects //If it this object, or a fancy join? if (is_a($ID, 'stdClass')) { //This is just to strip from $this->_strip_row($ID); return true; } else { //Passed an object to load with $this->related($ID); } } //Did the user reauest via a specific ID? if (is_numeric($ID) or $ID === 0) { $this->db->where($this->_id(), $ID); } //Load in custom SQL //$this->_generate_related_sql_old(); $this->_generate_related_sql(); //Are there any variabloes set in the object to be used in the query? foreach ($this->_data as $Field => $Value) { $this->db->where($this->_table() . '.' . $Field, $Value); } $this->_data = array(); $this->db->select($this->_table() . '.*'); $this->db->from($this->_table()); $Query = $this->db->get(); if ($Query->num_rows() == 1) { $this->_strip_row($Query->row()); return true; } else { return false; } }