CodeIgniter 4 SQL Highlighter

Description

A SQL Highlighter Using Highlightjs for CodeIgniter 4 database debug toolbar.

Warning

Warning! This will modify CodeIgniter 4 system files. Use at own risk.

Table of contents

• Requirement
• Installation
• Setup
• ScreenShot

Requirement

• Codeigniter 4
• highlightjs

Installation

Install library via composer:

composer require nfaiz/sqlhighlighter

Setup

Modify CodeIgniter 4 debug system files

Run following command using command prompt/terminal

php spark hl:setup

Modify SQL Highlighter Assets.

Open app/Config/Toolbar.php and find $sqlHighlighterAssets

    public array $sqlHighlighterAssets = [
        'js' => 'https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.10.0/highlight.min.js',
        'css_light' => 'https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.10.0/styles/atom-one-light.min.css',
        'css_dark' => 'https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.10.0/styles/atom-one-dark.min.css',
    ];

Screenshot

Default Database Toolbar

• Light
  

• Dark
  

Using Sql Highlighter

• Light

• Dark