new to MySql PHP - timestamp for date

Hi,
I have tried every combo I can think of to get a hidden form variable to pass
the timestamp into the MySQL table. I know I am getting the timestamp in php
because I print the value to the page during testing. But it uploads into the
MySQL database as 00/00/0000. Here is an example of the timestamp: 1088892113

In DW Server behavior I've tried associating the number with an interger and
date. In MySQL I've used timestamp, date, int.

Don't really care if it shows up in the database as the number or an actual
date and time combo. If I can even get the # into MySQL I should be able to
manipulate it back onto a page as just the date and/or time.

Code section for hidden field in form. I took the ?s out of the php code
below:

<php $time_now = time(); >
<label>
<input type="hidden" name="UserRegDate" id="UserRegDate" value="<= $time_now

"
php Print $time_now;

Thanks. Leesa

.oO(Leesa)

I have tried every combo I can think of to get a hidden form variable to pass
the timestamp into the MySQL table.

Why do you put it into a hidden field then? Doesn't make sense for me.
Why not use the MySQL function NOW() or CURDATE() on insert?

I know I am getting the timestamp in php
because I print the value to the page during testing. But it uploads into the
MySQL database as 00/00/0000. Here is an example of the timestamp: 1088892113

MySQL doesn't store timestamps by default (you would have to use an INT
field for this), it stores dates/time in ISO-format YYYY-MM-DD HH:MM:SS.

In DW Server behavior I've tried associating the number with an interger and
date. In MySQL I've used timestamp, date, int.

Fields of type TIMESTAMP are updated automatically whenever the record
is modified. I think DATE or DATETIME is what you need.

Don't really care if it shows up in the database as the number or an actual
date and time combo. If I can even get the # into MySQL I should be able to
manipulate it back onto a page as just the date and/or time.

Code section for hidden field in form. I took the ?s out of the php code
below:

php $time_now = time();

Try

<?php $time_now = date('Y-m-d H:i:s');?>

or

<?php $time_now = strftime('%Y-%m-%d %T', time());?>

HTH
Micha

Thanks! That's just what I needed. I've been searching the web and found this
article that helped explain it too.
http://www.phpfreaks.com/mysqlmanual/page/manual_Reference.html#DATETIME

Just starting to play with PHP/MySql. Little bit different from ASP.

Appreciate your help. Leesa

On 03 Jul 2004 in macromedia.dreamweaver, Leesa wrote:

Just starting to play with PHP/MySql. Little bit different from ASP.

You'll find a *lot* of help straight from the source:

http://www.php.net/

The online manual generally has a clear, to the point explanation of what
you're looking for.

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/email.php

.oO(Leesa)

Just starting to play with PHP/MySql. Little bit different from ASP.

It's a good idea to have the manuals available as local copies, you
should download them:

http://www.php.net/download-docs.php
http://dev.mysql.com/doc/

Also have a look at the online versions from time to time because of the
user contributed notes.

Appreciate your help. Leesa

You're welcome.

Micha