Php登录(如果存在） - Php Log In If-Else

Php Log In If-Else

本文关键字：存在如果登录 Php | 更新日期: 2023-09-27

我有这个代码：

<?php include "konek.php"; 
if(isset($_POST['submit']))
{
    $schoUsername = $_POST['schoUsername'];
    $schoPassword = $_POST['schoPassword'];
    $schoPosition = $_POST['schoPosition'];
            $password = sha1($schoPassword);
    $sql = "SELECT * FROM tblscholar WHERE schoUsername = '$schoUsername' AND schoPassword = '$password' ";
    $conn = db_connect();
    $result = $conn->query($sql);
    $row_num = mysqli_num_rows($result); 
    if($row_num != 0)
    {  
     $sql = "SELECT * FROM tblscholar WHERE schoUsername = '$schoUsername' AND schoPassword = '$password'";
     $connect = db_connect();
     $res = $connect->query($sql);
     $row_num = mysqli_num_rows($res); 
     if($schoPosition == 'Spiritual_and_Community_Services_Committee_Head')
            header("Location:DashboardForSCSCH.php");
        else    
            header("Location:DashboardForUser.php"); }
    else 
     {  echo "invalid"; } }?>

这是konek.php

<?php
function db_connect() {
$result = new mysqli('localhost', 'root', '', 'simbayanan');
if (!$result) return false;
return $result; } ?>

我希望它是这样的，如果你的职位是管理员，你将直接进入管理员的仪表板，当你的职位为图书管理员时，你将立即进入图书管理员的仪表盘，反之亦然。每次登录时，页面都会在dashboardforuser.php 中重定向

添加出口以打破流

 if($schoPosition == 'Spiritual_and_Community_Services_Committee_Head')
        header("Location:DashboardForSCSCH.php");
        exit();
    else    
        header("Location:DashboardForUser.php");
        exit(); 
               }
else 
 {  echo "invalid"; } }?>

<?php include "konek.php"; 
if(isset($_POST['submit']))
{
$con = db_connect();
$schoUsername = mysql_real_escape_string($_POST['schoUsername'],$con);
$schoPassword = mysql_real_escape_string($_POST['schoPassword'],$con);
$schoPosition = mysql_real_escape_string($_POST['schoPosition'],$con);
$sql = "SELECT * FROM tblscholar WHERE schoUsername = '$schoUsername' AND schoPassword    =     '$password' ";
$result = $conn->query($sql);
$row_num = mysqli_num_rows($result); 
if($row_num != 0)
{  
switch ($schoPosition) {
case 'Spiritual_and_Community_Services_Committee_Head':
    header("Location:DashboardForSCSCH.php");
    break;
case 1:
    header("Location:DashboardForAdmin.php");
    break;
case 2:
    header("Location:DashboardForLibrarian.php");
    break;
default: 
    header("Location:DashboardForUser.php");
    break;
    }
}