dongyou9818
dongyou9818
2013-05-13 12:12
浏览 58
已采纳

如何在zend框架中记录数据库错误

I am using zend framework 1.12 for my project. I want to catch all types of fatal errors and send them to an email address for quick fix. I have written the below mentioned code in Bootstrap.php file for this purpose.

protected function _initFatalErrorCatcher()
{
    register_shutdown_function(array($this, 'errorlogHandler'));
}

public function errorlogHandler()
{
    $e = error_get_last();

if (!is_null($e)) { //fatal error

    $msg  = 'Fatal error: ' . $e['message'];
    $msg .= ' in' . $e['file'];
    $msg .= ' on line: ' . $e['line'];

    $mail = new Zend_Mail('utf-8');
    $mail->setBodyHtml($msg);
    $mail->setFrom('zzz@z.com');
    $mail->addTo('yyy@y.com');
    $mail->setSubject('check this error');

    $mail->send();
    }
}

Using the above code, i am able to send fatal errors other than database connection related errors and query related errors to email. I followed the instructions from Catch Zend PDO Exception as well, but i believe i am missing something as its not working.

Any help on this will be appreciated.

EDIT:

I am also using Zend_Log to write the error logs in a log-file. But, using this i could not find a way to write the fatal errors. Code for this is given below.

$writer = new Zend_Log_Writer_Stream(APPLICATION_PATH  . "/../data/log-file.log");
$errors = $this->_getParam('error_handler');
$exception = $errors->exception;

$log = new Zend_Log($writer);
$log->debug($exception->getMessage() . "
" . $exception->getTraceAsString());

Scenario for database connection related issue:

If there is any error in host name, database name or in user name, it shows a Fatal error in browser like below. But its not detected by register_shutdown_function() or Zend_Log().

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000] [1044] Access denied for user 'AAAA'@'%' to database 'BBBB'' in /var/www/project_name/library/Zend/Db/Adapter/Pdo/Abstract.php on line 144 PDOException: SQLSTATE[42000] [1044] Access denied for user 'AAAA'@'%' to database 'BBBB' in /var/www/project_name/library/Zend/Db/Adapter/Pdo/Abstract.php on line 129
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • dongxianchu3541
    dongxianchu3541 2013-05-14 12:29
    已采纳

    I have solved it by writing the below mentioned code in Bootstrap.php file.

    protected function _initDbConfig()
    {
      $config = new Zend_Config($this->getOptions());
      $params = $config->database->toArray();
      try {
         $db = Zend_Db::factory('Pdo_Mysql', $params);
         $db->getConnection();
    
      } catch (Zend_Db_Adapter_Exception $e) {
        // perhaps the RDBMS is not running
        // code to send email goes here
      } catch (Zend_Exception $e) {
        // perhaps factory() failed to load the specified Adapter class
        // code to send email goes here         
      }
    }
    

    In application.ini, i have the following code.

    database.host     = "localhost"
    database.username = "AAAA"
    database.password = "*****"
    database.dbname   = "BBBBB"
    
    点赞 评论
  • dongle19863
    dongle19863 2013-05-13 12:19

    //$array contains the values for insert

    try {
        $this->db->insert('Users', $array );
    } catch (Exception $e){
        echo $e->getMessage();
    }
    
    点赞 评论
  • duanliao6789
    duanliao6789 2013-05-13 13:56

    The post here shows an example. Basically use set_error_handler to tickle php into throwing exceptions when an error is encountered. This example from link:

    <?php
    function exception_error_handler($errno, $errstr, $errfile, $errline ) {
        throw new ErrorException($errstr, $errno, 0, $errfile, $errline);
    }
    set_error_handler("exception_error_handler");
    
    /* Trigger exception */
    strpos();
    ?>  
    

    Hope this helps

    点赞 评论

相关推荐