RE: [PHP] username and password auth
| From: | Jay Blanchard | Date: | Thu, 17 Feb 2005 16:10:38 +0000 |
| Subject: | RE: [PHP] username and password auth | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208923@lists.php.net to get a copy of this message | ||
[snip]
What is the best or right way to compare users name and password given
in a
web form to data in mysql database?
I saw one example where sql SELECT query was made with username and
password
as WHERE and the script tested how many rows was returned from database
if
there was 1 row returned the login was accepted.
Is there other ways to do this? What if the usertable has more than
these 2
columns.
[/snip]
How familiar are you with database usage and SQL?