1、下载firephp
http://www.firephp.org/
修改文件名:FirePHP.class.php => firephp.php
修改类名:FirePHP => firephp
移动到application/libraries/ 目录下
2、在system/database/DB_driver.php 中,增加 返回全部sql 的方法
/**
* Returns the all queries
* @access public
* @return
*/
function all_query()
{
return $this->queries;
}
3、application/config/hooks.php
$hook['post_controller'] = array(
'class' => 'Log',
'function' => 'index',
'filename' => 'log.php',
'filepath' => 'hooks',
);
3、application/hooks/log.php
/**
* 输出日志
*/
class Log
{
//超级对象
private $CI;
public function __construct()
{
$this->CI =&get_instance();
}
/**
* 日志记录
*/
public function index()
{
//输出到firefox
$this->firephp();
}
/**
* 利用firephp输出 日志到firefox
*/
private function firephp()
{
$arr = array();
$arr[] = array('name', 'value');
if ($count = $this->CI->db->total_queries()) {
foreach ($this->CI->db->all_query() as $k => $v) {
$arr[] = array($k, $v);
}
}
$this->CI->load->library('firephp');
$this->CI->firephp->table('SQL执行条数:(' . $count . ')', $arr);
}
}
输出类似: