---- Mark Bomgardner <mbomgardner@xxxxxxxxx> wrote:
> I need to convert a date retrieved from user input to a mysql date. Here
> the problem, I need to convert one of three possible combinations, either
> 01/01/2008,01-01-2008 or 01.01.2008. I can't use explode because it's
> limited to one character to explode on. I would prefer not to use regexp,
> but think I am going to have to. The one part of the code that works below
> is using 01/01/2008 format. Any suggestions
>
> echo $olddate = '06/06/2008';
> echo "<br />";
> echo $olddate2 = '06-16-2008';
> echo "<br />";
> echo $olddate3 = '06.26.2008';
> echo "<br />";
> echo $newdate = date("Y-m-d",strtotime($olddate));
> echo "<br />";
> echo $newdate2 = date("Y-m-d",strtotime($olddate2));
> echo "<br />";
> echo $newdate3 = date("Y-m-d",strtotime($olddate3));
>
> markb
You've given us no code you are actually using (we can all write dummy test code).
IMO, you need to either change your input form to give you the results in a certain way (split up the M,D,Y or only accept it in a specific format or any other way)
OR
You run the strpos and look for "/" "." or "-" or " " or "?" and then use the data on that field.
Wolf
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
