PHPackages                             a1phanumeric/php-mysql-class - 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. a1phanumeric/php-mysql-class

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

a1phanumeric/php-mysql-class
============================

A lightweight PDO helper for MySQL and SQL Server with prepared queries, transactions, and connection lifecycle utilities.

v3.0.0(2mo ago)361243↓90.9%251[16 issues](https://github.com/a1phanumeric/PHP-MySQL-Class/issues)[4 PRs](https://github.com/a1phanumeric/PHP-MySQL-Class/pulls)MITPHPPHP >=7.4

Since May 17Pushed 2mo ago44 watchersCompare

[ Source](https://github.com/a1phanumeric/PHP-MySQL-Class)[ Packagist](https://packagist.org/packages/a1phanumeric/php-mysql-class)[ RSS](/packages/a1phanumeric-php-mysql-class/feed)WikiDiscussions master Synced 1w ago

READMEChangelog (7)DependenciesVersions (11)Used By (0)

PHP MySQL Class (PDO)
=====================

[](#php-mysql-class-pdo)

A production-oriented PDO helper for PHP applications that need a small, dependency-free database abstraction with prepared statements, transaction helpers, and predictable error handling.

Highlights
----------

[](#highlights)

- PDO-first API with prepared statements by default
- Works with MySQL/MariaDB and Microsoft SQL Server
- Safe defaults for modern workloads:
    - `PDO::ERRMODE_EXCEPTION`
    - `PDO::ATTR_EMULATE_PREPARES = false` (MySQL)
    - UTF-8 (`utf8mb4`) MySQL charset by default
- Optional connection singleton keyed per connection config
- Transaction helpers (`beginTransaction`, `commit`, `rollBack`, `transaction`)
- Query execution helpers (`execute`, `fetch`, `fetchAll`)
- Optional query logger for observability and diagnostics

Installation
------------

[](#installation)

```
composer require a1phanumeric/php-mysql-class
```

Requirements
------------

[](#requirements)

- PHP `>=7.4`
- `ext-pdo`
- For MySQL: `ext-pdo_mysql`
- For SQL Server: `ext-sqlsrv`

Quick Start
-----------

[](#quick-start)

```