[tcooper]

I have a form in PHP. There is a textbox where the user enters a project start date (mm/dd/yyyy). I need to then import this date into mysql but don't know how to convert it to the proper format (yyyy/mm/dd). Can you please help?

[Acecool]

Do this.

time();

Insert that value into the db, then date("FORMAT", $Fetch_Timestamp_From_Mysql); and it will turn it into a user friendly date.

[korn]

Originally Posted by Acecool

Do this.

time();

Insert that value into the db, then date("FORMAT", $Fetch_Timestamp_From_Mysql); and it will turn it into a user friendly date.

does there a function exist for doing the opposit?(turning 19/11/2003 back to timestamp...)

thx m8te

[blaw]

Hi,

Originally Posted by korn

does there a function exist for doing the opposit?(turning 19/11/2003 back to timestamp...)

thx m8te

If you need to convert your date string into UNIX timestamp, check these out:

mktime()
http://www.php.net/manual/en/function.mktime.php

strtotime()
http://www.php.net/manual/en/function.strtotime.php

Hope this helps.

[pshylocke]

Originally Posted by tcooper

I have a form in PHP. There is a textbox where the user enters a project start date (mm/dd/yyyy). I need to then import this date into mysql but don't know how to convert it to the proper format (yyyy/mm/dd). Can you please help?

I may be over simplifying but couldn't you just put 3 fields in the form for a date (I see many sites do this).

Code:

<input type="text" name="month" size="2">
<input type="text" name="day" size="2">
<input type="text" name="year" size="4">

It should look fine then you could just do:

Code:

$tstamp = $year . -$month . -$day

The dash isn't necessary but gives a nice touch if you printf/view $tstamp.

[blaw]

Good morning. What a nice day today (in Vancouver)!

Anyways, in reply to pshylocke, I totally agree with your suggestion - the simpler, the better, and the simplest, the best.

But if the user input in this case is like "yyyy/mm/dd" or "dd/mm/yyyy", then you have to chop this string into threee parts. Besides, the last question was asking the way to convert this into unix timestamp, if I was not mistaken. So mktime() or strtotime() in conjunction with substr(), I thought, was a good idea.

Good day.

[pshylocke]

Originally Posted by blaw

Good morning. What a nice day today (in Vancouver)!

Anyways, in reply to pshylocke, I totally agree with your suggestion - the simpler, the better, and the simplest, the best.

But if the user input in this case is like "yyyy/mm/dd" or "dd/mm/yyyy", then you have to chop this string into threee parts. Besides, the last question was asking the way to convert this into unix timestamp, if I was not mistaken. So mktime() or strtotime() in conjunction with substr(), I thought, was a good idea.

Good day.

I see what your sayin Blaw. Just gettin my feet wet