I have learned how to connect, now I would like the user to be able to login to a certain webpage. Say coming from a page called login.htm, the form submits to a login.php page which checks the MySQL database, checks to see if the username and password are valid, then redirects to the appropriate page. anybody know where there is some code on this or have any suggestions? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
know how to connect, now what?
- Thread starter rmccoy
- Start date
This is how I would do it in PHP:
Connect to the dbase
Check the username and password
If all correct, print the html refresh tag that redirects the user to a page within 0 seconds.
<?
mysql_connect("host","username","password"
;
//connecting to the database host
$result = mysql_query("dbase","SELECT * FROM table WHERE
username='$username' AND password='$password'"
//immediately checks the username & password
if($login = mysql_fetch_array($result))
//if any resultset was returned, meaning username & password were correct
print("<meta http-equiv='refresh' content='0;URL=newPage.htm'>"
//This redirects the user to the newPage.htm
else
print("wrong login"
?>
Connect to the dbase
Check the username and password
If all correct, print the html refresh tag that redirects the user to a page within 0 seconds.
<?
mysql_connect("host","username","password"
;//connecting to the database host
$result = mysql_query("dbase","SELECT * FROM table WHERE
username='$username' AND password='$password'"
;//immediately checks the username & password
if($login = mysql_fetch_array($result))
//if any resultset was returned, meaning username & password were correct
print("<meta http-equiv='refresh' content='0;URL=newPage.htm'>"
;//This redirects the user to the newPage.htm
else
print("wrong login"
;?>
- Status
Similar threads
