在mysql select query中的where子句中比较session变量

Question

Hye developers, please sort me out, I have two php files, in the first file (login.php) I declared a session variable $_SESSION['email']; and assigned user input into it, and in the second file, I place a select query and use that session variable to compare a database column in the where clause of the query, but the session variable is reporting undefined index in the index.php file

I actually want the query to check if the database column is marthar then echo some html elements

login.php

    $email = '".$_POST['email']."';
    $_SESSION['email']=$email;

email is the name of my html input

index.php

    <?php
                $query=mysqli_query($db_handle,"SELECT * FROM members WHERE email='".$_SESSION['email']."'");
    $row=mysqli_fetch_array($query);

    if(is_array($row)){
    if($row['model']=='Marthar'){

    echo "<li>
    <a href='settings.php' class=' hvr-bounce-to-right'><i class='fa fa-cog nav_icon'></i> <span class='nav-label'>Settings</span> </a>
    </li>"; 
   }
   }

   ?>

Answer 1

In your login.php, please use the below and add session_start(); on top of your php page

$email="";
if (isset($_POST['email'])) { 
    $email=$_POST['email']; 
} else {
    $email='';
}
$_SESSION['email']=$email;