目前我有一个名为checking的PHP代码.php网页上有两列,分别是标识号和密码。 我想要实现的是,一旦我点击提交按钮,代码就会检查输入是否与数据库匹配,如果匹配,它就会进入主屏幕.php并从数据库表中获取一些用户数据。 但现在我被困住了如何在 checking.to 后从该特定列中获取数据 为了使其更清晰,我设置了一个示例:
数据库信息:姓名:约翰密码:1234生日:1/2/2011IC:70202025
从检查.php,用户需要输入IC和密码进行身份验证,一旦信息正确,它将在主屏幕上显示其姓名和生日.php。
这是我的检查代码.php:
<?php
require 'dbconfig/config01.php';
?>
<form class="myform" action="BranchhavingProblem01.php" method="post">
<label><b>Identification Card No.</b></label>
<input name="CUS_IC" type="text" class="inputvalues" placeholder="IC No."required/><br>
<label><b>Password:</b></label>
<input name="CUS_PASSWRD" type="password" class="inputvalues" placeholder="Password"required/><br>
<input name="login" type="submit" id="login_btn" value="Login"/><br>
<?php
if(isset($_POST['login']))
{
$CUS_IC=$_POST['CUS_IC'];
$CUS_PASSWRD=$_POST['CUS_PASSWRD'];
$query = "select * from memberinfo WHERE CUS_IC='$CUS_IC' AND CUS_PASSWRD ='$CUS_PASSWRD' ";
$query_run = mysqli_query($con,$query);
if(mysqli_num_rows($query_run)>0)
{
//valid
$_SESSION['CUS_IC']=$CUS_IC;
header ('location:homeScreen.php');
}
else
{
//invalid
echo '<script type="text/javascript">alert("Invalid Credentials")</script>';
}
}
?>
在检查时.php设置一个会话变量,我假设您正在$_SESSION['CUS_IC']=$CUS_IC;
上设置它,当您移动到主屏幕时.php首先检查
if(isset($_SESSION['CUS_IC'])) {
$query = "select * from memberinfo WHERE CUS_IC='$_SESSION['CUS_IC']'
}
然后显示期望的结果
的检查.php:
<?php
session_start();
require 'dbconfig/config01.php';
?>
<?php
if(isset($_POST['login']))
{
$CARD_UID=$_POST['CARD_UID'];
$query = "select * from memberinfo WHERE CARD_UID='$CARD_UID' ";
$query_run = mysqli_query($con,$query);
$data = mysqli_fetch_array($con,$query);
if(mysqli_num_rows($query_run)>0)
{
//valid
$_SESSION['CARD_UID']=$CARD_UID;
$_SESSION['CUS_NAME']=$data['CUS_NAME'];
$_SESSION['CUS_IC']=$data['CUS_IC'];
header ('location:homeScreen.php');
}
else
{
//invalid
echo '<script type="text/javascript">alert("Invalid Credentials")</script>';
}
}
?>
这是我的主屏幕.php:
<?php
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title>Loyalty System</title>
<link rel="stylesheet" href="css/style.css">
</head>
<body style="background-color:#ECF0F1">
<div id="main-wrapper">
<center>
<h2>Welcome
<?php echo $_SESSION['CUS_NAME']?>!
</h2>
<h3>Your IC is:
<?php echo $_SESSION['CUS_IC']?>
</h3>