Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data from one table to another

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I am trying to get a member id numbers from one table to go into another table when they submit a form. If anybody has any suggestions it would really help.
 
Hello guest256!

What tables do you mean? Data base's or HTML's tables?
I'll think you're talking about DB table.

There are number of ways how you can do this and noone is perfect:

1) store ID value in a Session variable.
+ it's the safest way - noone can access this value accept your application;
- Session object is available only if user's cookeis are enabled.

2) store in client's cookies (works similar to Session but Session is preferable):
+ basicly it can be accessed only from your server (but it's not an absolute seccurity);
- cookies can be disabled.

3) store it in hidden field of FORM in your HTML page:
<input type=&quot;hidden&quot; value=&quot;userID&quot;>
+ it works always;
- it can be accessed by unauthorised persons just by simply viewing source code;

4) pass it via URL (often securely encoded):


So you see that there are different ways to pass userID and noone is perfect. Some people combnine these ways.
I use Session object to keep userID and when cookies are disabled encode it and pass via URL or hidden field.

Good Luck!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top