Some important notes!

PHP DataGrid is still in the development phase, so please...1. Make sure, that every table in the database you use has a primary key! 2. In "SELECT" SQL statement put this key field at the first place. 3. Don't use in your "SELECT" SQL statement "ORDER BY" option - it's ordered by primary key automaticly.Small bug in version 3.x.x:See forum discussing here.

New version 3.1.0 of PHP DataGrid

New version 3.1.0 of PHP DataGrid is available for downloading from now.General features of this version:-------------------------- View mode  -- Tabular layout  -- Columnar layout- Details mode  -- Columnar layout- Add new mode- Edit mode  -- Tabular layout  -- Columnar layout- Delete mode- Automatic validation   -- Client side - Columns sorting- Fields filtering- Paging   -- current/total pages

PHP DataGrid v.3.x.x

--------------------------------------------------------------To download version 3.2.0 click here.This version changes: - Added  -- ability to define array of page sizes  -- case sensitivity (filtering mode)  -- ability to define search field to be a dropdown box (filtering mode)  -- ability to add optional column in datagrid by editing SELECT SQL statement   -- new css template (default)  --

Code example for PHP DataGrid v.3.x.x

The blog's Forum

Dear readers and visitors!The Blog's forum is created to help Me and You to discuss any themes that related to PHP DataGrid script. If your question is about PHP DataGrid - please, leave it on the blog's Forum. It will really help me to prevent to get twice same answers.Thanks :)

New version 2.1.0 of PHP DataGrid

New version 2.1.0 of PHP DataGrid is available for downloading from now.Features of this version:-------------------------- View mode  -- Tabular layout  -- Columnar layout- Details mode  -- Columnar layout- Columns sorting- Fields Filtering- Paging   -- current/total pages selector  -- pager  -- page size drop-down box- Embedded css templatesTo download a new version click here.To see Live Demo

PHP DataGrid v.2.x.x

--------------------------------------------------------------To download version 2.1.0 click here.--------------------------------------------------------------PHP DataGrid documentation for version 2.x.x --------------------------------------------------------------1. System Requirements------------------------------PHP DataGrid is operating system independent. You get it works on both Linux

Code example for PHP DataGrid v.2.x.x

We have 3 tables:-- ---------------------------------------------------------- -- Table structure for table `tblRegions`-- CREATE TABLE `tblRegions` ( `RegionID` tinyint(3) unsigned NOT NULL auto_increment, `Name` varchar(20) NOT NULL default '', PRIMARY KEY (`RegionID`)) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;-- ---------------------------------------------

New version 1.1.1 of PHP DataGrid

New version 1.1.1 of PHP DataGrid is available for downloading now.Latest changes: - fixed bugs in getHeaderName() - fixed bugs in noDataFound() - fixed bugs in setColumnsInViewMode() To download a new version click here.

A few additions

1. Idea------------------------------The main idea behind the PHP DataGrid class is the full incapsulation of all needed methods. And also... creation, as fast as possible (few minutes), a good working application.2. Next version------------------------------2nd version comming soon and version 3.xx too... I can't simply upload my non-edited code that I wrote for myself. Sorry, but it should have