PHP CI_DB_active_record::limit Beispiele

limit() public method

Sets the LIMIT value

public limit ( $value, $offset = '' ) : object
return	object

Beispiel #1

Datei: CU_Model.php Projekt: syalr/vitime-meeting

 /**
  * 删除数据
  * @param array|string $where 条件
  * @param int $limit 删除数量限制，默认不限制
  * @return int $delete_count 删除的记录数
  */
 public function delete($where, $limit = NULL)
 {
     if (!is_null($limit) && is_numeric($limit)) {
         $this->where($where);
         if (is_numeric($limit)) {
             $this->db->limit($limit);
         }
         $this->db->delete($this->_name);
         return $this->db->affected_rows();
     }
     $this->db->delete($this->_name, $where);
     return $this->db->affected_rows();
 }

Beispiel #2

Datei: abstract_table_relation.php Projekt: andrejjursa/fmfi-tis

 /**
  * Inserts custom LIMIT clausule to given active record.
  * 
  * @param CI_DB_active_record $db database active record object.
  * @return void
  */
 private function insertLimit(CI_DB_active_record $db)
 {
     if (is_array($this->custom_limit) && count($this->custom_limit) == 2) {
         $db->limit($this->custom_limit[0], $this->custom_limit[1]);
     }
 }