Topic-focused guides for initphp/database. Each page is self-contained — read in order if you are new, jump around if you are looking something up.
| # | Page | What you will find |
|---|---|---|
| 01 | Getting started | Installation, the connection array, your first query, debug & log channels. |
| 02 | Query Builder | select, where, join, groupBy, orderBy, limit, raw fragments, sub-queries. |
| 03 | CRUD | create / read / update / delete, their *Batch siblings, and raw SQL via query(). |
| 04 | Models | Subclassing Model, table binding, primary keys, soft deletes, timestamp columns, gates. |
| 05 | Entities | The attribute bag, accessor / mutator hooks, dirty tracking, and the one PHP 8.2+ pitfall to avoid. |
| 06 | Transactions | transaction() with retry attempts and testMode. |
| 07 | Query log | enableQueryLog / getQueryLogs and the connection-level log channel. |
| 08 | Datatables | Server-side DataTables.js integration end-to-end. |
| 09 | Multiple connections | Secondary databases via DB::connect() and Model::$credentials. |
| 10 | Upgrading | Breaking changes in 5.0 and the migration path from 3.x / 4.x. |
If something is missing or unclear, please open an issue or start a Discussion.