Jump to content


Photo

Assigning Sessions through MySQL


  • Please log in to reply
1 reply to this topic

#1 dark dude

dark dude
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts

Posted 10 June 2006 - 03:31 PM

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.

#2 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 10 June 2006 - 03:47 PM

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:

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

~ D Kuang




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users