New version 4.2.8 of PHP DataGrid

The new version 4.2.8 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] russian translation (ru_utf8). Provided by: Ivan Borzenkov
2. * Feature: [added] French translation for JS AFV. Provided by: Abel MILCENT
3. * Feature: [added] new attribute for images: "magnify"=>"true" - magnify image on museover event.
4. * Feature: [added] new field tyoe in View Mode: linktodelete. Suggested by v.svetoslavov

1. = Feature: [improved] removed unnecessary including some javascript files
2. = Feature: [improved] changed default parameters in GetFieldProperty() method
3. = Feature: [improved] changed empty date/datetime values in details mode on empty strings
4. = Feature: [improved] changed draw_add_button_separately not documented property on
"show_add_button"=>"inside|outside" attribute in SetModes()

1. # Bug: [fixed] cashing files after downloading exporting file in FF and Opera
suggested by ivan
2. # Bug: [fixed] on drawing foreign key dropdown box
3. # Bug: [fixed] on drawing background for
4. # Bug: [fixed] on drawing enum dropdown boxes in oracle (suggested by Sriharan)
5. # Bug: [fixed] on drawing foreign key field in oracle (suggested by Sriharan)
6. # Bug: [fixed] on getting remote file content
7. # Bug: [fixed] on entering quotes is filtering fields
8. # Bug: [fixed] F5 button refresh click
9. # Bug: [fixed] Added JavaScript unicose simbols to alerts messages in language files
example of codes in languages/README.txt
10. # Bug: [fixed] Fixed errors on W3C validation (solution suggested by Vincent Cadet )



To view a Live Demo click here.

To download new version click here.

The new version 4.2.7 of PHP DataGrid.

The new version 4.2.7 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: russian (ru)
2. * Feature: [added] new type for fields in view mode: enum
3. * Feature: [added] new language: greek (gr). Provided by: tequilero@ath.forthnet.gr
4. * Feature: [added] new non-documented property - "NoDataFoundText"
5. * Feature: [added] new field type in view mode - "money" suggested by "drackor"
6. * Feature: [added] new field type in add/edit modes: "type"=>"foreign_key" for foreign keys
7. * Feature: [added] new attributes in filtering mode for dropdownlist: "show" and "condition"
suggested by Fcallez
8. * Feature: [added] new attribute sort_type="string|numeric" in view mode

1. = Feature: [improved] ignore filter field if there was empty 'table' or 'field' attribute
2. = Feature: [improved] in view mode in "case" attribute added new option "camel"
3. = Feature: [improved] all method rewritten from aaBbbCcc() into AaaBbbCcc mode

1. # Bug: [fixed] diactric chars error in IE for UTF-8 charset
2. # Bug: [fixed] with readonly attribute for "image" and "file" fields
3. # Bug: [fixed] for oracle in oci8.php - "Fatal error: Cannot use object of type DB_Error..."
etc.


To view a Live Demo click here.

To download new version click here.

Forum problems

I'm sorry, but we have a problems with http://www.phpbb88.com/ forum.
I hope these problems will be resolved soon.

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.