php - Codeigniter how to get DB errors using hooks and save in logs table?

I need to save all PHP and Database errors in log table in codeigniter. For this i am trying to do this using hooks in codeigniter. This is my code.

hooks.php

$hook['post_controller'] = array(    
     'class' => 'Db_log',            
     'function' => 'logQueries',    
     'filename' => 'db_log.php',    
     'filepath' => 'hooks'       
 );
Copy code

Codeigniter how to get DB errors using hooks and save in logs table

I have created file db_log.php in hooks directory. and this is my code.

<?php
class Db_log {
function __construct() {

    }

    function logQueries() {
        $CI = & get_instance();

        $times = $CI->db->query_times;    
         $error = $CI->db->error();
         print_r($error);

        // foreach ($CI->db->queries as $key => $query) 
        // { 
             // $sql = $query . " \n Execution Time:" . $times[$key]; 

        // }

    }
}
Copy code

It's working to show all queries but not working when any error comes related to Database. I had tried $CI->db->error() also to get the error but it's not working. I need to show custom message if any error come related to Database and need to save a entry in custom log table.

Try with shutdown_function

public function setHandler() {
        register_shutdown_function('handleShutdown');
    }

}

function handleShutdown() {

    print_r(error_get_last());



    if (($error = error_get_last())) {
        die("nnnnnnnnnnnnn");
        ob_start();
            echo "<pre>";
        var_dump($error);
            echo "</pre>";
        $message = ob_get_clean();
        //sendEmail($message);
        ob_start();
        echo '{"status":"error","message":"Internal application error!"}';
        ob_flush();
        exit();
    }
}

hooks.php

$hook['pre_system'][] = array(
'class' => 'PHPFatalError',
'function' => 'setHandler',
'filename' => 'PHPFatalError.php',
'filepath' => 'hooks'
);
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.