Jump to content

Archived

This topic is now archived and is closed to further replies.

dark dude

Assigning Sessions through MySQL

Recommended Posts

Ok, I know how to assign sessions, you get the information from the Form and assign it to the Session like:

$_POST['Username'] = $Username
$Username = $_SESSION['Username']

What I wanna know is how you take data from the database where the Session Username == The database username, and assign that to a session, if you get what I mean.

Share this post


Link to post
Share on other sites
Your code is a bit odd... Don't you mean:
$_SESSION['Username'] = $_POST['Username']
?

Anyway, if you want to retrieve data from the db, do as you would usually, but now with a variable. Like:

[code]$user = $_SESSION['Username'];
$query = "SELECT * FROM `users` WHERE username='$user'";
$result = mysql_query($query) or die(mysql_error());[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.