时间戳

首页 > 解决方案 > 如果 PHP 中的语句不起作用，则不运行 if OR else

php - 如果 PHP 中的语句不起作用，则不运行 if OR else

问题描述

标题.... 下面的 if 语句不起作用，我添加到控制台日志以检查返回的条件并检查出来。有谁知道它有什么问题？变量 $check 是在另一个不在此处的文件中创建的。如果变量检查没有输出正确的值，它显然不起作用，但它确实输出了正确的值。

会话.php

<?php
// mysqli_connect() function opens a new connection to the MySQL server.
$conn = mysqli_connect("localhost", "root", "", "sports world");
session_start();// Starting Session
// Storing Session
$user_check = $_SESSION['login_user2'];
$p = $_SESSION['login_user3'];

$check = $_SESSION['check'];
?>
<script> let check = "<?php echo $check; ?>";
console.log(check)</script>
<?php

if ($check === 'user') {
    // SQL Query To Fetch Information Of User
    $query = "SELECT Username from staff where Username = '$user_check'";
    $ses_sql = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($ses_sql);

    $login_session = $row['Username'];


    // SQL Query To Fetch Information Of User
    $query2 = "SELECT StaffCode from staff where Username = '$user_check' AND Password = '$p'";
    $ses_sql2 = mysqli_query($conn, $query2);
    $row2 = mysqli_fetch_assoc($ses_sql2);

    $cust = $row2['StaffCode'];
    $_SESSION['CustCode'] = $cust;


    // SQL Query To Fetch Information Of User
    $query3 = "SELECT StaffGivenName As 'Given Name', StaffSurname As 'Surname' from staff where StaffCode = '$cust'";
    $ses_sql3 = mysqli_query($conn, $query3);
    $row3 = mysqli_fetch_assoc($ses_sql3);

    $name1 = $row3['Given Name'];
    $name2 = $row3['Surname'];
    $_SESSION['Given Name'] = $name1;
    $_SESSION['Surname'] = $name2;


    // SQL Query To Fetch Information Of User
    $queryAccountDeatils = "SELECT StaffDob As 'Date of Birth', StaffGender As 'Gender', StaffAddress1 As 'Address', StaffAddress2 As 'Region', StaffPostCode As 'Post Code', StaffPhone As 'Phone Number', StaffEmail As 'Email', StaffTFN As 'Message Preferences', StaffEmerConName As 'Member Type', StaffEmerConPhone As 'Sports' from staff where StaffCode = '$cust'";
    $ses_sql4 = mysqli_query($conn, $queryAccountDeatils);
    $row4 = mysqli_fetch_assoc($ses_sql4);

    $Dob = $row4['Date of Birth'];
    $Address = $row4['Address'];
    $Gender = $row4['Gender'];
    $Region = $row4['Region'];
    $PostCode = $row4['Post Code'];
    $PhoneNumber = $row4['Phone Number'];
    $Email = $row4['Email'];
    $MessagePref = $row4['Message Preferences'];
    $MemberType = $row4['Member Type'];
    $Sports = $row4['Sports'];
    $_SESSION['Date of Birth'] = $Dob;
    $_SESSION['Address'] = $Address;
    $_SESSION['Gender'] = $Gender;
    $_SESSION['Region'] = $Region;
    $_SESSION['Post Code'] = $PostCode;
    $_SESSION['Phone Number'] = $PhoneNumber;
    $_SESSION['Email'] = $Email;
    $_SESSION['Message Preferences'] = $MessagePref;
    $_SESSION['Member Type'] = $MemberType;
    $_SESSION['Sports'] = $Sports;
} else if ($check === 'staff') {
    // SQL Query To Fetch Information Of User
    $query = "SELECT Username from login where Username = '$user_check'";
    $ses_sql = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($ses_sql);

    $login_session = $row['Username'];


    // SQL Query To Fetch Information Of User
    $query2 = "SELECT CustCode from login where Username = '$user_check' AND Password = '$p'";
    $ses_sql2 = mysqli_query($conn, $query2);
    $row2 = mysqli_fetch_assoc($ses_sql2);

    $cust = $row2['CustCode'];
    $_SESSION['CustCode'] = $cust;


    // SQL Query To Fetch Information Of User
    $query3 = "SELECT CustGivenName As 'Given Name', CustSurname As 'Surname' from customers where CustCode = '$cust'";
    $ses_sql3 = mysqli_query($conn, $query3);
    $row3 = mysqli_fetch_assoc($ses_sql3);

    $name1 = $row3['Given Name'];
    $name2 = $row3['Surname'];
    $_SESSION['Given Name'] = $name1;
    $_SESSION['Surname'] = $name2;


    // SQL Query To Fetch Information Of User
    $queryAccountDeatils = "SELECT CustDob As 'Date of Birth', CustGender As 'Gender', CustAddress1 As 'Address', CustAddress2 As 'Region', CustPostCode As 'Post Code', CustPhone As 'Phone Number', CustEmail As 'Email', CustMsgPref As 'Message Preferences', CustMemberType As 'Member Type', CustSports As 'Sports' from customers where CustCode = '$cust'";
    $ses_sql4 = mysqli_query($conn, $queryAccountDeatils);
    $row4 = mysqli_fetch_assoc($ses_sql4);

    $Dob = $row4['Date of Birth'];
    $Address = $row4['Address'];
    $Gender = $row4['Gender'];
    $Region = $row4['Region'];
    $PostCode = $row4['Post Code'];
    $PhoneNumber = $row4['Phone Number'];
    $Email = $row4['Email'];
    $MessagePref = $row4['Message Preferences'];
    $MemberType = $row4['Member Type'];
    $Sports = $row4['Sports'];
    $_SESSION['Date of Birth'] = $Dob;
    $_SESSION['Address'] = $Address;
    $_SESSION['Gender'] = $Gender;
    $_SESSION['Region'] = $Region;
    $_SESSION['Post Code'] = $PostCode;
    $_SESSION['Phone Number'] = $PhoneNumber;
    $_SESSION['Email'] = $Email;
    $_SESSION['Message Preferences'] = $MessagePref;
    $_SESSION['Member Type'] = $MemberType;
    $_SESSION['Sports'] = $Sports;
}

控制台日志

标签： php

解决方案

嗯....这很尴尬，条件工作人员和用户在错误的语句中只需要切换它们。

推荐阅读