$sql = "SELECT username, verified, email FROM users WHERE username, verified, email";
if($stmt = mysqli_prepare($link, $sql)){
// prepare statements as parameters
mysqli_stmt_bind_param($stmt, "sis", $param_username, $param_verified, $param_email);
// parameters
$param_username = $username;
$param_email = $email;
$param_verified = $verified;
if(mysqli_stmt_execute($stmt)){
//
$_SESSION['username'] = $user['param_username'];
$_SESSION['verified'] = $user['param_verified'];
$_SESSION['email'] = $user['param_email'];
} else{
//empty
}
// empty
}
Above is code I have been trying to get to work. I believe something is wrong with my select statement that you recommended me to use (also thanks). I can tell because when I try to do the below code...
<?php echo $_SESSION['username']; ?>
<?php echo $_SESSION['verified']; ?>
<?php echo $_SESSION['email']; ?>
Username is echo'd and email and verified does not.
Thanks once again!