/** * perform 2 queries to get list of rows * @return int $this->list_count count of rows obtained from db * @return array of arrays $this->list_rows list of rows * @return string $this->list_pager pager from FormUtils::get_pager */ public function get_list_rows() { $this->list_count = db_value("select count(*) from {$this->table_name} where " . $this->list_where); if ($this->list_count) { $offset = $this->list_filter['pagenum'] * $this->list_filter['pagesize']; $limit = $this->list_filter['pagesize']; $sql = "SELECT * FROM {$this->table_name} WHERE {$this->list_where} ORDER BY {$this->list_orderby} LIMIT {$offset}, {$limit}"; $this->list_rows = db_array($sql); $this->list_pager = FormUtils::get_pager($this->list_count, $this->list_filter['pagenum'], $this->list_filter['pagesize']); } else { $this->list_rows = array(); $this->list_pager = array(); } }