Database Debug Toolbar SQL Highlighter

Database Debug Toolbar SQL Highlighter - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Addins (https://forum.codeigniter.com/forumdisplay.php?fid=34)
+--- Thread: Database Debug Toolbar SQL Highlighter (/showthread.php?tid=79576)

Database Debug Toolbar SQL Highlighter - nfaiz - 07-04-2021

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

[Image: Wu7HKOI.png]

Dark

After using the library

[Image: eQ4sUwJ.png]

Dark

Installation and setup

Install the library using composer

Code:
composer require nfaiz/dbtoolbar
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.

RE: Custom database debug toolbar - MGatner - 07-04-2021

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

RE: Custom database debug toolbar - nfaiz - 07-09-2021

Installation and setup

Install the
Library using composer

Code:
composer require nfaiz/dbtoolbar
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,
];
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.