BETA version 4.1.7 of PHP DataGrid

The BETA version 4.1.7 of PHP DataGrid is available for downloading from here.

Main additions, changes and bugs fixed in this version you can read about in our forum.

Main additions and improvements:
* Feature: [added] new method setJsErrorsDisplayStyle() and option to display
all error together
* Feature: [added] new option "textbox" in "view_type" for foreign keys
* Feature: [added] new field type in add/edit modes: "hidden"
* Feature: [added] new field type in add/edit/details modes: "delimiter"

* Feature: [improved] details/delete and multi-row columns have fixed width
* Feature: [improved] parameter "image_name" renamed in "file_name" for "image" and "file" types in add/edit/detail modes
* Feature: [improved] css classes naming and work
* Feature: [improved] encoding of data. Added collation parameter in setEncoding()
* Feature: [improved] debugger messaging system
* Feature: [improved] getting Primary Key and spliting strings in the code

# Bug: [Fixed] error if missing "req_type" parameter in add/edit/detail modes
# Bug: [Fixed] small bug with multi-row in details mode with tabular layout
# Bug: [Fixed] small bug in title for textarea
# Bug: [Fixed] small bug in setInterfaceLang()
# Bug: [Fixed] file uploading error in add mode
# Bug: [Fixed] wrong handling of "unique" parameter in add/edit mode
# Bug: [Fixed] highlighting small bug in view/details mode
# Bug: [Fixed] wrong fieldset width in view mode
# Bug: [Fixed] wrong ORDER BY parameter in SELECT SQL in add mode
# Bug: [Fixed] wrong alignment of foreign key output
# Bug: [Fixed] wrong displaying of datagrid in print preview in edit/detail modes
# Bug: [Fixed] css clas_a/class_a2 missed parameter
# Bug: [Fixed] missed unique prefix for cookie vars in hideUnHideFiltering() function
# Bug: [Fixed] unexpected 'http://'s in link type in view/detail modes

etc.

You can get and test it NOW!!!.

New Wiki format documentation for the DataGrid.

I've decided to improve documentation for DataGrid by using the Wiki. This also allow me to keep the documentation updated by the easiest way. From now you can see, edit or translate (if you wish, of course) all updated documentation in the Wiki format here:

Installation of PHP DataGrid

Getting Started

BETA version 4.1.6 of PHP DataGrid

The BETA version 4.1.6 of PHP DataGrid is available for downloading from here.

Main additions, changes and bugs fixed in this version you can read about in our forum.

I've started to rewrite current "Installation" & "Step by Step" guides in the Wiki format. If you want to help me and other peoples, you are welcome to translate this page in other languages.

Main additions and improvements:
Feature: [added] new type "linktoedit" for view mode
Feature: [added] display order of columns defined by user, not by order in SELECT SQL
Feature: [added] new parameter "unique" for columns in edit mode
Feature: [added] new parameters for type texarea: "rows"=>"7" and "cols"=>"50"

Feature: [improved] method getRequestVars() renamed in getVariable()
Feature: [improved] downloading of export files
Feature: [improved] detecting filed properties while auto code generation
Feature: [improved] selecting and highlighting rows
Feature: [improved] removed unnecessary sql statments on updating/deleting

Bug: [Fixed] small bug in setModes() function
Bug: [Fixed] strtolower() small bug in some place
Bug: [Fixed] wrong URL after the click on 'Reset' button
Bug: [Fixed] missing WHERE in SQL SELECT error
Bug: [Fixed] LCASE error for Oracle and MSSQL
Bug: [Fixed] canceling of row highlighting, with click on delete button in IE
Bug: [Fixed] wrong syntax with NUMROWS processing for Oracle
Bug: [Fixed] syntax error in setSqlByDbType() and setSqlLimitByDbType()
Bug: [Fixed] FireFox error on carrying out multirow operations and pagging (&)
Bug: [Fixed] empty data error on required numeric fileds while updating
Bug: [Fixed] error on deleting last row from the last page

etc.

You can get and test it NOW!!!.

BETA version 4.1.5 of PHP DataGrid

The BETA version 4.1.5 of PHP DataGrid is available for downloading from here.

Main additions, changes and bugs fixed in this version you can read about in our forum.

Main additions and improvements:
- LIMIT/TOP/NUM_ROWS processing for different database types
- new parameter: "on_js_event"=>"" for Add/Edit/View Modes
- new type "link" for add/edit/details mode
- ability yo use some fields for default order in View Mode
- warnings messages system
- small image preview on uploading
- new parameter for image type: "image_name"=>"Image_Name"
- new parameters for foreign keys:
"order_by_field"=>"Field_Name" and "order_type"=>"ASC|DESC"

etc.

You can get and test it NOW!!!.

Also, -
special thanks to people sending me solutions for found bugs. :)

BETA version 4.1.4 of PHP DataGrid

The BETA version 4.1.4 of PHP DataGrid is available for downloading from here.

Main additions, changes and bugs fixed in this version you can read about in our forum.

Main additions and improvements:
- Auto columns generation
- Multy-rows view details
- export in XML format
- new methods: executeSQL() & selectSQL
- some new parameters for column types
- default values for fields
- new languages
- many things improved
- many bugs fixed (uploading for some files, working in firefox etc.)

So... get it NOW!!!.