How it works

GriD12 replaces a familiar, tedious ritual — hand-coding the same list/create/edit/delete screen for every table — with an innovative three-step workflow that gets you a working data grid immediately, without adding a single external dependency to your project.

1. Point it at your database

Set your MySQL connection once in config.php. GriD12 reads your table structure directly from the database, so it always stays in sync with your schema.

2. Describe your grid

In your own PHP file, create a small configuration array: the table, the columns you want, their labels, types, permissions and any lookups.

<?php
$config = [
    'table'       => 'payments',
    'primary_key' => 'aid',
    'title'       => 'Payments',
    'permissions' => 'CRUD',
    'columns'     => [ /* your columns */ ],
];
include __DIR__ . '/grid12/grid12.php';

3. Include and run

Include grid12.php and open the page — nothing to compile, bundle or install. You immediately get a responsive grid with create, edit, delete, search, sorting, pagination and CSV export — all driven by your configuration.

That is the whole workflow: configure, include, run. No build pipeline, no framework lock-in, no dependencies beyond PHP and MySQL — just an innovative, refreshingly direct way to solve a problem developers usually over-engineer.

See the theming system live

Every grid12 screen honors one of four built-in themes — the same CSS variables shown below are exactly what a real grid renders with, no extra work on your part. Click a theme to preview it:

For the full configuration reference — every column option, column type, theming, localization, security details and more — see the GriD12 documentation.

See it in action

Prefer to see it running before you write any code? Try the live demo of the free edition. This is a Read-only demo — create, edit and delete are disabled, so you can safely browse the grids without a CRUD workflow. It contains a set of ready-to-browse examples:

• Supplier Payments — the core grid layout, with a supplier lookup, European number and date formatting, per-column search, sorting, pagination and CSV export.
• Suppliers — the same kind of grid without lookups, showcasing the built-in dark theme.
• Supplier Payments — Grouped Summary — rows grouped by supplier with collapsible sections and subtotals.
• Supplier Payments — Hidden Column — a column hidden from the grid and from CSV export, while remaining present in the underlying form.
• Supplier Payments — Read-Only Field — a field that is shown but cannot be edited, enforced on the server.
• Products — a calculated column (Unit Price × Quantity) computed on the fly.
• Notes — rich-text editing with a WYSIWYG editor and server-side sanitization.

Want to try the full Create, Read, Update, Delete workflow? Contact us and we will set you up with a 12-day trial of GriD12 with complete CRUD access.