php 登录重定向,PHP登录后重定向

我有一个子域名

accounts.mysite.com

我想要的是该子域的一个登录面板,然后在用户登录后将它们引导到他们自己的页面(并阻止他们查看“其他帐户”页面).

所以当他们去account.mysite.com时,这是登录页面.用户使用特定名称登录,通过.成功登录后,将其导入其帐户页面,但会阻止所有其他页面.

这是我到目前为止所拥有的

ob_start();

$host="localhost"; // Host name

$username="******"; // Mysql username

$password="*******"; // Mysql password

$db_name="medpro_test"; // 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

session_register("myusername");

session_register("mypassword");

header('Location: user.php?id=' . $_SESSION['user_id']);

}

else {

$result = MYSQL_QUERY($sql) or die('Query failed: ' . mysql_error() . "
\n$sql");

echo "Wrong Username or Password";

}

ob_end_flush();

?>

我是一个菜鸟所以任何帮助将不胜感激！