assign date from mysql table to input date field

Question

In mysql table date is stored in yyyy-mm-dd hh:mm:ss format

I want to show on php form in format of dd/mm/yyyy input field type date

I tried following code ... not working

$pddt = date_format( date_create($row['invdt']), 'd/m/Y' );

Sadikhasan · Accepted Answer · 2015-02-10 12:56:42Z

1

You have to use date() function with PHP strtotime() function.

$pddt = date("d/m/Y",strtotime($row['invdt']));

answered Feb 10, 2015 at 12:56

Sadikhasan

18.6k23 gold badges85 silver badges126 bronze badges

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

2 Comments

Sanjay Over a year ago

still not working for code <td align="left"><input type="date" maxlength="10" size="10" name="txtddt" value="<?php echo $pddt; ?>"/>, but worked for code <td align="left"><input type="text" maxlength="10" size="10" name="txtddt" value="<?php echo $pddt; ?>"/> .. I want to get proper date, if invalid message

Sadikhasan Over a year ago

Where it is not working? Put your code in question where date is not working

Collectives™ on Stack Overflow

assign date from mysql table to input date field

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related