Jump to content

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.