Datepicker dd/mm/yy php and mysql error

Question

I have a problem with this code, when I try to use the dateformat dd/mm/yy it saves 1970/01/01 but when I use mm/dd/yy it works, I really dont know why here is the code I'm using:

HTML

<input type="text" name="dateStart" class="datepicker">

JS

$( ".datepicker" ).datepicker({ dateFormat: "mm/dd/yy" }); (Works)
$( ".datepicker" ).datepicker({ dateFormat: "dd/mm/yy" }); (Does not)

PHP

$date = isset($_POST['dateStart'])?date("Y-m-d H:i:s",strtotime($_POST['dateStart']));

And the mysql column is a date field.

Any help would be appreciated.

UPDATE

-It´s a mysql datetime field

Can you please let us know what is your table field type? i mean is it `date` or `datetime`or `timestamps`? — Md. Abutaleb, May 24 '17 at 04:33

JYoThI · Accepted Answer · 2017-05-24T04:57:33.583

1) You can show convenient Format to user end But when you store it in database Mysql date Format should be 2017-05-24 'YYYY-MM-DD'

JS

$( ".datepicker" ).datepicker({ dateFormat: "dd/mm/yy" });

2) And strtotime will not accept this date format 24/05/2017 seperated by slash so use string replace. and then change the format like this

PHP

$date = str_replace('/', '-', $_POST['dateStart']);
$date = date('Y-m-d', strtotime($date));

score 1 · Answer 2 · answered May 24 '17 at 04:42

1

You can use datepicker to show your users date in the desired format as you already have:

<form>
   <input type="text" name="dateStart" class="datepicker">
</form>
<script>
  $(".datepicker").datepicker({ dateFormat: "dd/mm/yy" });
</script>

Then when you submit to PHP, you convert it so that you can store it correctly in the database:

<?php 

$date = $_POST['dateStart'];
$date_for_database = date('Y-m-d', strtotime($date));
var_dump($date_for_database);

answered May 24 '17 at 04:42

CodeGodie

12,116
6
37
66

Strtotime() doesn't work with dd/mm/YYYY format .i mean separated by slash format will not work . – JYoThI May 24 '17 at 04:55
@JYoThI I disagree. `strtotime('08/23/1994')`works. What makes you think it does not? – CodeGodie May 24 '17 at 04:59
can you try this example echo date('Y-m-d',strtotime('24/05/2017')); @CodeGodie – JYoThI May 24 '17 at 05:02
@JYoThI That wont work as `24/05/2017` is incorrect. It should be `05/24/2017` as they originally need. – CodeGodie May 24 '17 at 05:04
the how it will work for this format "dd/mm/yy" as you suggested – JYoThI May 24 '17 at 05:07
same way `date('Y-m-d', strtotime('05/24/17'));` – CodeGodie May 24 '17 at 05:08
dd/mm/yy" will give this format of date '05/24/17' ? – JYoThI May 24 '17 at 05:10

score 0 · Answer 3 · answered May 24 '17 at 04:32

0

You have to try this

$date = str_replace('/', '-', $_POST['dateStart']);
$date = date('Y-m-d H:i:s', strtotime($date));

answered May 24 '17 at 04:32

Saurabh Parekh

441
1
3
11

score 0 · Answer 4 · answered May 24 '17 at 04:34

0

No need to reformat the date just post like what you want to save.

//mysql standard date format is: year-month-day
$( ".datepicker" ).datepicker({ dateFormat: "yy-mm-dd" });

answered May 24 '17 at 04:34

Gulmuhammad Akbari

1,986
2
13
28

score 0 · Answer 5 · answered May 24 '17 at 04:44

0

This might work

$date = isset($_POST['dateStart'])?date("m j Y",strtotime($_POST['dateStart']));

answered May 24 '17 at 04:44

Raju

51
1
1
8

score 0 · Answer 6 · answered May 24 '17 at 04:51

Read Stortime manual.

Note:

m/d/y or d-m-y formats are disambiguated by looking at the separator between the various components: if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed.

$date = str_replace('/', '-', $_POST['dateStart']);
echo date('Y-m-d', strtotime($date));

Strtotime() doesn't work with dd/mm/YYYY format

Datepicker dd/mm/yy php and mysql error

6 Answers6