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

 

手册两则。。。

 

 

 

<?php class 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; } }

 

 

 

 

<?php class 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