Dropdown login

[itgranny]

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!

[Psycho]

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?

[QuickOldCar]

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()