Page 1 of 1

Login --> Session --> Linked Tables

Posted: Mon Jan 20, 2003 4:37 am
by n00b
ok, heres the scenario:

Person enters mainpage, the data on the page has universal links and text, because it doesnt know that this person is a member. The person then fills in login form --> Sends to check_user.php --> check_user.php then gets the information from members table in my database, and registers 3 variables into the users session:

username
password
first_name

check_user.php then redirects person back to the mainpage --> mainpage now contains data for a registered user as it sees the person is a member.


Just recently i've been trying to add new feature called bookmarks.

Bookmarks uses a separate table called: bookmarks (coincidently)

now, when the user fills in the form, i want check_user.php to check to see whether the person is a member, then extract all the users information from the table members and also all the rows from the bookmarks table where the username from "members" = the username from "bookmarks".

How would i go about adding this, and then displaying it on the mainpage?

thanks.

Posted: Mon Jan 20, 2003 7:13 am
by n00b
No matter, all sorted...