Create Session variables out of everything in a mysql table

Scenario: Your making a website that uses user logins. Pretty common. When the user logs in you want to store all their mysql data in session variables so that while they are logged in you can access things like their email, products, names, address and anything else you put in the user table of your database. You could pick and choose which rows of mysql you wish to turn into Session variables and hard code them in. But with the foreach loop and some trickery we are able to turn everything from the user table about a particular user into session data.

Category:

Science & Technology

Tags:

• session
• php
• mysql
• foreach
• loop
• data
• login
• user
• account
• variable
• database
• learn
• program
• tutorial
• video
• sean
• optikalefx

[Jamieduk999]

can you help with this syntax error i made this script but not displaying the data from the database

[optikalefxx]

@Jamieduk999 sure send me some code

[cheatonly2win]

Even a better way, use mysql_fetch_assoc instead of mysql_fetch_array

[loperaja]

Thanks!! I was looking for related info and your tutorial was very useful

[Timzy921]

thanks this helped alot