Database Debug Toolbar SQL Highlighter

Hi,

I want to share my project for this weekend. . Moved to here
Basically it modify sql syntax highlighter for database debug toolbar using Highlight.php library.

Current



Dark



After using the library



Dark



Installation and setup

1. Install the library using composer
   
   Code:

   composer require nfaiz/dbtoolbar
   
   
2. Run this command to setup the library
   
   Code:

   php spark dbtoolbar:config
   
   

Configuration file: app/Config/DbToolbar.php

For more info please visit here. Moved to here

Thank you.

Excellent! Thanks for sharing. Screenshots look great, I’ll peek into the code when I’m on desktop

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.