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>";
}?>谢谢解答。
解决方案 »
- wamp运行的php文件为什么装在www文件夹内?
- php遍历指定文件夹下的文件,形成下载链接。
- 发帖选择字体和颜色怎么实现啊?
- .....在深圳的朋友有没有......欢迎团队朋友一起创业B2B交易网,需要:ASP,NET/PHP/JSP/SEO/美工/架构人员
- 求一正则表达式,大虾请进
- php不能连接mysql
- 求一个正则表达式,使用preg_match
- 请教一下,这样写连接数据库的类可以吗?
- 求关键词自动回复sae数据库连接代码?
- 小白求教 php基础编程题
- javascript的getTime()和php的filemtime() 有什么关系??
- php怎么绕过登陆验证,无数据库版本,有md5
//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'] : '';即可