February 19th, 2006
Issue with PDO Adaptor wrt MySQL DateTime Datatypes in AMFPHP Remoting
Lately, during a project development involving PHP 5, MySQL 5 and AMFPHP 1.1 Remoting, we realized that there is an issue with the PDO Adaptor that comes with AMFPHP with respect to the MySQL DateTime datatypes. Well, we would like to term it more of a missing feature than a bug/issue and hope to see it included in the next release of AMFPHP with the updated PDO Adaptor bundled.
Basically AMFPHP comes with various recordset adaptors depending on what database/abstraction layer you are using, like mysqli, PDO etc. The adaptors that currently comes with it, do not convert datatypes correctly when returning the recordset to Flash. Selecting a datetime datatype returns a string date to flash as opposed to a date object.
And since the timezone offset is not included in the date string, the flash client parses the datetime with an incorrect timezone offset.