我是PHP和HTML的新手。我已经在制作登录页面了。它可以定义我登录的用户。(作为用户或管理员)。问题是,当我转到另一个页面(adminMain.php)时,我想让该页面显示为受欢迎的页面。空白是数据库中的用户名和用户角色。我想从数据库中调用它。当我使用mysqlfeacharray时,它会出现,但它有点调用数据库中的所有用户数据。我的意思是,我想从我已经登录的用户的数据库调用数据。请帮我:(。我也不知道如何使用会话。
*checklogin.php*
<?php
session_start();
if ($_POST['submit'])
{
include("config1.php");
$username = mysql_real_escape_string($_POST['username']);
$userpass = mysql_real_escape_string($_POST['userpass']);
$qstr = "SELECT * from login where username ='$username' and userpass ='$userpass'";
$result = mysql_query($qstr);
$count =mysql_num_rows($result);
if($count==1)
{
$fetch=mysql_fetch_row($result);
if($fetch[5]=='ADMIN')
{
echo ("<SCRIPT LANGUAGE='JavaScript'>
window.alert('LOGIN SUCCESS.WELCOME ADMIN')
window.location.href='adminMain.php';
exit();
</SCRIPT>");
$_SESSION['username'] = $_POST['username'];
}
else if($fetch[5] =='USER')
{
echo ("<SCRIPT LANGUAGE='JavaScript'>
window.alert('LOGIN SUCCESS.WELCOME USER')
window.location.href='userMain.php';
exit();
</SCRIPT>");
$_SESSION['username'] = $_POST['username'];
}
}
else
{
echo ("<SCRIPT LANGUAGE='JavaScript'>
window.alert('WRONG USERNAME OR PASSWORD.PLEASE TRY AGAIN')
window.location.href='login.php';
exit();
</SCRIPT>");
$_SESSION['username'] = $_POST['username'];
}
}
mysql_close();
?>
这是我的管理员Main.php
<html>
<head>
<title>action</title>
<body bgcolor="#FFFFFF" text="#000000" link="#333333">
<p><img src="joho.jpg" width="334" height="203"> <img src="msc.jpg" width="769" height="200">
'</p>
<p>
<p>
<?php
session_start();
?>
<?php
include 'config1.php';
$query = "SELECT username, userrole FROM login";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Name :{$row['username']} <br>" .
"Role : {$row['userrole']} <br>";
}
?>
<a href="newRegister.php"><font size="6">
NEW REGISTER USER</font></a>
<p> <a href="viewRequestAdmin.php"><font size="6">VIEW
REQUEST</font></a>
<p> <a href="updateAdmin.php"><font size="6">UPDATE
ADMIN INFORMATION</font></a>
<p>
试试这个
$query = "SELECT username, userrole FROM login where username='$_SESSION[username]'";
或者你可以使用
$username=$_SESSION['username'];
$query = "SELECT username, userrole FROM login where username='$username'";
修改sql以限制为1个用户。
$qstr="从登录中选择*,其中username='$username'和userpass='$userpass'LIMIT 1
";
选择所有内容后,您可以通过执行以下操作重定向用户:
$User=$_POST['username'];
header("Location:usermain.php?User=$user&UserType=$fetch[5]");
在您的Usermain.php 中
您可以使用get方法获取变量:
像这个
<p><?php
$User=$_GET["User"];
$UserType=$_GET[UserType"];
echo $User. " Logged in as ". $UserType;
?></p>
$qstr = "SELECT username, userrole from login where username ='$username' and userpass ='$userpass'";