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 datetimeor timestamps? — Md. Abutaleb
– Md. Abutaleb, Commented May 24, 2017 at 4:33

JYoThI · Accepted Answer · 2017-05-24 04:57:33Z

1

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));

edited May 24, 2017 at 4:57

answered May 24, 2017 at 4:39

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CodeGodie · Accepted Answer · 2017-05-24 04:42:02Z

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, 2017 at 4:42

CodeGodie

12.2k6 gold badges40 silver badges66 bronze badges

7 Comments

JYoThI Over a year ago

Strtotime() doesn't work with dd/mm/YYYY format .i mean separated by slash format will not work .

CodeGodie Over a year ago

@JYoThI I disagree. strtotime('08/23/1994')works. What makes you think it does not?

JYoThI Over a year ago

can you try this example echo date('Y-m-d',strtotime('24/05/2017')); @CodeGodie

CodeGodie Over a year ago

@JYoThI That wont work as 24/05/2017 is incorrect. It should be 05/24/2017 as they originally need.

JYoThI Over a year ago

the how it will work for this format "dd/mm/yy" as you suggested

|

Saurabh Parekh · Accepted Answer · 2017-05-24 04:32:45Z

0

You have to try this

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

answered May 24, 2017 at 4:32

Saurabh Parekh

4491 gold badge3 silver badges11 bronze badges

Comments

Gulmuhammad Akbari · Accepted Answer · 2017-05-24 04:34:35Z

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, 2017 at 4:34

Gulmuhammad Akbari

2,0142 gold badges15 silver badges30 bronze badges

Comments

Raju · Accepted Answer · 2017-05-24 04:44:28Z

0

This might work

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

answered May 24, 2017 at 4:44

Raju

711 gold badge1 silver badge8 bronze badges

Comments

Ahmed Ginani · Accepted Answer · 2017-05-24 04:51:41Z

0

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

answered May 24, 2017 at 4:51

Ahmed Ginani

6,6452 gold badges17 silver badges33 bronze badges

Collectives™ on Stack Overflow

Datepicker dd/mm/yy php and mysql error

6 Answers 6

Comments

7 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

7 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related