Forum Moderators: coopster
I am currently working on a project that let's user's log into their home folder, which is private. From this home folder, they can access their public folder, which is accessible to anyone.
I would like for 'anybody' to be able to browse any of the user's profile, but I don't know how to retain all their information once they log off.
Here is the general process that takes place to give you a better idea:
1.) User enters username & password
2.) User's info is checked on database
-if user exists, user is taken to 'private page'
3.) User can access 'public page', but once user logs off, all the user
particular data is gone. (I am just inserting user's info with php
right now).
** This is where I don't know how to implement correctly. I would like for the user's unique information to remain even after the user logs off so that anybody can access any user's profile **
I thought about just querying the database and returning the user's public info and then referencing that data to the user's public page, but wouldn't that create some issues with efficiency later on as the # of users increases, since everytime somebody wants to lookup a user, a query to the database would have to be made.
All I need are suggestions on how to better implement this, so any helpful advice is welcome. Thanks.
I would like for 'anybody' to be able to browse any of the user's profile...
So the call to the database will be made when they enter there search criteria and hit the search button.
So allow your search to be narrowed down by offering choices.
Depending on what sort of site you are running would depend on what choices to offer. If you run a multinational site then you may be able to limit results even more by making people choose an area (Europe, US, Middle East, etc) then only offer results from that area.
So try to stop people entering search queries like "SELECT * FROM members;" as this will take a long time to return.
There are lots of good ideas about improving database performance on the web. However when you have a very large database there is always going to be a time issue when searching for all records...so try not to allow people to look through all records.
