User Audit Trail

It is an attempt to add user audit trail with CodeIgniter framework. I think it is a very convenient way to track user activities in the database.

Installation

• Put all files into your projects directory respectively.
• Check config.php for $config['subclassprefix'] this value. If it is not 'MY' then rename MY_DB_mysqli_driver.php and MY_Loader.php to your value.
• To enable listening change set $config['audit_enable'] = TRUE in config/the trail.php
• You can start/stop to record insert, update, delete. please read carefully the trail.php

Now you are ready to browse the application.

Database Table

• Run the sql in your database.

  CREATE TABLE `user_audit_trails` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `event` enum('insert','update','delete') NOT NULL,
    `table_name` varchar(128) NOT NULL,
    `old_values` text,
    `new_values` text NOT NULL,
    `url` varchar(255) NOT NULL,
    `name` varchar(128) NOT NULL,
    `ip_address` varchar(45) NOT NULL,
    `user_agent` varchar(255) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  ALTER TABLE `user_audit_trails`
    ADD PRIMARY KEY (`id`);
  
  ALTER TABLE `user_audit_trails`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  COMMIT;

Further Work

Now it is your turn to make model and view for presenting the audit data. Happy coding..