html输入类型datetime-local到datetime sql使用php

Question

I have this object created in my web page.

input type="datetime-local" name="datentime" size="15" style="height:30px; font-size:18px" placeholder="

Now I need to retrieve the value and put it into my mysql database. I tried a lot but couldn't insert value to database. my php code is given below.

$event_dnt = strtotime($_POST["datentime"]);

database store as YYYY-MM-DD HH:MM:SS

Answer 1

Convert date from dd/mm/yyyy h:i (Default for input type datetime-local format) to Y-m-d H:i:s (Mysql format) to save in database, use code following:

date("Y-m-d H:i:s", strtotime($_POST["datentime"]))