logging all queries after execution in codeigniter

Question

i want to log all queries after execution using hooks. -i enabled hooks in config.php -this is my hook-->

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

-and this is hook defination-->

class Db_log 
{

    function __construct() 
    {
    }


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

        $filepath = APPPATH . 'logs/Query-log-' . date('Y-m-d') . '.php'; 
        $handle = fopen($filepath, "a+");                        

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

            fwrite($handle, $sql . "\n\n");    
        }

        fclose($handle);  
    }

}

--its creating query_log file --but no records of queries being stored

Atural · Accepted Answer · 2016-09-20 07:32:05Z

15

Your Code looks fine - the only reason why this doesn't work is in your DB Configuration - take a look @your DB Connection in the database.php under application/config/

There is an option "save_queries" which should be set to true

$db['default'] = array(
    ...
    'save_queries' => TRUE
);

answered Sep 20, 2016 at 7:32

Atural

5,4505 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

mohseen pathan Over a year ago

above code is now working fine...but its logging SELECT queries only,what if i want only INSERT,UPDATE and DELETE be logged instead of SELECT queries?

Atural Over a year ago

even the other types of Queries should get logged - in the queries are all type of queries

mohseen pathan Over a year ago

is there any option to "$CI->db->queries"

Atural Over a year ago

what do you mean with option ? do you want to separate inserts, updates, delets and selects from each other ?

mohseen pathan Over a year ago

internal redirection in application was causing it to overtake hook execution, that's why it wasn't logging modification statements...i found the solution thereafter.

|

chuckedw · Accepted Answer · 2017-11-22 13:57:37Z

0

For me it only worked when I define de $hook array in config/hooks.php .

answered Nov 22, 2017 at 13:57

chuckedw

7612 gold badges9 silver badges15 bronze badges

Collectives™ on Stack Overflow

logging all queries after execution in codeigniter

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related