Comments on: AMFDateConverter – Convert PHP AMF to Flex Date Class

By: DimiOrla

DimiOrla — Sat, 13 Mar 2010 09:03:21 +0000

Hey Nate,
My knowledge level is not so far, as to understand what your doing I gust started playing with flex amfphp, I thing your AMFDateConverter could be the solution i am looking for.
I am trying to get records from my table between two dates with UTC Date timestamps.
[code]
public function SelectReceiptsFilter ($Date1, $Date2) {
$query = "SELECT * FROM records_closed WHERE date BETWEEN '$Date1' AND '$Date2'";
return mysql_query($query);
}
If I hardcode ($Date1 = ’2010-03-11 00:00:00’;) the dates is php, I get the expected results in the browser.

Any ideas?
Thanks in advance
Dimitris.

By: ced

ced — Mon, 18 Jan 2010 13:55:39 +0000

ZendAmf convert Dates from PHP datetime to AS3 Date Class.
But datetime is available only since PHP 5.2
There is still a lot of PHP 5.1.6 installations out there.

To use ZendAMF on those, you need to convert dates as integer before sending them.

I use a similar technique as yours with getters and setters

By: Nate

Nate — Mon, 05 Jan 2009 03:01:17 +0000

@Carlos,

Ultimately that depends on how you are dealing with the data on the PHP backend. In some circumstances, you may want to multiply by 1000 on the PHP-end and if that is the case, the Flex-end might send a Number instead of a String.

This DateConverter class simply takes a few possible options that could be received from PHP and converts them to a Date class in Flex.

This DateConverter assumes any timestamp that it receives is based on System time, or the number of milliseconds since the epoch (Jan 1, 1970). Although you could easily modify the DateConverter to multiply by 1000 if you wish, I felt that this was a task more appropriate for PHP backend since Actionscript deals with timestamps differently than PHP’s Unix Timestamp does.

By: Carlos

Carlos — Sun, 04 Jan 2009 22:34:48 +0000

i tried your funciton, but didn’t work as fine as i’d like.
here, you can see an alternative:
http://www.actionscript.org/forums/showthread.php3?p=755574

and so i did one function that receives a string (cause from amfphp it cames as string):

public function transformDate(timestamp_in_seconds:String):String
{
//unix timestamp -> human date
var currDate:Date = new Date(parseInt(timestamp_in_seconds)*1000);
//timestamp_in_seconds*1000 – if you use a result of PHP time function,
//which returns it in seconds, and Flash uses milliseconds

var D:int = currDate.getDate();
var M:int = currDate.getMonth()+ 1;
//because Returns the month (0 for January, 1 for February, and so on)
var Y:int = currDate.getFullYear();
var H:int = currDate.getHours();
var N:int = currDate.getMinutes();
var Min:String;
if (N <10) {
Min = “0″ + N;
}
else {
Min = N.toString();
}
var theDate:String = (M + “/” + D + “/” + Y + ” – ” + H + “:” + Min);
return theDate;
}