Page 1 of 1

Login page that leads to different URLs

Posted: Fri Sep 10, 2010 7:17 pm
by thedark_master
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();
?>

Re: Login page that leads to different URLs

Posted: Fri Sep 10, 2010 10:59 pm
by John Cartwright
You never specified your url structure for members, so I can only guess.

Perhaps,

Code: Select all

header("Location: /member/". $myusername);

Re: Login page that leads to different URLs

Posted: Fri Sep 10, 2010 11:44 pm
by thedark_master
thanks, thats exactly what I was looking for.