Login page that leads to different URLs
Posted: Fri Sep 10, 2010 7:17 pm
I am not experienced with PHP at all and I need help with something very simple. I want to have a login page where as the user logs in, it takes them to the URL that is associated with their username and password. Here is the PHP code that checks the login and password. As it is right now, when the user logs in it takes them to page.php. How do I make it so it takes them to the URL tied to their name? The field name for the URL will be: url.
Code: Select all
<?php
ob_start();
$host="myhostname"; // Host name
$username="myusername"; // Mysql username
$password="mypass"; // Mysql password
$db_name="mydbname"; // Database name
$tbl_name="members"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Define $myusername and $mypassword
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:page.php");
}
else {
echo "Wrong Username or Password";
}
ob_end_flush();
?>