Page 1 of 1

In a session, how a usr get their database info?

Posted: Thu Jul 17, 2003 10:08 pm
by towline_5
Once someone has logged in through my authentication site and a session has been started, how can I show them all their data (e.g. an ability to see their past transactions and their user info)? :oops:

Posted: Fri Jul 18, 2003 3:04 am
by twigletmac
You need to have some way of linking all of the information about the user - do they have a user id that you can use to query the database to grab all of their information?

Mac

Posted: Fri Jul 18, 2003 6:55 am
by towline_5
Yes, theoretically they have already created user names and passwords.

Posted: Fri Jul 18, 2003 7:14 am
by twigletmac
You need to have some way of linking the username information with the other data stored about them - e.g. having an auto-incrementing ID field in the users table which is used as a foreign key in the transactions table.

Mac

Posted: Fri Jul 18, 2003 4:36 pm
by towline_5
Thank you. I'll try that.