Login --> Session --> Linked Tables
Posted: Mon Jan 20, 2003 4:37 am
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.
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.