README

A Composer-friendly, batteries-included facade over the InitORM stack — query builder, DBAL connection, ORM models and entities — plus a server-side helper for DataTables.js.

What is this?

initphp/database does not reimplement an ORM. It is the InitPHP-branded entry point to the InitORM stack:

If a feature is documented for InitORM, it works here under the InitPHP namespace.

Requirements

• PHP 8.1 or later
• ext-pdo and a PDO driver for your target database (pdo_mysql, pdo_pgsql, pdo_sqlite, …)

Installation

composer require initphp/database

Quick start

<?php
require __DIR__ . '/vendor/autoload.php';

use InitPHP\Database\DB;

DB::createImmutable([
    'dsn'      => 'mysql:host=localhost;port=3306;dbname=test;charset=utf8mb4',
    'username' => 'root',
    'password' => '',
]);

$rows = DB::select('id', 'title', 'author_id')
    ->from('posts')
    ->where('status', '=', 1)
    ->orderBy('id', 'DESC')
    ->limit(10)
    ->read()
    ->asAssoc()
    ->rows();

foreach ($rows as $row) {
    echo $row['title'], PHP_EOL;
}

Documentation

Topic-by-topic guides live in docs/:

At a glance

• Fluent CRUD that compiles to prepared statements (named parameter bag is handled internally).
• Per-driver SQL dialects (MySQL, PostgreSQL, SQLite, generic).
• Models with auto-derived schemas, configurable primary key, soft deletes, and created_at / updated_at plumbing.
• Entities with Laravel-style getColumnAttribute() / setColumnAttribute() hooks and dirty tracking via getOriginal().
• Transaction helper with retry attempts and a testMode flag that always rolls back.
• Query log channel that accepts a file path (with {year}/{month}/{day} placeholders), a callable, or any object exposing a critical() method.
• Server-side DataTables.js helper that handles search, sort, paging and per-column render callbacks — see docs/08-datatables.md.

Contributing

Org-wide guidelines (PSR-12, declare(strict_types=1), Conventional Commits, PHPStan + PHPUnit on every PR) live in the InitPHP .github repo:

• CONTRIBUTING.md
• CODE_OF_CONDUCT.md

Local checks before opening a PR:

composer qa     # phpcs + phpstan + phpunit
composer cs-fix # auto-format

Security

Please do not open a public issue for security vulnerabilities. The org-wide SECURITY.md describes the private disclosure channels (GitHub PVR + email).

Credits

Maintained by Muhammet ŞAFAK (info@muhammetsafak.com.tr).

License

MIT.