How to place MySql DATETIME results into HTML input with type datetime-local

Question

i stored date using <input type="datetime-local"> in the database now i want to get back the date in <input type="datetime-local"> for update purpose.

i am doing

$query="select * from exam_schedule where subject_name='$name' AND class_id='$schedule_id' limit 1";
$result= mysqli_query($connection,$query);
while ($read_all_data = mysqli_fetch_assoc($result))
{ 

echo "date comming from datebase::".$date=$read_all_data['date_and_time']."<br>";
echo "duration comming from datebase::".$duration=$read_all_data['duration'];

$duration=$read_all_data['duration'];
echo "<form method='post' action='edit_schedule.php'>";
echo "<input type='hidden' name='id' value='$id'>";
echo  "<tr><th><input type='datetime-local' name='date' value='$date'> </th>";
echo  "<th><input type='datetime-local' name='duration' value='$duration'> </th>";
echo <input type='submit' name='update' value='update'> </form></th></tr>";
}

when i echo the $date and $duration it shows me values but when i put value="$date" it doesnot show me date from database.

what's "updation" supposed to represent? english.stackexchange.com/questions/68169/… — Funk Forty Niner
– Funk Forty Niner, Commented Oct 8, 2015 at 15:19
id type =INT date_and_time type=DATETIME duration type =DATETIME — eexam ilm
– eexam ilm, Commented Oct 8, 2015 at 15:20
you have a syntax error here echo "<th><input type='datetime-local' name='duration' value='$duration'> </th>"; <input type='submit' name='update' value='update'> </form></th></tr>"; and error reporting would've told you that. Missing an echo ". — Funk Forty Niner
– Funk Forty Niner, Commented Oct 8, 2015 at 15:22

CodeGodie · Accepted Answer · 2015-10-08 16:41:50Z

7

The problem is that the datetime-local input type expects the date to be in this format: yyyy-mm-ddThh:mm but you are supplying it the default DATETIME format created by the database which is yyyy-mm-dd hh:mm:ss.

Demo

In order to change it, you need to change your SQL query to this:

SELECT *, DATE_FORMAT(date_and_time, '%Y-%m-%dT%H:%i') AS custom_date 
FROM exam_schedule 
WHERE subject_name='$name' 
AND class_id='$schedule_id' 
LMIT 1

so now in your results, you can then use the custom_date to prefill your input.

<input type='datetime-local' name='date' value='<?php echo $row['custom_date'] ?>' >

edited Oct 8, 2015 at 16:41

answered Oct 8, 2015 at 16:10

CodeGodie

12.2k6 gold badges40 silver badges66 bronze badges

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

Comments

OXiGEN · Accepted Answer · 2020-02-10 16:12:01Z

3

If you need to convert the time in PHP instead of MySQL:

Convert the MySQL datetime string into a PHP timestamp
Apply a PHP date format mask to the PHP timestamp, where the format matches the HTML5 datetime-local format

PHP code sample:

const HTML_DATETIME_LOCAL = 'Y-m-d\TH:i'; //escape the literal T so it is not expanded to a timezone code
$php_timestamp = strtotime($mysql_date_string);
$html_datetime_string = date(HTML_DATETIME_LOCAL, $php_timestamp);
echo "<input type='datetime-local' name='date' value='{$html_datetime_string}'>";

edited Feb 10, 2020 at 16:12

answered Feb 10, 2019 at 23:50

OXiGEN

2,41929 silver badges22 bronze badges

2 Comments

kCODINGeroo Over a year ago

This is not working for me: it is not showing in the input.

OXiGEN Over a year ago

Updated. Thanks. Fixed $ for variable in string.

Nihar desai · Accepted Answer · 2021-04-27 10:53:21Z

-1

Use This

 <?php  echo date('Y-m-d\TH:i:s', strtotime($exampledate));?>

answered Apr 27, 2021 at 10:53

Nihar desai

11 bronze badge

Comments

Dinanath Thakur · Accepted Answer · 2015-10-08 15:44:05Z

-2

You can use this one:

date_format($date, 'Y-m-d H:i:s');

answered Oct 8, 2015 at 15:44

Dinanath Thakur

6864 silver badges9 bronze badges

2 Comments

CodeGodie Over a year ago

where can he use this code, why would they use this code, and how will it solve the problem?

Dinanath Thakur Over a year ago

it will format the date as 2013-03-15 00:00:00. Wherever you want date format like this, you can use.

Collectives™ on Stack Overflow

How to place MySql DATETIME results into HTML input with type datetime-local

4 Answers 4

Comments

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related