php - 必须登录两次才能成功 php

Question

我正在以管理员的身份构建站点并了解有关 php 的更多信息。我不确定我的脚本有什么问题，但我必须登录两次才能使其正常工作。任何人都可以帮我解决我在这里做错了什么还是我错过了什么？谢谢你。

提交页面 - 包括帖子。

<?php
                    if(isset($_POST['submit']))
                    {
                        include('common.php');

                        $username = trim($_POST['username']);
                        $password = trim($_POST['password']);

                        if($sqlquery = $conn->prepare("SELECT userID FROM user WHERE username = ? AND password = ?"))
                        {
                            $sqlquery->bind_param("ss", $username, $password);
                            $sqlquery->execute();
                            $sqlquery->store_result();
                            $count = $sqlquery->num_rows;

                            if($count > 0)
                            {
                                $sqlquery->bind_result($userid);
                                $sqlquery->fetch();
                                $_SESSION['currentUserID'] = $userid;
                                echo "<META http-equiv='refresh' content='0;URL=http://www.whatever.com/newPage.php'>";
                            }
                            else
                            {
                                echo "Wrong Username or Password";
                            }
                        }
                    }

common.php 包含数据库和所有内容的信息......这是复制的。

<?php
    $db_server = "localhost";
    $db_name = "something";
    $db_username = "something";
    $db_password = "something";
    
    $conn = mysqli_connect($db_server, $db_username, $db_password, $db_name );



    if (session_status() == PHP_SESSION_NONE) {
        ini_set('session.save_path',realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/session'));
        session_start();
        //echo "new session started user id: ".$_SESSION['currentUserID'];
}


    if (!$conn)
    {
        print "Could not connect." ;
        exit;
    }
?>

标签： phpauthentication