CodeIgniter hook not catching insert/update queries

Question

I am trying to use post_system or post_controller hook to catch and log all insert and update queries in a database table. But, what happens is that the $queries = $CI->db->queries; statement doesn't seem to catch any insert or update statement at all. It only catches SELECT statements even when new data is inserted or old data is updated in respective views/controllers.

Here is my relevant code:

hooks.php

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

// also tried with post_controller hook
$hook['post_system'] = array(
    'class' => 'Db_query_log', 
    'function' => 'log_db_queries', 
    'filename' => 'db_log.php', 
    'filepath' => 'hooks'        
);

hooks/db_log.php

    <?php

class Db_query_log {

    function __construct() {
        //nothing special    
    }

    function log_db_queries() {
        $CI = & get_instance();
        $queries = $CI->db->queries;

        foreach ($queries as $key => $query) {
            echo $query . "<br>"; 
        // all statements displayed are SELECT statements even for UPDATE and INSERT operations performed by controllers where data is actually changed 
        }
    }

}

What could be the culprit here? Am I missing something or this hook simply ignores INSERT/UPDATE operations?

Any help would be appreciated, thanks!

score 0 · Answer 1 · answered Feb 03 '15 at 14:42

0

Use post_controller instead of post_system :

$hook['post_controller'] = array(
    'class' => 'Db_query_log', 
    'function' => 'log_db_queries', 
    'filename' => 'db_log.php', 
    'filepath' => 'hooks'        
);

answered Feb 03 '15 at 14:42

JC Sama

2,214
1
13
13

it doesn't make any difference. It still doesn't catch any insert/update query at all. – Nadeem Khan Feb 03 '15 at 14:45
It did for me, I just tried your code and it's working just fine. – JC Sama Feb 03 '15 at 14:47
what could be preventing my codeigniter instance from getting the INSERT/UPDATE queries, any suggestions/ideas ? – Nadeem Khan Feb 03 '15 at 14:49
1

I think it's the redirection, after the save method – JC Sama Feb 03 '15 at 14:53
If you wanna log all your queries, I think the better way to do that is to overwrite the query method in your db driver that you are using. – JC Sama Feb 03 '15 at 15:02
An easier approach would be to create a library and call the library function manually from the relevant controllers. – Nadeem Khan Feb 04 '15 at 14:01

score 0 · Answer 2 · answered Oct 07 '16 at 06:16

To achieve this open any helper file and put this code at the bottom

function log_que($sql) {
        $filepath = APPPATH . 'logs/Query-log-' . date('Y-m-d') . '.php';   
            $handle = fopen($filepath, "a+");
            fwrite($handle, $sql." \n Execution Time: ".date("Y-m-d H:i:s")."\n\n");  
            fclose($handle);   
}

after this go to system/database/DB_driver.php and find function named "query" and put this below code on top inside the function.

log_que($sql);'

then all the queries will save in a file inside the application/logs folder.

you can put if condition if you want to save only specific queries. LIKE

if(preg_match('/INSERT/',$sql)) {
 fwrite($handle, $sql." \n Execution Time: ".date("Y-m-d H:i:s")."\n\n");  
}

CodeIgniter hook not catching insert/update queries

2 Answers2