mysql data loads once user login

Am not looking for code or examples just advice!!! I desire to load a users data from a database once they successfully login to my website.

How shall i manage this?? Possibly use a cookie?? Or maybe session??

Here is the setup, a user logs in & is directed to a page that is setup to display there data from the mysql database!! Any answers or advice would be great!!!

I have managed this before with Rakuli's great help & it does work but has a few problems...

Please help!

Thanks.

Sessions would be the best option.
Make sure it's secure though.
I will find a great article for you in a minute, it has tips for securing sessions.

Hey Alex, how you bin???

Long time no hear mate

Thanks for the repley!!! Sessions it is then... Look forward to the article!!!

You still eating kebabs

Either way works great. You can give them a choice about whether or not to set a permanent cookie and bypass the login screen.

Thanks mate!!

Recently i succesfully created my edit accounts page with file upload!!! When the user is logged in there data automatically appears in the edit account page ussing this code:

PHP: Select all

// check if session exists and assing it to a variable
if (!isset($_SESSION)) {
 session_start();
}
// we can populate the session MM_Username because it is a unique identifier
if (isset($_SESSION['MM_Username'])) {
 $username = $_SESSION['MM_Username'];
} 

It does not seem to work for me when on my profile page, the user data is not automatically loaded into the profile even with the session code above... Is there any specific reason for this??

Well I can't find the exact one because I don't have time, but here's one and there's plenty of other stuff on sessions on that blog, it's pretty good!
And yes, I love a good kebab

What do you have stored in the session?

The exclamation mark has never felt so needed as in your posts Longstand!

The reason that your user data isn't loading up when you store it in the session is the way that you have the accounts.php set up. When you go to accounts.php it is expecting the query string to be something like accounts.php?id=1... it needs you to send the $_GET variable so the script can load up the passed ID.

If you are storing thne user's ID in the session, you need to attach ?id=[userIdHere] for any link you have to the profile page.

Either that, or, within the accounts.php page, have it use the stored session ID if the $_GET variable is not set.

Thanks guys!!! I will try that.. That code you done for me Rakuli worked the last time you helped, and did solve the problem but i kepy getting error messages saying i had two user login sessions set up....


So i had to try and change it.. Al try out that: ?id=[userIdHere !! And try and solve the problem!!!

Thanks for the help... Am sure i will solve the today