PHP: convert date to datetime and insert it into mysql database?

Question

I have an input field in my html page that gets Date from jQuery datepicker.

The format looks like this:

18/02/2017

I have a MYSQL field which is DATETIME

I need to insert the Date above into this MYSQL field.

So i tried this code:

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

but the result of $mysqlDate is this:

1970-01-01 01:00:00

Could someone please advise on this issue?

Thanks in advance.

date("Y-m-d", strtotime($your_date) and try, I means remove his — Rahul
– Rahul, Commented Feb 18, 2017 at 13:15

Rahul · Accepted Answer · 2017-02-18 13:31:22Z

2

Do one thing,

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

Give it a try,

it should work.

Note: Dates in the 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. If, however, the year is given in a two digit format and the separator is a dash (-, the date string is parsed as y-m-d.

Source link.

Your new concern answer,

$mysqlDate = date('Y-m-d H:i:s', strtotime(str_replace("/","-",$_POST['php_date']).' + '.rand(30,60*60*24*3).' seconds'));

edited Feb 18, 2017 at 13:31

answered Feb 18, 2017 at 13:17

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

6 Comments

David Hope Over a year ago

nice one... that did the trick. is there any way to add a random hour and minute to the $mysqlDate ?

Rahul Over a year ago

Mate, your concern has been solved, as for question. Create new question regarding your this new problem , I assure you I will be there too. :)

Rahul Over a year ago

Thanks ! If my answer solved your problem, you can accept my answer. Thanks again :)

David Hope Over a year ago

will do.. its saying I need to wait for 2 minutes before I can accept it... :)

Rahul Over a year ago

my heart not accepting this, check edit section of answer for your new concern. Thanks

|

Funk Forty Niner · Accepted Answer · 2017-02-18 13:34:37Z

2

You have to convert the posted date to a

YYYY-MM-DD

Format before converting it into date time.

You can do

$date=$_POST['php_date'];
list($day,$month,$year)=explode('/', $date);
$date=$year.'-'.$month.'-'.$day;

And then use $date.

edited Feb 18, 2017 at 13:34

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Feb 18, 2017 at 13:21

user2399035

2 Comments

Funk Forty Niner Over a year ago

si ricorda, the delimiter comes "primo" with explode() ;-) I fixed that. Otherwise, they'd be a conversion to string error.

user2399035 Over a year ago

Thanks mate! Didn't notice the mistake! :)

Collectives™ on Stack Overflow

PHP: convert date to datetime and insert it into mysql database?

2 Answers 2

6 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related