date-timestamp-date best way..?

davieboy

i am using a date in the form of:

dd/mm/yyyy

and comverting it into a timestamp todo work on it via a db.
then am trying to convert it from a timestamp back to a normal date using:

$timed = date('d M y',$date1);

however it give incorrect/werid and generally messed up dates that do not resemble the ones entered a few pages previously

i am guessing this is due to me but i dont know how to sort my error.

Can anyone show me?

David

mattvenables

How are you converting the date to a timestamp?

$date= date("d/m/Y");
$date1 = strtotime("$date");
echo date("d/m/Y", $date1);

will print out the date in the correct form for you...

maybe you are entering the date wrong?

note that 'd M y' will return '21 Aug 04' for todays date...

goto http://us4.php.net/manual/en/function.date.php for the formatting options.

hope this helped

-matt

davieboy

this is how i am cunverting it:

$dday = $day;
$dmonth = $month;
$dyear = $year;
$date1 = mktime(0,0,0,$dday,$dmonth,$dyear);

david

mattvenables

try the following:

$dday = (int)$day;
$dmonth = (int)$month;
$dyear = (int)$year;
echo date("d/m/Y", mktime(0,0,0,$dday,$dmonth,$dyear));

what does that print? the same incorrect/werid result a few pages later?

btw, what was the incorrect/werid output?

davieboy

the odd outputs are for example:

entered
01/07/04
10/07/04

feedback (read from timestamp)
01 Jan 70
01 Jan 70

not tried the code there. i will do in a while

David

sidney

$date1 = mktime(0,0,0,$dday,$dmonth,$dyear);

should be

$date1 = mktime(0,0,0,$dmonth,$dday,$dyear);

davieboy

but i want the UK date format

sidney

thats all well and good but mktime creates a timestamp not a formatted date

and it accept it arguments

as below

mktime ( [int hour [, int minute [, int second [, int month [, int day [, int year [, int is_dst]]]]]]])

http://uk.php.net/manual/en/function.mktime.php

davieboy

so whats the best thing to do?

sidney

you have used mktime incorrectly

so your timestamp is wrong

so when you convert back your formated date is wrong

use the mktime correctly and things should be fine
example.

 $dates=array('29/07/04','30/07/04'); 
foreach($dates as $date)
	{
	list($day,$month,$year)=explode("/",$date);
$dday = $day; 
$dmonth = $month; 
$dyear = $year; 
$date1 = mktime(0,0,0,$dmonth,$dday,$dyear);
$date2 = mktime(0,0,0,$dday,$dmonth,$dyear);
echo $date." date1 = ".date('d/m/Y',$date1)." date2 = ".date('d/m/Y',$date2).'<br>';
}

output

29/07/04 date1 = 29/07/2004 date2 = 07/05/2006
30/07/04 date1 = 30/07/2004 date2 = 07/06/2006