PHP download

Download the PHP package a1phanumeric/php-mysql-class without Composer

On this page you can find all versions of the php package a1phanumeric/php-mysql-class. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download a1phanumeric/php-mysql-class
More information about a1phanumeric/php-mysql-class
Files in a1phanumeric/php-mysql-class

Vendor a1phanumeric
Package php-mysql-class
Short Description A lightweight PDO helper for MySQL and SQL Server with prepared queries, transactions, and connection lifecycle utilities.
License MIT

Keywords database php mysql pdo sqlserver

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of a1phanumeric/php-mysql-class

Informations about the package php-mysql-class

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

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

Requirements

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

Quick Start

Usage

1) Standard queries

2) Fetch a single row

3) Fetch many rows

4) Key `fetchAll` by a column

5) Transactions (recommended for multi-step writes)

6) Singleton connection (per unique connection configuration)

7) Connection options

SQL Server example:

8) Diagnostics and observability

If a query fails, inspect:

API Reference

execute(string $query, $values = null, bool $debug = false): PDOStatement|false
fetch(string $query, $values = null): ?array
fetchAll(string $query, $values = null, ?string $key = null): array
table_exists(string $table): bool
beginTransaction(): bool
commit(): bool
rollBack(): bool
inTransaction(): bool
transaction(Closure $callback)
lastInsertId(): string
getPdo(): ?PDO
getLastError(): ?string
setQueryLogger(callable $logger): self

Backward Compatibility Notes

Existing constructor usage continues to work.
Existing execute, fetch, and fetchAll method names remain unchanged.
execute(..., $debug = true) is deprecated and should be replaced with setQueryLogger().
Singleton behavior is now safer for multi-database apps: each unique connection configuration gets its own instance.

Security Notes

Always use placeholders with bound parameters for user input.
Avoid persistent connections unless you have validated behavior under your workload.
Enable TLS/secure transport for SQL Server (encrypt => true) in production.

Releasing / Tagging for Packagist

Packagist picks up new versions from Git tags.

Update docs/changelog for the release.
Commit and push to your default branch.
Tag using semantic versioning.
Ensure your Packagist package auto-update webhook is configured, or trigger an update manually in Packagist.

Recommended versioning for these changes: major release (v3.0.0) for a clean SemVer boundary on the upgraded production behavior and API surface.

Legacy Class

The legacy class is still included in this repository:

class.MySQL.php
class.MySQL.README.md

License

MIT

All versions of php-mysql-class with dependencies

PHP Build Version

Package Version

Version v3.0.0 Release 23. Feb 2026
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of php-mysql-class from vendor a1phanumeric

Requires php Version >=7.4
ext-pdo Version *

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package a1phanumeric/php-mysql-class contains the following files

Loading the files please wait ...