The new version 4.2.6 of PHP DataGrid (with AJAX autocomplete)

The new version 4.2.6 of PHP DataGrid is available for downloading from here.

There are some changes in this version. Read carefully Getting Started.

From Version 4.2.4 PHP DataGrid works with PHP 5 ONLY!!! If you still use PHP 4 - find old version in "php4" folder

Main additions and improvements:

1. * Feature: [added] new language Romanian(ro/ro_utf8), provided by: Rotter Robert
2. * Feature: [added] new attribute "width" in filtering fields
3. * Feature: [added] new method: allowExportingTypes();
4. * Feature: [added] abbility to use in Filtering "," to make a search by some words
5. * Feature: [added] new feature for textbox in filtering: AJAX autocomplete function (provided by Jordi Nin)


1. # Bug: [fixed] syntax error in css classes
2. # Bug: [fixed] in drawing tabular layout of filter drawing
3. # Bug: [fixed] error on Upper/Camel case in "field_data" attribute for "link" fields
4. # Bug: [fixed] in floatingToolTipsFieldExists() method
5. # Bug: [fixed] with "Back" button, when it was not allowed
6. # Bug: [fixed] with "Upload" link for images and files, when field defined as readonly.
7. # Bug: [fixed] error with numRows() method for oracle
8. # Bug: [fixed] in selectSqlItem() and executeSql()
9. # Bug: [fixed] with on_js_event attribute
etc.


To view a Live Demo click here.

To download new version click here.

The new version 4.2.5 of PHP DataGrid.

The new version 4.2.5 of PHP DataGrid is available for downloading from here.

There are some changes in this version. Read carefully Getting Started.

From Version 4.2.4 PHP DataGrid works with PHP 5 ONLY!!!

Main additions and improvements:

1. * Feature: [added] non-documented feature - parameter true|false in bind() method: draw DataGrid or not
2. * Feature: [added] new language (cz) - Czech
3. * Feature: [added] new type "calendar" for filter fields
4. * Feature: [added] new attribute "on_js_event" for filtering fields

1. = Feature: [improved] removed refresh image in print view
2. = Feature: [improved] added new filter operator type "%like%"
3. = Feature: [improved] in simple calendar date starts from -65 years from now.
4. = Feature: [improved] improved sequrity check for form sending values

1. # Bug: [fixed] in DrawFiltering with selection of default option in dropdown listbox
2. # Bug: [fixed] "condition" parameter in setTableEdit() wasn't work in Columnar layout
3. # Bug: [fixed] case in default attribute for fields
4. # Bug: [fixed] in export methods
5. # Bug: [fixed] in case sensetivity for headers
6. # Bug: [fixed] in details mode when no fields defined
etc.


To view a Live Demo click here.

To download new version click here.

The new version 4.2.4 of PHP DataGrid - PHP 5 !!!

The new version 4.2.4 of PHP DataGrid is available for downloading from here.

There are some changes in this version. Read carefully Getting Started.

From This Version PHP DataGrid works with PHP 5 ONLY!!!

Main additions and improvements:

1. * Feature: [added] new css class "pink"
2. * Feature: [added] sequrity check for add/edit/delete records if this options was not allowed
3. * Feature: [added] abbility to change paging arrows by $paging_arrows = array()
4. * Feature: [added] new non-documented method: getCurrentId()
5. * Feature: [added] new non-documented property: mode_after_update
6. * Feature: [added] new language Turkish (tr), provided by: Murat HALACOGLU

1. = Feature: [improved] re-written with PHP 5
2. = Feature: [improved] added checking of maximal page size for possible hack tack
3. = Feature: [improved] css class "gray"
4. = Feature: [improved] column headers separated from other GataGrid link by css class a_header
5. = Feature: [improved] in addRow()added detecting of rid
6. = Feature: [improved] language files
7. = Feature: [improved] added alert if file or image was not uploaded before update

1. # Bug: [fixed] changed href='#' on href='javascript:void(0);'
2. # Bug: [fixed] in columns summarizing
3. # Bug: [fixed] in bind() on tabular layout for edit mode
4. # Bug: [fixed] column headers in tabular layout (edit mode)
5. # Bug: [fixed] in creating this->HTTP_URL data member
6. # Bug: [fixed] in radiobuttons_alignment for foreign keys
7. # Bug: [fixed] in setUrlStringPaging()
8. # Bug: [fixed] in getNextId() method
9. # Bug: [fixed] in getting default property value for add mode
10. # Bug: [fixed] in $this->combineUrl() for primary key with leading zeros

etc.


To view a Live Demo click here.

To download new version click here.

The new version 4.2.3 of PHP DataGrid - more faster and safer!

The new version 4.2.3 of PHP DataGrid is available for downloading from here.

There are some changes in this version. Read carefully Getting Started.

Main additions and improvements:

//1. * Feature: [added] new option in debug mode: running time of the script
//2. * Feature: [added] simple primary key preliminary
//3. * Feature: [added] added new required filed type "u" - URL
//4. * Feature: [added] added new language - Arabic (ar)
// // provided by: Abdelmonim Osman
//5. * Feature: [added] new property in enum and foreign fields: "radiobuttons_alignment"=>"horizontal|vertical"
//6. * Feature: [added] new field type "validator" with attribute "for_field"=>""
//7. * Feature: [added] new field attribute (not documented)
// "pre_addition" and "post_addition" in view mode for labels and in add/edit/details modes for textboxes
//8. * Feature: [added] new field attribute (not documented): "autocomplete"=>"on|off"
//9. * Feature: [added] securityCheck() method to prevent hack attacks

//1. = Feature: [improved] german language file
//2. = Feature: [improved] debug mode: added POST and GET data displayed.
//3. = Feature: [improved] detecting error in setAutoColumnsInView/EditMode
//4. = Feature: [improved] refreh button shown only if there is a filtering allowed
//5. = Feature: [improved] reducing datagrid script running time by changing one stupid SQL SELECT statement
//6. = Feature: [improved] parameter "field_name" for foreign keys may accept values like: "field_name as my_field_name"
// // provided by: Franklin Calle Zapata (fcallez@gmail.com)

//1. # Bug: [fixed] wrong field attribute syntax: "operator" instead of "show_operator"
//2. # Bug: [fixed] wrong comparison in drawRadioButtons() method
//3. # Bug: [fixed] wrong comparison in drawDropDownList() method
//4. # Bug: [fixed] wrong predefined css_class in writeCssClass() method()
//5. # Bug: [fixed] wrong error and warnings displaying
//6. # Bug: [fixed] wrong order in $fill_from_array for filter mode
//7. # Bug: [fixed] javascript error with resizable texareas
//8. # Bug: [fixed] javascript error with hiding loading images when two DataGrids on one page have a same prefix
//9. # Bug: [fixed] in displaying "enum" type in details mode
//10. # Bug: [fixed] permissions for uploaded filed in add/edit mode (added 0644)
//11 # Bug: [fixed] wrong selection of option in ddl for foreign key in add mode
//12. # Bug: [fixed] with CR & LF signs in floating tooltips
//14. # Bug: [fixed] double parameter in URL: "selSearchType"
//15. # Bug: [fixed] in urlencoding while search
//16. # Bug: [fixed] if sql statment was containing sign of new row
//15. # Bug: [fixed] pagination error for MSSQL in setSqlByDbType() method
//16. # Bug: [fixed] in GROUP BY clause for SELECT SQL statements

etc.


To view a Live Demo click here.

To download new version click here.

Cool DataGrud layout

New example #4 of very cool DataGrid layout in Live Demo.
To see it, click here.