display current datetime

[Anon]

Tried to insert and display current date when my form is submited.

If I use belowed code:
<input type=hidden name=add_date value=date("Y-m-d h:i:s")>

the format to datetime is
0000-00-00 00:00:00

How could I get current time like
2002-06-04 ...?

Appreciate your input and suggestions.

[Anon]

you don't need to send this data as a hidden form varible. just create the variable on your form processing script:

$date_time = date ('Y-m-d h:i:s', time ());
echo $date_time;

[Anon]

But I want to input the datetime into my mysql table.

How I input current datetime into table?

thanks

[Anon]

<input type=hidden name=add_date value=<?php echo(date("Y-m-d h:i:s")); ?>>

if you are not using php to echo the html tags, but embed the php function into html tags, you should use it like above.

you have mentioned that hidden field could not be added to the database. it should not be the case, in the eyes of php, hidden fields values, text fields values should be the same.

the reason that hidden fields cause you problem is that the value/datatype of your hidden fields are not as you expected. such as if you are expecting a date type value, but when you submit it, value=date("Y-m-d h:i:s") will pass the string date("Y-m-d h:i:s") to a field expected a date, but if you use value=<?php echo(date("Y-m-d h:i:s")); ?>, you will pass a date value.

once again, i am assuming you are embeding the function date() into html tags.

hui

[Anon]

2 ways

1. pass the $date_time variable to your mysql_query (you may have to reformat it with date() depending on what kind of MySQL date/time field you have setup).

2. use MySQL's NOW() function. This would be the preferred option.

[Anon]

thanks. It works now. but I only show date, not datetime even though I used "datetime" as my field type in table.

also hidden value like date("Y-m-d h:i:s")

datetime display like 2002-06-05 00:00:00

any ideas?