date

[janet24]

Is there any way you can use the date command to insert the current data in a database through a form?

 

[jpadie]

data is not inserted in a database through a form. but a query. forms submit data to a webserver.

you can use the date() function to prepare a date for submission in a query.

if you want to insert a unix time stamp, use

time();

if you want to insert a mysql-formatted datetime stamp, prepare the value for the query by using

date("Y-m-d H:i:s");

don't forget to allow for server time offsets.

 

[janet24]

You mean I can use a statement like this and put the date in a variable and into a query?

$date=date("Y-m-d H:i:s");

 

[jpadie]

yes.

or you can always do this directly in mysql. but that is outside the scope of the PHP forum.

 

[janet24]

I wonder if it's not working because I'm using bind_param. I'm not getting an error message, I'm just not getting anything so I'm not sure why it isn't working.

 

[jpadie]

paste your code?

 

[janet24]

I got it to work, something else was wrong not the date. Thanks for your help!