itgranny Posted June 2, 2015 Share Posted June 2, 2015 Unfortunately my ideas out pace my skills.I have a database that I would like certain people to access their own info, but nobody else's. It's not super sensitive info and won't mean much to anyone other than the end user but we don't like the idea of others accessing it so we'd like to put some protection on it.What I was hoping for is a dropdown list (there's about 30 or so clients that would be in a mysql table) where they can pick out their name, then text box for the password. When they hit submit button it would lead them to their own page with a table and their own info from a mysql table. I can get each one of these details to work separately, but I'm having trouble putting them all together (the password is where things get muddled). Can anyone point me to a place where they've already figured this out? Thanks! Quote Link to comment Share on other sites More sharing options...
Psycho Posted June 2, 2015 Share Posted June 2, 2015 I don't see that this is any different from a site that uses a normal username/password authentication process. The fact that the username is a populated select list of values as opposed to a free-form text field does not require any differences in functionality (except to run a query to populate the select list). You say "the password is where things get muddled". Don't have any clue what that means. What, specifically, are you having an issue with? Quote Link to comment Share on other sites More sharing options...
QuickOldCar Posted June 2, 2015 Share Posted June 2, 2015 Listing the username is helping hackers with half the battle, I would have them insert the username and password. Having passwords hashed in the database is what you want. Look into password_hash() and password_verify() Quote Link to comment 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.