how to display date from database to input type=date in php

Question

i have a field from my database which is start/end date sample fields is

sample field

start_date   |   end_date
2017-04-19   |   2017-04-23

what i want to do is to display this data to my:

<input type="date" name= "start_date" value="<?php echo $value['start_date']?>">

but what happen is it doesn't display anything... i tried to use

<input type="date" name= "start_date" value="<?php echo date('Y-m-d',strtotime($value["start_date"]))?>">

but it displays a different date which is not from my database.. any suggestion to display the date data from my db to the input type="date" ??

woah nice... its working now...thanks for this... but im a bit confuse with the two between date('Y-m-d') and strftime('%Y-%m-%d') .. but thanks alot. — Lion Smith
– Lion Smith, Commented Apr 19, 2017 at 9:17
Possible duplicate of how to get date from database to html datepicker — SaschaM78
– SaschaM78, Commented Mar 1, 2018 at 13:03

Bibhudatta Sahoo · Accepted Answer · 2017-07-20 12:14:55Z

4

strtotime is use to format a local time/date according to locale settings
Try like this:-

<input type="date" class="m-wrap" value="<?php echo strftime('%Y-%m-%d',
  strtotime($value['start_date'])); ?>" name="date" />

It will work for you .TO check about strtotime look this

answered Jul 20, 2017 at 12:14

Bibhudatta Sahoo

4,9142 gold badges31 silver badges53 bronze badges

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

2 Comments

How to check if date is not set in database? In some records, I have NULL values

Hi @AjinkyaRathod, In this situation, you can check the time and if not present then you can set the current date (i.e echo date("Y-m-d")) .