PHPackages                             tschueller/phpmysqlgrid - 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. tschueller/phpmysqlgrid

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

tschueller/phpmysqlgrid
=======================

A flexible MySQL data grid for PHP with support for filtering, sorting, pagination and CRUD operations.

v1.2.1(2w ago)013↓91.7%[1 PRs](https://github.com/tschueller/phpmysqlgrid/pulls)MITPHPPHP >=8.2CI passing

Since Sep 23Pushed 1w agoCompare

[ Source](https://github.com/tschueller/phpmysqlgrid)[ Packagist](https://packagist.org/packages/tschueller/phpmysqlgrid)[ RSS](/packages/tschueller-phpmysqlgrid/feed)WikiDiscussions main Synced 3d ago

READMEChangelog (4)Dependencies (6)Versions (24)Used By (0)

phpMySQLGrid
============

[](#phpmysqlgrid)

A flexible MySQL data grid library for PHP.

phpMySQLGrid provides a reusable class to display and manage MySQL table data in a grid with filtering, sorting, pagination, and CRUD actions.

[![Example Grid](docs/images/grid1.png)](docs/images/grid1.png)

Features
--------

[](#features)

- Table rendering with customizable columns
- CRUD modes: view, add, edit, delete
- Field types: text, boolean, lookup, password, selection, multiline text, file
- Sorting, filtering, and pagination
- PDO-based database access (MySQL, MariaDB, SQLite)
- Hook callbacks for add, edit, and delete workflows
- CSS-based styling with included themes

Requirements
------------

[](#requirements)

- PHP 8.2 or newer
- MySQL-compatible database

Installation
------------

[](#installation)

Install with Composer:

```
composer require tschueller/phpmysqlgrid

```

Assets (CSS/JS) are not automatically published. Use the provided CLI command from your host project (see [Asset Publishing](#asset-publishing-for-host-projects) below) to copy them into your web root.:

```
php vendor/bin/phpmysqlgrid-assets

```

For development in this repository:

```
composer install

```

Upgrade Guide (v0.5 to v1.0)
----------------------------

[](#upgrade-guide-v05-to-v10)

See the dedicated upgrade guide in [docs/upgrade-guide.md](docs/upgrade-guide.md#v05---v10).

Simple Example
--------------

[](#simple-example)

```