dark dude Posted June 10, 2006 Share Posted June 10, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/11658-assigning-sessions-through-mysql/ Share on other sites More sharing options...
poirot Posted June 10, 2006 Share Posted June 10, 2006 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] Quote Link to comment https://forums.phpfreaks.com/topic/11658-assigning-sessions-through-mysql/#findComment-44025 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.