Questions about creating accounts on a database
Posted: Wed Jun 26, 2002 3:24 pm
Hey, everyone.
I apologize in advance if this has been covered already. I tried searching the forums, and looking on Google, but nothing insightful popped up.
I've been working on a website and decided to incorporate some mySQL/PHP goodness. I plan to make a place where users can update their personal info via html forms. The information is displayed by PHP for the public to access.
For this I'm thinking of making a "users" table with the following columns:
id, name, password, etc. When they log in, their submitted password is checked against the one in the database and entry is permitted or denied based on the comparison.
From here I'm uncertain. Do I change a variable to toggle if the user is logged in? How would I only give access to that user for modifying his info? How can I make sure that only that computer is able to get any data? Are PHP and mySQL the right tools for ensuring security here?
If someone could point me in the right direction, or direct me to a tutorial that might answer my questions, it would be most appreciated.
I apologize in advance if this has been covered already. I tried searching the forums, and looking on Google, but nothing insightful popped up.
I've been working on a website and decided to incorporate some mySQL/PHP goodness. I plan to make a place where users can update their personal info via html forms. The information is displayed by PHP for the public to access.
For this I'm thinking of making a "users" table with the following columns:
id, name, password, etc. When they log in, their submitted password is checked against the one in the database and entry is permitted or denied based on the comparison.
From here I'm uncertain. Do I change a variable to toggle if the user is logged in? How would I only give access to that user for modifying his info? How can I make sure that only that computer is able to get any data? Are PHP and mySQL the right tools for ensuring security here?
If someone could point me in the right direction, or direct me to a tutorial that might answer my questions, it would be most appreciated.