php编程, 用户登录后, 要跳转到只显示该用户的用户资料页面, 该怎么写。user.php<?
error_reporting(0);
$mysql_servername = "localhost";
$mysql_username = "xxx";
$mysql_password ="xxx";
$mysql_database ="db";
mysql_connect($mysql_servername , $mysql_username , $mysql_password);
mysql_select_db($mysql_database);
$name=$_POST['name'];
$password=$_POST['password'];if ($name && $password){
$sql = "SELECT * FROM users WHERE username = '$name' and passwort = '$password'";
$res = mysql_query($sql);
$rows=mysql_num_rows($res);
if($rows){
header("refresh:0;url=http://xxx/profile.php/");
exit;
}
echo "<script language=javascript>alert('Pasword Wrong!');history.back();</script>";
}else {
echo "<script language=javascript>alert('NO Password');history.back();</script>";
}?>谢谢解答。
error_reporting(0);
$mysql_servername = "localhost";
$mysql_username = "xxx";
$mysql_password ="xxx";
$mysql_database ="db";
mysql_connect($mysql_servername , $mysql_username , $mysql_password);
mysql_select_db($mysql_database);
$name=$_POST['name'];
$password=$_POST['password'];if ($name && $password){
$sql = "SELECT * FROM users WHERE username = '$name' and passwort = '$password'";
$res = mysql_query($sql);
$rows=mysql_num_rows($res);
if($rows){
header("refresh:0;url=http://xxx/profile.php/");
exit;
}
echo "<script language=javascript>alert('Pasword Wrong!');history.back();</script>";
}else {
echo "<script language=javascript>alert('NO Password');history.back();</script>";
}?>谢谢解答。
//header("refresh:0;url=http://xxx/profile.php/");
header("Location: 用户资料页面.php");
exit;
}
谢谢楼上的解答, 问题是我的profile.php, 如下, 包含了所有用户的信息, 咋写才能让profile.php只显示登录用户的信息呢?谢谢指点, 本人刚刚开始学php<?
$connt= mysql_connect("localhost","xxx","xxx");
mysql_select_db("db");
$strSql= mysql_query("select * from profile;");
if(!$strSql)
{
die("Valid result!");
}
else
{
echo " <table border='1'> ";
echo " <tr> ";
echo " <td> ID </td> ";
echo " <td> Name </td> ";
echo " <td> birthday </td> ";
echo " <td> like </td> ";
echo " <td>link </td> ";
echo " </tr> ";
while($row = mysql_fetch_row($strSql)){
echo " <tr> ";
echo " <td> $row[0] </td> ";
echo " <td> $row[1] </td> ";
echo " <td> $row[2] </td> ";
echo " <td> $row[3] </td> ";
echo " <td> $row[4] </td> ";
echo " </tr> ";
}
echo " </table> ";}
mysql_close($connt);
?>
header("Location: profile.php?username={$name}");2.profile.php
增加
$username = isset ( $_POST ['username'] ) ? $_POST ['username'] : '';修改
$strSql= mysql_query( "select * from profile; ");
为:
$strSql= mysql_query( "select * from profile WHERE username='{$username}'"); 注意这个表内是否有username段 请参照这个意思传递 id 或者 username 过来作为搜索条件即可.
增加
$username = isset ( $_POST ['username'] ) ? $_POST ['username'] : '';这里请修改成
$username = isset ( $_GET ['username'] ) ? $_GET ['username'] : '';即可
增加
$username = isset ( $_POST ['username'] ) ? $_POST ['username'] : '';这里请修改成
$username = isset ( $_GET ['username'] ) ? $_GET ['username'] : '';即可