change date format Datepicker

Please can you tell me how to change the format. Whatever I do with Datepicker - it captures in the format YYYY / MM / DD

It is a UK site and they want it captured to the MySQL in DD/MM/YYYY

Please can you tell me how to achieve this ?

URL is http://www.mottesthighwycombe.co.uk/bookmot.php

John

the database cannot store the date in that format.

it must store the date in the yyyy-mm-dd format.

you change the format that is used to display the date on the individual pages using the date function though.

so instead of using:

<php echo $row_recordsetName['dateColumn']; ?>

to write the date to the page, use:
<php echo(date("d/m/Y", strtotime($row_recordsetName['dateColumn']))); ?>

Hi Jason and thanks for your e mail

Problem is when somebody SELECTS the date from the datepickers on the form - it puts it on the form in YYYY MM DD onto the form
and this is where I Want it to view DDMMYYYY

I have searched for the code you gave me to replace in the source code on the form page - but dreamweaver cannot find this code ?

Please advise

send a copy of the page please.

Attached thanks Jason

theres no spry, so the format only needs to be changed for the date picker.

find this line:

dateFormat:"yy-mm-dd"

to change the format:
dateFormat:"dd-mm-yy"


but remember, the date that gets inserted to the database must be in the yyyy-mm-dd format, so code will need to be added to change the format that is passed. the code will be similar to this:

<?php
if(isset($_POST['dateField'])) $_POST['dateField'] = date("Y-m-d", strtotime($_POST['dateField']));
?>

Hi Jason

Great now works perfectly on the page - you select date which is shown in UK format eg 15/11/2013

Added the PHP code you gave me to switch the date to YYYYMMDD

It now inputs all dates as 01/1/1970

MySQL field is set as DATE

Page attached again - have I done something wrong ?

John

I dont see the php code for changing the date format back to Y-m-d on your page.

add the following code at line 1:
<?php
if(isset($_POST['PreferredDate'])) $_POST['PreferredDate'] = date("Y-m-d", strtotime($_POST['PreferredDate']));
?>

Thanks Jason

Added your code twice ( once for each datepicker ) and perfect. Now logs properly on page and into MySQL

<?php
if(isset($_POST['PreferredDate'])) $_POST['PreferredDate'] = date("Y-m-d", strtotime($_POST['PreferredDate']));
?>
<?php
if(isset($_POST['PreferredDate'])) $_POST['MotExpiry'] = date("Y-m-d", strtotime($_POST['MotExpiry']));
?>


Only remaining problem is e mail form sent shows wrong way. DO I embed the same code into the
page waue_bookmot_3.php or into the form sent by UEMail ( Blank_4.php ) please

Kind regards and thank you for your help

John

add code to the email template file Blank_4.php to change the date format back:

<?php
if(isset($_POST['PreferredDate'])) $_POST['PreferredDate'] = date("d-m-Y", strtotime($_POST['PreferredDate']));
?>
<?php
if(isset($_POST['PreferredDate'])) $_POST['MotExpiry'] = date("d-m-Y", strtotime($_POST['MotExpiry']));
?>