Lazy Mofo PHP MySQL Datagrid

Lazy Mofo (LM) PHP MySQL Datagrid is an open source and lightweight class written in the PHP server-side programming language and designed from the offset to help web developers easily performing CRUD (Create, Read, Update, Delete) operations on a MySQL database table.

Features at a glance

With the Lazy Mofo PHP MySQL Datagrid class you will be able to render forms and grids from a SQL statement or a table name, define radio, select and checkbox inputs, crop and resize images, as well as to upload documents.

Because you will be able to generate grids from SQL statements, the Lazy Mofo PHP MySQL Datagrid class can also be used for reporting. Grid features include sorting, pagination, inline editing and search.

The project is distributed as a single ZIP package that contains the main lazy_mofo.php class, as well as a demo that will help you get started with the Lazy Mofo (LM) PHP MySQL Datagrid library.

Under the hood

Taking a look under the hood of the Lazy Mofo (LM) PHP MySQL Datagrid PHP class, we can notice that is works only with PHP 5 or later, as well as with MySQL 5 or higher. Please note that Magic Quotes should be turned off on your configuration, mbstring and multibyte support should be activated, the PDO MySQL PHP module must be installed, and database table needs a primary key identity.

Various examples about how to use the Lazy Mofo (LM) PHP MySQL Datagrid PHP class, such as how to redirect to the edit screen after insert and update, define how a field is rendered, define custom output and input controls, customize the search form and search query, count records, set various events after insert, update or delete, export to CSV or add JQuery UI datepicker, can be found on the project’s website (see link below).

What is new in this release:

• Removed child grid
• Added validation
• Add proper counting with sql_calc_found_rows rathen than a separate query
• Added Picnic CSS compatibility
• Fixed grid_repeat_header_at
• Restored how clean_out removes illegal characters

What is new in version 2014-01-13:

• Fixed - date_in was should be testing for false, not

Requirements:

• PHP
• MySQL Community Edition
• Magic Quotes should be turned off
• PDO MySQL module installed for PHP
• Database table must have a primary key identity
• Multibyte support / mbstring must be enabled