username and password auth
| From: | William Stokes | Date: | Thu, 17 Feb 2005 16:06:37 +0000 |
| Subject: | username and password auth | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-208922@lists.php.net to get a copy of this message | ||
Hello,
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.
Thanks
-Will