Question 41060 in PHP Question posted in
Official manual can be found here.

How to make $date show on input type="date" – PHP

All the "date" in my database are of the following format: ‘d-m-Y’ (E.g. 09-03-2022)

I want have a field with input type=date, so user can modify the date.

I use the following code to pull data:

$date      = "<input type="date" id="date" size= "50%;" name="date" value="$resJanuary 3, 2023" >";

...
<thead> <th>Date </th> <td>$date </td> </thead>

But my inputbox is showing dd/mm/yyyy instead of the actual date.

enter image description here

What formatting do I need to do to make my actual date show on the inputbox?

I have tried the following but doesn’t work:

$date      = "<input type="date" id="date" size= "50%;" name="date" value="date('d-m-Y',$resJanuary 3, 2023)" >";
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    So I believe the reason why the date is not displaying on my input field is becuz it is in String datatype and need to format to DATE.

    $date1  =   date_create("$res[date]");
$date2  =   date_format($date1,"Y-m-d");
$date   = "<input type="date" id="date" size= "50%;" name="date" value="$date2" >";

    With this, I can also do the same for TIME

    $time1  =   date_create("$res[time]");
$time2  =   date_format($time,"H:i:s");
$time   = "<input type="time" id="time" size= "50%;" name="time" value="$time2" >";

  2. 0

    You are passing a wrong format to your date input.
    Date input must fill with RFC3339 formatted text, you can read more about it.

    To change your current format to Y-m-d format, you can use below code:

    DateTime::createFromFormat('d-m-Y', $dateInput)->format('Y-m-d');

    If you are using MySQL, it uses YYYY-MM-DD format for date type column, so, saving the date with Y-m-d from PHP to MySQL date field seems to be the correct way.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search