Jump to content

Assigning Sessions through MySQL


dark dude

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.
Link to comment
https://forums.phpfreaks.com/topic/11658-assigning-sessions-through-mysql/
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]

Archived

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

×
×
  • Create New...

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.