Zend_Db_Profiler Log FireBug

http://framework.zend.com/manual/en/zend.db.profiler.html#zend.db.profiler.profilers.firebug

http://framework.zend.com/manual/en/zend.log.writers.html

 

手册两则。。。

 

 

 

<?phpclass Bootstrap extends Zend_Application_Bootstrap_Bootstrap {protected function _initAutoload() {$autoloader = Zend_Loader_Autoloader::getInstance ();$autoloader->registerNamespace ( 'Sqhl_' );return $autoloader;}protected function _initSiteInfo() {$options = $this->getOption ( 'site_url' );defined ( 'SITE_URL' ) || define ( 'SITE_URL', $options );$options = SITE_URL . $this->getOption ( 'images_path' );defined ( 'IMG_PATH' ) || define ( 'IMG_PATH', $options );}// place in your bootstrap file.public function _initLogger() {//CREATE TABLE `log_table_name` //( `id` INT(10) NULL AUTO_INCREMENT, //`lvl` VARCHAR(100) NULL, //`message` VARCHAR(1000) NULL, PRIMARY KEY (`id`) ) //COLLATE='latin1_swedish_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT;$config = new Zend_Config_Ini ( APPLICATION_PATH . '/configs/application.ini', 'log' );$db = Zend_Db::factory ($config->log);$columnMapping = array ('lvl' => 'priority', 'message' => 'message' );$writer = new Zend_Log_Writer_Db ( $db, 'log_table_name', $columnMapping );$_logger = new Zend_Log ( $writer );return $_logger;}public function _initFireBug() {// Place this in your bootstrap file before dispatching your front controller$writer = new Zend_Log_Writer_Firebug ();$_fireBug = new Zend_Log ( $writer );return $_fireBug;// Use this in your model, view and controller files }public function _initDbProfiler() {/*$db = Zend_Db::factory ( 'Pdo_Mysql', array ('host' => 'localhost', 'dbname' => 'test', 'username' => 'root', 'password' => '' ) );$_dbProfiler = new Zend_Db_Profiler_Firebug ( 'All DB Queries' );$_dbProfiler->setEnabled ( true );$db->setProfiler ( $_dbProfiler );$result1 = $db->fetchAll ( 'SELECT * FROM log_table_name' );$result2 = $db->fetchAll ( 'SELECT * FROM log_table_name where id = ?', 3 );*/$config = new Zend_Config_Ini ( APPLICATION_PATH . '/configs/application.ini', 'firebugdevelopment' );$db = Zend_Db::factory ( $config->firebugdatabase );$_dbProfiler = new Zend_Db_Profiler_Firebug ( 'All DB Queries' );$_dbProfiler->setEnabled ( true );$db->setProfiler ( $_dbProfiler );//$result1 = $db->fetchAll ( 'SELECT * FROM log_table_name' );//$result2 = $db->fetchAll ( 'SELECT * FROM log_table_name where id = ?', 3 );return $_dbProfiler;}}

 

 

 

 

<?phpclass IndexController extends Zend_Controller_Action {public function init() {/* Initialize action controller here */}public function indexAction() {$this->codeSession = new Zend_Session_Namespace ( 'code' ); //在默认构造函数里实例化$captcha = new Sqhl_Captcha_Image ( array ('font' => 'F:/wamp/www/CAPTCHA/images/simsun.ttc', 'fontsize' => 24, 'imgdir' => 'F:/wamp/www/CAPTCHA/images', 'session' => $this->codeSession, 'width' => 200, 'height' => 50, 'wordlen' => 6 ) );$captcha->setGcFreq ( 3 ); //设置删除生成的旧的验证码图片的随机几率$captcha->generate (); //生成图片$this->view->ImgDir = $captcha->getImgDir ();$this->view->captchaId = $captcha->getId (); //获取文件名，md5编码$this->codeSession->code = $captcha->getWord (); //获取当前生成的验证字符串 //echo $this->codeSession->code;// action body$logger = $this->getInvokeArg ( 'bootstrap' )->getResource ( 'logger' );$logger->info ( 'Informational message'.$this->codeSession->code );$fireBug = $this->getInvokeArg ( 'bootstrap' )->getResource ( 'fireBug' );$fireBug->log ( 'This is a firebug message!'.$this->codeSession->code, Zend_Log::INFO ); }}

 

 

 

 

 

[production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
includePaths.library = APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 1
site_url="http://localhost/CAPTCHA/"
images_path="images/"
upload_path="http://localhost/CAPTCHA/"
skins_path="http://localhost/CAPTCHA/"
temp_path="http://localhost/CAPTCHA/"
[staging : production]

[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1

[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

[log]
log.adapter                    = pdo_mysql
log.params.host                = localhost
log.params.username            = root
log.params.password            =
log.params.dbname              = test
log.params.profiler.enabled    = true
log.params.profiler.class      = Zend_Db_Profiler_Firebug
[firebugdevelopment]
firebugdatabase.adapter                    = pdo_mysql
firebugdatabase.params.host                = localhost
firebugdatabase.params.username            = root
firebugdatabase.params.password            =
firebugdatabase.params.dbname              = test
firebugdatabase.params.profiler.enabled    = true
firebugdatabase.params.profiler.class      = Zend_Db_Profiler_Firebug