php - 无法连接到 mySQL 数据库

Question

我正在处理一个 php 登录表单，每次我尝试登录时，它都会显示“找不到您输入的用户名。”女巫我在我的代码中有一个 if 语句，我认为这是因为我没有将某些东西正确地链接到 mySQL。我已经为此工作了几天，但无法解决!你们能帮帮我吗？谢谢-约翰

<?
    $form = "<form action='./login.php' method='post'>
    <table>
    <tr>
        <td>Username:</td>
        <td><input type='text' name='user' /></td>
    </tr>
    <tr>
        <td>Password:</td>
        <td><input type='password' name='password' /></td>
    </tr>
    <tr>
        <td></td>
        <td><input type='submit' name='loginbtn' value='Login' /></td>
    </tr>
    </table>
    </form>";

    if ($_POST['loginbtn']){
        $user = $_POST['user'];
        $password = $_POST['password'];

        if ($user){
            if ($password){
                require("connect.php");

                $password = md5(md5("ak3sfx".$password."58ghy7"));

                //Make sure login info is good
                $query = mysql_select_db("users");

                if ($numrows == 1){
                    $row = mysql_fetch_assoc($query);
                    $dbuser = $row['users'];
                    $dbpassword = $row['password'];

                    if ($password == $dbpassword){
                        //Set session info
                        $_SESSION['username'] = $dbusers;

                        echo "You have been logged in as <b>$dbuser</b> <a href='./member.php'>Click here</a> to continue";

                    }
                    else
                        echo "You did not enter the right password. $form";

                }
                else
                    echo "The username you entered was not found. $form";

                mysql_close();

            }
            else
                echo"You must enter your password. $form";
        }
        else
            echo"You must enter your username. $form";
    }
    else
        echo $form;

?>

Answer 1

mysql_select_db("users") 将数据库更改为用户。您是否要从用户表中选择数据？如果是这样，您需要更改此行。

查看此链接。 http://php.net/manual/en/function.mysql-fetch-assoc.php这些例子将帮助你