PHPackages                             dhuny/mysqlj - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. dhuny/mysqlj

ActiveLibrary[Database & ORM](/categories/database)

dhuny/mysqlj
============

Make dynamic pages Progressive ready

117PHP

Since Sep 10Pushed 7y agoCompare

[ Source](https://github.com/dhuny/mysqlj)[ Packagist](https://packagist.org/packages/dhuny/mysqlj)[ RSS](/packages/dhuny-mysqlj/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependenciesVersions (1)Used By (0)

mysqlj
======

[](#mysqlj)

A php / mysql library to convert mysqli into a multi-level reusable static query cache for HTML5 service workers and offline data usage

Installation
============

[](#installation)

Install the latest version with (Type composer without the $ sign on bash)

$ composer require dhuny/mysqlj:dev-master

Basic Usage
===========

[](#basic-usage)

Include the following codes in your PHP

require 'vendor/autoload.php';

use dhuny\\mysqlj\\mysqlj;

use dhuny\\mysqlj\\mysqlj\_result;

use dhuny\\mysqlj\\mysqlj\_cache;

use dhuny\\mysqlj\\filterfiles;

Application of the Library
==========================

[](#application-of-the-library)

Replace your mysqli library connection with a mysqlj one. i.e. Replace

$conn = new mysqli($hostname\_conn,$username\_conn,$password\_conn,$database\_conn);

by

$conn = new mysqlj($hostname\_conn,$username\_conn,$password\_conn,$database\_conn);

Use of MySQLj
=============

[](#use-of-mysqlj)

The mySQLj is a library that reads the DB queries and converts it into an apprpriate Web SQL database \[or easily modifyiable to IndexedDB\]. The Converted DB is saved in a js file bearing the same name as the php file. The JS file can then be recalled by the server to load the data from file rather than re-querying the DB server or pass that to the client to create a Multi level reusable static query cache for HTML5 service workers and offline data storage.

Testing the codes
=================

[](#testing-the-codes)

To Test the codes, pull same using composer \[composer require dhuny/mysqlj:dev-master\]. The vendor/dhuny/mysqlj/ contains some sample codes for testing purposes. Cut Connections folder, cache\*.php and existing\*.php. Paste them in the root folder of your project. Download and install Oracle Sample Employees Database [https://github.com/datacharmer/test\_db](https://github.com/datacharmer/test_db)Open Connections/ conn and set up your DB connections

Run Cache\*.php to test code.

This code is still experimental and currently in use as part of a research work referenced under IEEE Explore as \[\]. Library may be currently inappropriate for production as only a few mysqli classes were extended.

Notes
=====

[](#notes)

For queries, bugs and contributions the author can be contacted via

###  Health Score

20

—

LowBetter than 13% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity40

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/42516995?v=4)[Dhuny](/maintainers/Dhuny)[@dhuny](https://github.com/dhuny)

---

Top Contributors

[![dhuny](https://avatars.githubusercontent.com/u/42516995?v=4)](https://github.com/dhuny "dhuny (7 commits)")

### Embed Badge

![Health badge](/badges/dhuny-mysqlj/health.svg)

```
[![Health](https://phpackages.com/badges/dhuny-mysqlj/health.svg)](https://phpackages.com/packages/dhuny-mysqlj)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)