PHP登录脚本生成会话但不是标题（）移至主页

Question

PHP login Script Generate Session But Not Header() Move to Home page.

<?php
session_start();
$message="";
if(isset($_REQUEST['submit'])) {
    if(count($_POST)>0) {
        $username=$_POST["user_name"];
        $password=$_POST["password"];
        if(!empty($username) && !empty($password)){
            //include  connection file
            require_once "connection.php";
            $sql="SELECT * FROM `admin_users` WHERE `admin_user` LIKE  'username' AND `admin_pass`LIKE'$password'";
            $result = mysqli_query($con,$sql);
            $row=mysqli_fetch_row($result);
            if(is_array($row)) {
                $_SESSION["user_id"] = $row[0];
                $_SESSION["admin_name"] = $row[1];
                $_SESSION["type"]="admin_map";

                mysql_close($dbhandle);
            } else {
                $message = "Invalid Username or Password!";
            }
        }
        if(isset($_SESSION["user_id"]) &&  isset($_SESSION["admin_name"]) &&  isset($_SESSION["admin_name"])=="admin@map") {
            header("Location:user_dashboard.php");
        }
    }
    else{
        $message = "Fill All Fields!";
    }
}
?>

Answer 1

First of all add spaces in your query. And you are missing $ sign before username $username.

$sql="SELECT * FROM `admin_users` WHERE `admin_user` LIKE '$username' AND `admin_pass` LIKE '$password'";

I don't know why are you using LIKE in Login form. This must be check with = operator. (Just Suggestion)

Main issue in your code is that you are using mysqli_* extension and using mysql_close() for closing database connection.

mysql_close($dbhandle);

This should be

mysqli_close($dbhandle);

but use connection close at the end of your PHP script not between.