Writing to foreign keys

[taz321]

Hi

 

I am wanting a user to fill a few text fields and then click on submit for it to be saved to the database (MySQL)

 

The table which holds this data is called Person and the attributes are -

 

PersonID

Name

Age

Address

OrderID

FormID.

 

Now i know the personID automatically increments, but what about the foreign keys (Order & FormID), i need to put some sort of data in there otherwise it wont let me submit the form.

I cant have it the foreign Keys displayed on the forms because it won't make sense to the user.

 

Any Ideas?

 

Thanks

 

 

[trq]

I cant have it the foreign Keys displayed on the forms because it won't make sense to the user.

 

Sounds like your looking for hidden form fields.

[taz321]

Im using Dreamweaver and i have inputted something called Hidden Field onto my screen, but how do i use it so that data would go into the foriegn keys without obviously the user seeing them ?

 

Thanks

[trq]

An example.

 

<form method="post">
  <input type="hidden" name="test" value="foo">
  <input type="submit" name="submit">
</form>
<?php

  if (isset($_POST['submit'])) {
    echo "The hidden field 'test' was passed with a value of " . $_POST['test'];
  }

?>

[taz321]

Thanks, great

 

I will experiment with this.

[revraz]

Just be aware that even though it is a hidden input field, the user can still see it if they view the source.  You may want to use a session if you truely want to hide information.