PHPackages                             aldisaglobal/mysql-db - 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. aldisaglobal/mysql-db

ActiveLibrary

aldisaglobal/mysql-db
=====================

A Simple Iterateable MySQL DB Query Object

v0.2.1(5y ago)028MITPHPPHP ^7.0

Since Oct 26Pushed 5y ago1 watchersCompare

[ Source](https://github.com/aldisaglobal/mysql-db)[ Packagist](https://packagist.org/packages/aldisaglobal/mysql-db)[ RSS](/packages/aldisaglobal-mysql-db/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (3)DependenciesVersions (4)Used By (0)

Library Package
===============

[](#library-package)

Vendor: aldisaglobal
Package: mysql-db
Author: Abid
Version: 0.2

Connection Parameters
---------------------

[](#connection-parameters)

Make available the following Connection parameters:

- `MYSQL_HOST` *the URI for the MySQL server*
- `MYSQL_USER` *the username*
- `MYSQL_PASS` *the password*
- `MYSQL_DB` *the database*

### Option 1: As Environment Variables

[](#option-1-as-environment-variables)

Place connection params in $\_ENV superglobal Optional: You can use the \\vlucas\\dotenv package with a .env file to populate $\_ENV variables

### Option 2: As Constants

[](#option-2-as-constants)

You can `define` these constants in a settings file

### Option 3: As an Array

[](#option-3-as-an-array)

You can create and pass a parameters array to the create method `$params = array('MYSQL_HOST'=>"hostname", ...)`

Instantiate a Database Object
-----------------------------

[](#instantiate-a-database-object)

Use the static `create` method to get the DB object:

```
use AldisaGlobal\MySQL\DB;

$db = DB:create([$params]);

```

Execute queries on the Database Object
--------------------------------------

[](#execute-queries-on-the-database-object)

`$db->query("...mysql statement...");`

Iterate SELECT Queries
----------------------

[](#iterate-select-queries)

```
foreach ($db as $row) {
	echo $row->field;
}

```

The full Object API
-------------------

[](#the-full-object-api)

`\AldisaGlobal\MySQL\DB::create([$params])` - returns object with connection

`$db->init()` - closes any open result

`$db->escape($str)` - returns escaped string

`$db->getResponse()`- returns last server response

`$db->getError()` - returns error string from last query

`$db->getErrno()`- returns errno from last query

`$db->hasError()` - true if last query had an error

`$db->query($sql [, $buffered=true])`- executes query, pass false as second arg for unbuffered query

`$db->hasResult()` - whether query returned a result

`$db->getInsertID()`- returns InsertID of last insert query

`$db->getRow()`- returns the current row

`$db->getNextRow([$mode = "object"])`- returns next row of result as object \[pass "array" to get back an assoc array\]

`$db->getFirstRow([$mode = "object"])` - returns first row of result as object

`$db->getRowNum($num [, $mode = "object"])` - returns row at $num index

`$db->getNumFields()`- returns number of columns in result row

`$db->getFields()` - returns array of column names

`$db->getNumRows()` - returns total number of rows in result \[not accurate for unbuffered queries\]

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity41

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.

###  Release Activity

Cadence

Every ~23 days

Total

3

Last Release

1977d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/d192c3dc046d35b92878159806aa1aa4d9b755a6945c3e9313666faad5cbb7d9?d=identicon)[aldisaglobal](/maintainers/aldisaglobal)

---

Top Contributors

[![aldisaglobal](https://avatars.githubusercontent.com/u/70720980?v=4)](https://github.com/aldisaglobal "aldisaglobal (16 commits)")

### Embed Badge

![Health badge](/badges/aldisaglobal-mysql-db/health.svg)

```
[![Health](https://phpackages.com/badges/aldisaglobal-mysql-db/health.svg)](https://phpackages.com/packages/aldisaglobal-mysql-db)
```

PHPackages © 2026

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