The new version 4.2.2 of PHP DataGrid! Last in 2007 year!

Dear friends of PHP DataGrid! This is the last version in 2007 year. I hope you have a fun with this cool script, that becomes more and more advanced (thanks for your efforts :)) I want to wish you and your family excellent financial and professional achievements in 2008. Thank again for all! See you next year here!

The new version 4.2.2 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 attributes for fields in view mode "tooltip" and "tooltip_type"
2. * Feature: [added] export to PDF (Provided by zewa666@gmail.com)
3 * Feature: [added] new language (pb) Brazilian Portuguese. Provided by Julio Formiga (form1ga@yahoo.com.br)
4. * Feature: [added] new attributes for fields in view/add/edit/details modes "visible"
5. * Feature: [added] cool DHTML/JavaScript Calendar (Provided by stephane.dekeyzer)
6. * Feature: [added] new attributes for date/time fields in add/edit mode "calendar_type"=>"popup|floating"
7. * Feature: [added] new icon in Control Panel - Refresh Pages (Provided by stephane.dekeyzer)

1. = Feature: [improved] fileAction() renamed in formAction() and placed in dg.js
2. = Feature: [improved] language files
3. = Feature: [improved] added security checking for arguments in download.php
4. = Feature: [improved] css style outputted in separated *.css files
5. = Feature: [improved] added [Clear] option for date/time field types

1. # Bug: [fixed] first letter upper case for header names
2. # Bug: [fixed] with LIMIT for Oracle and MSSQL in setSqlByDbType() method
3. # Bug: [fixed] with "title" attribute in view mode for links and linkbuttons
4. # Bug: [fixed] WYSIWYG doesn't work in Safari - added automatic detecting
and redefining textarea as simple type
5. # Bug: [fixed] in delete operation in edit mode
6. # Bug: [fixed] in listbox with multiple selection while uploading file or image
7. # Bug: [fixed] in debug mode in selectSQL() and executeSql() methods
8. # Bug: [fixed] sorting by date. Solution: using "sort_by" attribute, for sorting by needed field
9. # Bug: [fixed] with strtolower function for non-english letters
10. # Bug: [fixed] missing id attribute in some fields
11. # Bug: [fixed] error in FireFox on pagination event when more then 1 datagrid displayed om the screen
12. # Bug: [fixed] error on filtering when more then 1 datagrid displayed om the screen
13. # Bug: [fixed] in Firefox popup for "time" type field doesn't work
14. # Bug: [fixed] for non-numeric primary keys in multirow view
15. # Bug: [fixed] in setAutoColumnsInView/EditMode
16. # Bug: [fixed] with definition of "resizable" attribute for textarea
17. # Bug: [fixed] in getLcaseFooByDbType() method for pgsql
18. # Bug: [fixed] FF error: delete button (image) in edit mode wrong alignment

etc.


To view a Live Demo click here.

To download new version click here.

New version 4.2.1 of PHP DataGrid - Beta

The new version 4.2.1 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 field type - "time"
2. * Feature: [added] new language: Bulgarian
3. * Feature: [added] option: drawing add button separately (not documented)
4. * Feature: [added] new req_type for checkboxes fields: "c" - checked
5. * Feature: [added] non-documented: setHeadersInColumnarLayout();
6. * Feature: [added] non-documented: setDgMessages();
7. * Feature: [added] ability to write some fileds in "field"=>"f1, f2..." parameter of filtering field
8. * Feature: [added] new parameters for "enum" type: "multiple" and "multiple_size"
9. * Feature: [added] new layout type: customized (drawCustomized()) in view/details mode
10. * Feature: [added] new parameters for "link" type in view mode: "rel" and "title"
11. * Feature: [added] new option: show/hide search types dropdownbox

1. = Feature: [improved] language translation: German, Netherlands
2. = Feature: [improved] "image" size attributes: height and width
3. = Feature: [improved] faster working in view and detail modes
(removed unnecessary including form.scripts.js, resize.js (~60Kb))
4. = Feature: [improved] faster working in add and edit modes
(removed unnecessary including wysiwyg.js (~35Kb))
5. = Feature: [improved] added errors handling for selectSqlItem/executeSql
6. = Feature: [improved] function setBrowserDefinitions in separateed file in folder "functions/"

1. # Bug: [fixed] wrong variable value while uploading
2. # Bug: [fixed] when using GROUP BY in SELECT SQL statement
3. # Bug: [fixed] in drawing foreign keys
4. # Bug: [fixed] with processing datemdy type in calendar
5. # Bug: [fixed] in "link" type with multiple parameters processing
6. # Bug: [fixed] LIMIT (OFFSET) error for PostgreSql statements
7. # Bug: [fixed] error with mysql_real_escape_string for different db types
8. # Bug: [fixed] with alignment of images in view mode
9. # Bug: [fixed] on Update with readonly fields

etc.


To view a Live Demo click here.

To download new version click here.

New version 4.2.0 of PHP DataGrid - release

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

Special THANKS to all who was helping this project. I think we have now a really stable version. Any way, the list of 'TODO' is full of features I need to add still.

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

Two short remainders:

1) Remember! This is not an updatable version. If you use old version of PHP DataGrid - you need to reinstall it (see here how you do it).

2) Only version 4.2.0 or above will be supported from now!



To view a Live Demo click here.

To download new version click here.

BETA version 4.1.9 of PHP DataGrid

The BETA version 4.1.9 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] uploading images and files from remote hosting: "host"=>"remote"
* Feature: [added] added new source format for "enum" field type:
$fill_from_array = array("0"=>"No", "1"=>"Yes");
* Feature: [added] added new source format for dropdownlist in filtering mode:
$fill_from_array = array("0"=>"No", "1"=>"Yes");
* Feature: [added] new not-documented method getNextId()

* Feature: [improved] reduced page's HTML output (~ upto 6%)
* Feature: [improved] lang.php file splited in separate language files
* Feature: [improved] myDate() method
* Feature: [improved] language file - added Serbian
* Feature: [improved] "enum" field type in "details" mode

# Bug: [Fixed] with using WHERE in SELECT SQL statment in view mode
# Bug: [Fixed] undefined index error in drawFiltering() method
# Bug: [Fixed] wrong detection of "https://" in getProtocol() method
# Bug: [Fixed] wrong placed ")"
# Bug: [Fixed] in filtering with 2 DG's on one page
# Bug: [Fixed] in "maxlength" property for textarea
# Bug: [Fixed] <!--// error in some browsers
# Bug: [Fixed] wrong action onclick event when back button is image or button.

etc.

You can get and test it NOW!!!.

New 1.0.4 version of JS Auto Form Validator

New 1.0.4 version of JS Auto Form Validator is available for downloading from here.

Changes in this version:
-----------------------
* Feature: [added] third letter for sub-type of field
* Feature: [added] new option - handle each/all error/s
* Feature: [added] new parameter - "handle_hidden_fields" in onSubmitCheck()
* Feature: [improved] filled array of diactric uppers

To view a Live Demo click here.