SQL语句是这样的:
$this->db->select('*')->from('mytable');
$count=$this->db->count_all_results() ;
$config = array(
'base_url' => '/financing/dayconsumption',
'total_items' => $count,
'current_page' => $page,
'items_per_page' => $this->pagesize,
);
$this->pagination2->init($config);
$this->db->limit($this->pagesize, $this->pagination2->sql_offset);
$query = $this->db->get();
。。。。。。
运行后报错:
A Database Error Occurred
Error Number: 1096
No tables used
SELECT * LIMIT 20
Line Number: 330
调试后发现问题出在:$count=$this->db->count_all_results() ;这,查看一下count_all_results()的源码:
/**
* "Count All Results" query
*
* Generates a platform-specific query string that counts all records
* returned by an Active Record query.
*
* @paramstring
* @returnstring
*/
public function count_all_results($table = '')
{
if ($table != '')
{
$this->_track_aliases($table);
$this->from($table);
}
$sql = $this->_compile_select($this->_count_string . $this->_protect_identifiers('numrows'));
$query = $this->query($sql);
$this->_reset_select(); //注意这里
if ($query->num_rows() == 0)
{
return 0;
}
$row = $query->row();
return (int) $row->numrows;
}
方法中调用了_reset_select()方法,继续追踪_reset_select()方法:
/**
* Resets the active record values. Called by the get() function
*
* @returnvoid
*/
protected function _reset_select()
{
$ar_reset_items = array(
'ar_select'=> array(),
'ar_from'=> array(),
'ar_join'=> array(),
'ar_where'=> array(),
'ar_like'=> array(),
'ar_groupby'=> array(),
'ar_having'=> array(),
'ar_orderby'=> array(),
'ar_wherein'=> array(),
'ar_aliased_tables'=> array(),
'ar_no_escape'=> array(),
'ar_distinct'=> FALSE,
'ar_limit'=> FALSE,
'ar_offset'=> FALSE,
'ar_order'=> FALSE,
);
$this->_reset_run($ar_reset_items);
}
其实到这里,看注释就能猜到了,active record被重置了。为了确认一下,继续追踪_reset_run(),就在_reset_select()上面:
/**
* Resets the active record values. Called by the get() function
*
* @paramarrayAn array of fields to reset
* @returnvoid
*/
protected function _reset_run($ar_reset_items)
{
foreach ($ar_reset_items as $item => $default_value)
{
if ( ! in_array($item, $this->ar_store_array))
{
$this->$item = $default_value;
}
}
}
果然,active record被重置了!!知道原因了,调用count_all_results()后,会将active record重置,后面的$query就获取不到数据了,解决办法:
$this->db->start_cache();
$this->db->select('*')->from('mytable');
$this->db->stop_cache();
......
$query = $this->db->get();
$items = $query->result();
$this->db->flush_cache();
以上就介绍了codeigniter中count_all_results()问题,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。
本文原创发布php中文网,转载请注明出处,感谢您的尊重!