close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to add Timestamp from Hidden Field

Thread began 3/17/2011 12:56 pm by Mike Perry | Last modified 5/13/2011 2:23 pm by A Sound Design | 6663 views | 8 replies |

Mike Perry

How to add Timestamp from Hidden Field

I have created an Insert Record form using DA. There are four fields -- three text fields (e-Mail, First_Name and Last_Name) and a hidden field (reg_Date). All the corresponding columns in the db are not_null. When I run the form I get the error "Incorrect integer value: '' for column 'reg_Date' at row 1" -- this is (I presume) because there is no value currently assigned to the hidden reg_Date field. The Insert function obviously fails.

The reg_Date column is data-typed to int (I planned on using the Unix timestamp). What code do I place (presumably in the hidden reg_Date field) to pass the correct value to the Insert code??

Thanks,

Mike

Sign in to reply to this post

Jason ByrnesWebAssist

set the value of the hidden field to:
<?php echo time(); ?>

Sign in to reply to this post

Mike Perry

That was too easy. . .

:)

Thanks, Jason. . .

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

A Sound Design

I'm trying to get this to work following the thread here. I have put <input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo time(); ?>" /> into my form. The SQl is

`Date Added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

Yet it still adds the date as 0000-00-00 00:00:00 in the Date Added column.

Sign in to reply to this post

Jason ByrnesWebAssist

a datetime field in MySQL expects the date to be passed as yyyy-mm-dd hh:mm:ss, not a time stamp.

change the value of the form element to:
<?php echo date("Y-m-d h:m:s"); ?>

Sign in to reply to this post

A Sound Design

Originally Said By: Jason Byrnes
  a datetime field in MySQL expects the date to be passed as yyyy-mm-dd hh:mm:ss, not a time stamp.

change the value of the form element to:
<?php echo date("Y-m-d h:m:s"); ?>  



So should it be

$WA_fieldNamesStr = "RegionName|IntroText|Content|Photo|Title|Price|DateAdded";
$WA_fieldValuesStr = "".((isset($_POST["Region"]))?$_POST["Region"]:"") ."" . "|" . "".((isset($_POST["IntroText"]))?$_POST["IntroText"]:"") ."" . "|" . "".((isset($_POST["Content"]))?$_POST["Content"]:"") ."" . "|" . "".((isset($_FILES["Photo"]))?$_FILES["Photo"]["name"]:"") ."" . "|" . "".((isset($_POST["Title"]))?$_POST["Title"]:"") ."" . "|" . "".((isset($_POST["Price"]))?$_POST["Price"]:"") ."" . "|" . "".((isset($_POST["<?php echo date("Y-m-d h:m:s"); ?>"]))?$_POST["<?php echo date("Y-m-d h:m:s"); ?>"]:"") ."";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|none,none,NULL|',none,NULL";

Sign in to reply to this post

Jason ByrnesWebAssist

change:
<input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo time(); ?>" />

to:
<input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo date("Y-m-d h:m:s"); ?> " />

Sign in to reply to this post

A Sound Design

Awesome! Sorry for being so dumb earlier. I think I was just tired and hungry :o.

Would like to know how to display that date on a page in format Day - Month Year. At present I have <?php echo $row_DetailRS1['DateAdded']; ?> Not sure how this works.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...