PHPackages                             nimter/conn2db - 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. nimter/conn2db

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

nimter/conn2db
==============

Conexión a base de datos en PHP 8 para las bases de datos postgresql, mariadb y mysql.

1.04(5y ago)1461MITPHPPHP ^7.3|^8.0

Since Jun 22Pushed 1w ago1 watchersCompare

[ Source](https://github.com/alxsmora1/Conn2db)[ Packagist](https://packagist.org/packages/nimter/conn2db)[ RSS](/packages/nimter-conn2db/feed)WikiDiscussions master Synced 5d ago

READMEChangelog (9)Dependencies (1)Versions (18)Used By (0)

Conn2db
=======

[](#conn2db)

Descripción
-----------

[](#descripción)

Conexión a base de datos en PHP 8.3 para las bases de datos PostgreSQL, MariaDB y MySQL. Conexión ligera y sin abstracciones para asegurar un mejor rendimiento en cada consulta; las consultas se realizan de manera explícita con soporte completo de prepared statements, transacciones y type hints.

Requisitos
----------

[](#requisitos)

- PHP >= 8.1
- Extensión PDO habilitada
- Driver PDO correspondiente (`pdo_mysql`, `pdo_pgsql`, etc.)

Configuración
-------------

[](#configuración)

Crear el archivo `.env` en la raíz del proyecto con el siguiente contenido:

```
DB_DRIVER="mysql"
DB_HOST="localhost"
DB_NAME="dbname"
DB_USER="root"
DB_PWD="password"
DB_PORT="3306"
DB_CODIFICATION="utf8mb4"
DB_LOCALE="es_MX"

```

> **Nota:** `DB_LOCALE` solo aplica para MySQL y MariaDB (configura `LC_TIME_NAMES`).
> Para PostgreSQL, esta variable se ignora de forma segura.

Para acceder a las funciones de conexión y cargar las variables del archivo `.env`, agrega el siguiente código en tu archivo principal:

```
require 'vendor/autoload.php';

use Symfony\Component\Dotenv\Dotenv;
use Nimter\Helper\Conn2db\Conn2db;

$dotenv = new Dotenv();
$dotenv->load(__DIR__.'/.env');
```

Ejemplos de consultas básicas
-----------------------------

[](#ejemplos-de-consultas-básicas)

### SELECT con parámetros

[](#select-con-parámetros)

```
$conn = new Conn2db();

$stmt = "SELECT username, avatar FROM users WHERE id = :id";
$result = $conn->query($stmt, ['id' => 1]);

foreach ($result as $row) {
    echo $row['username'];
}
```

### INSERT

[](#insert)

```
$conn = new Conn2db();

$stmt = "INSERT INTO users (username, email) VALUES (:username, :email)";
$affected = $conn->query($stmt, ['username' => 'john', 'email' => 'john@example.com']);
$newId = $conn->lastId();
```

### Parámetros manuales con `binder()`

[](#parámetros-manuales-con-binder)

```
$conn = new Conn2db();

$conn->binder('id', 42);
$result = $conn->query("SELECT * FROM users WHERE id = :id");
```

### Transacciones

[](#transacciones)

```
$conn = new Conn2db();

try {
    $conn->beginTransaction();

    $conn->query("UPDATE accounts SET balance = balance - :amount WHERE id = :id", ['amount' => 100, 'id' => 1]);
    $conn->query("UPDATE accounts SET balance = balance + :amount WHERE id = :id", ['amount' => 100, 'id' => 2]);

    $conn->commit();
} catch (\PDOException $e) {
    $conn->rollback();
    throw $e;
}
```

Manejo de errores
-----------------

[](#manejo-de-errores)

Desde la versión 2.0.0, la clase lanza excepciones en lugar de imprimir mensajes de error directamente. Esto evita la exposición de información interna al cliente y permite un control centralizado de errores:

```
try {
    $conn = new Conn2db();
    $result = $conn->query("SELECT * FROM users");
} catch (\RuntimeException $e) {
    // Variable de entorno faltante
    error_log($e->getMessage());
} catch (\PDOException $e) {
    // Error de conexión o consulta
    error_log($e->getMessage());
}
```

Extras
------

[](#extras)

Requiere la librería `symfony/dotenv`.

###  Health Score

42

—

FairBetter than 90% of packages

Maintenance64

Regular maintenance activity

Popularity12

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity69

Established project with proven stability

 Bus Factor1

Top contributor holds 93.3% 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 ~192 days

Recently: every ~25 days

Total

10

Last Release

424d ago

PHP version history (3 changes)1.0.0PHP ^7.3

1.04PHP ^7.3|^8.0

1.0.9PHP >=7.3|>=8.0

### Community

Maintainers

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

---

Top Contributors

[![alxsmora1](https://avatars.githubusercontent.com/u/20400353?v=4)](https://github.com/alxsmora1 "alxsmora1 (14 commits)")[![Copilot](https://avatars.githubusercontent.com/in/1143301?v=4)](https://github.com/Copilot "Copilot (1 commits)")

---

Tags

databasemariadb

### Embed Badge

![Health badge](/badges/nimter-conn2db/health.svg)

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

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[catfan/medoo

The lightweight PHP database framework to accelerate development

4.9k1.5M194](/packages/catfan-medoo)[ifsnop/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k5.5M69](/packages/ifsnop-mysqldump-php)[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58523.9M36](/packages/scienta-doctrine-json-functions)[aplus/database

Aplus Framework Database Library

3331.6M7](/packages/aplus-database)[clouddueling/mysqldump-php

PHP version of mysqldump cli that comes with MySQL

1.3k22.9k](/packages/clouddueling-mysqldump-php)

PHPackages © 2026

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