Database Debug Toolbar SQL Highlighter

Installation and setup

1. Install the
   Library using composer
   
   Code:

   composer require nfaiz/dbtoolbar
   
   
   
2. Open app/Config/Toolbar.php
   
   Replace default database collector class Database::class to \Nfaiz\DbToolbar\Collectors\Database::class
   
   
   public $collectors = [
       Timers::class,
       Database::class,
       \Nfaiz\DbToolbar\Collectors\Database::class,
       Logs::class,
       Views::class,
       // \CodeIgniter\Debug\Toolbar\Collectors\Cache::class,
       Files::class,
       Routes::class,
       Events::class,
   ];
   
   
   
3. Open app/Config/Events.php
   
   Replace default query collector to Events::on('DBQuery', 'Nfaiz\DbToolbar\Collectors\Database::collect');
   
   
   if (CI_DEBUG && ! is_cli()) {
       Events::on('DBQuery', 'CodeIgniter\Debug\Toolbar\Collectors\Database::collect');
       Events::on('DBQuery', 'Nfaiz\DbToolbar\Collectors\Database::collect');
       Services::toolbar()->respond();
   }
   
   Refresh page to see the result.