[SOLVED] Current Date and Time into MySQL Field

[webref.eu]

The attachment shows the ReviewDate field in my MySQL database, which is a date and time field.  The format is: 

 

0000-00-00 00:00:00

 

Can someone give me the code to get the current date/time and insert it into the database in the format shown ... before I manage to Google it. 

 

Many thanks all.

 

[attachment deleted by admin]

[budimir]

We are here to help you with the problems, not to write the code for you.

 

Google it or try under Freelance forum.

[dezkit]

<?php
$date = date("Y-j-n H:i:s");
echo $date
?>

 

i think...

[dezkit]

is this what you want?

 

Year - Day - Month  Hour : Minute : Seconds

 

if yes, then my code is el correctumundo

[webref.eu]

Thanks for your help dezkit, your code is echoing the date and time for me which is great, however, I have to investigate which way round my database field is, it's probably: 

 

yyyy-mm-dd hh:mm:ss

 

but I have to confirm that.  My MySQL server is running on a US host so I just need to make sure the month and day are the way round in the database that I expect. 

 

Many thanks.

 

 

[dezkit]

<?php
$date = date("Y-n-j H:i:s");
echo $date
?>

[webref.eu]

OK, thanks for your help Dezkit, I went for a slight change on the Month and Day as I needed the leading zeros: 

 

//Y Year in four digits
//m Month 01 to 12
//d Day of the month 01 to 31
//H Hour 00 to 23
//i Minutes 00 to 59
//s Seconds 00 to 59
$DateAndTime=date("Y-m-d H:i:s");
echo $DateAndTime . "<br>";

 

Rgds