Changing form date to MySQL date to insert into database

[AdRock]

I have a form where my admin user has to enter a date of an event.

He has entered the date in a UK format such as 25/11/07 but i need to convert into a SQL date so i can insert it into my MySQL database

How do i convert the date as it reads something really random when i display the date on the page

[emehrkay]

list($day, $month, $year) = explode('/', $date);
$sqlDate = $year .'-'. $month .'-'. $day .' 00:00:00';

[paul2463]

would this not work too?
[code]
<?php
$sqlDate = date("Y-m-d", strtotime(inputDate));
?>
[/code]

[ShogunWarrior]

It should, but I've always been suspicous of how exactly strtotime can know if your date string is "dd/mm/yy" or "mm/dd/yy". In this example "25/11" is obvious but I'm not sure about "11/11" ?

[AdRock]

On my form I have a text filed called txtEvent

Here is the code I use to create the $event variable

[code]$event = $_POST['txtEvent'];[/code]

and this is the code to coonvert the date to SQl format

[code]$EventDate = date('Y/m/d', strtotime($event));[/code]

When i echo $EventDate it is screwing the date right up somehting like 12/04/2031

[AdRock]

I have just tried messing around with this to try and convert a date but it is still not working properly

I put in 21/9/2006 and it returns 2007/09/09

[code]<?php
$event = $_POST['txtEvent'];
if (!isset($_POST['txtEvent'])) {
?>
<h2>Add a forthcoming event</h2>
<form method="post" action="<?php echo $_SERVER['REQUEST_URI']; ?>">
    <p>Please enter a date for the event.
    <input id="calendar" class="form" type="text" title="Please enter the event date" size="30" name="txtEvent"></p>
  <p>
    <input type="Submit" value="Submit"><input type="reset" value="Reset">
</form>

<?php
}
else
{
$event  = str_replace("-","/",$event);
$date = date('Y/m/d', strtotime($event));
echo $date;
}
?>[/code]

[paul2463]

try breaking the strtotime out
[code]
<?php
}
else
{
$event  = str_replace("-","/",$event);
$changedEvent = strtotime($event);
$date = date('Y/m/d', $changedEvent );
echo $date;
}
[/code]
?>