php简单登录脚本错误 - php simple login script error

php simple login script error

本文关键字：脚本错误登录简单 php | 更新日期: 2023-09-27

我正在尝试测试一个简单的代码来登录我的mysqldb，问题是当我点击表单按钮上的提交时，即使我确保表单操作指向我的操作文件，也不会发生任何事情

这是动作文件脚本

<?
mysql_pconnect("localhost","root","123") or die (mysql_error());
mysql_select_db("reservebox",$connection) or die (mysql_error());
$select="(SELECT adminUserName,adminPassword FROM admin)";
$query=mysql_query("$select") or die(mysql_error());
while (mysql_fetch_array($query))
{
    if ($query['adminUserName'] == $adminUserName & $query['adminPassword'] == $adminPassword)
    {
        echo "welcome to Admin Control Panel";
    }
    else
    {
        echo " problem with login";
    }
}
?>

我认为这是您的问题：

1) $select="(SELECT adminUserName,adminPassword FROM admin)";
2) $query=mysql_query("$select") or die(mysql_error());    
3) while (mysql_fetch_array($query))
4) if ($query['adminUserName'] == $adminUserName & $query['adminPassword'] == $adminPassword)

应该是：

1) $select="SELECT adminUserName,adminPassword FROM admin";
2) $query=mysql_query($select) or die(mysql_error());
3) while ($row = mysql_fetch_array($query))
4) if ($row['adminUserName'] == $adminUserName && $row['adminPassword'] == $adminPassword)

所以你的完整代码看起来像：

<?
mysql_pconnect("localhost","root","123") or die (mysql_error());
mysql_select_db("reservebox",$connection) or die (mysql_error());
$select="SELECT adminUserName,adminPassword FROM admin";
$query=mysql_query($select) or die(mysql_error());
while ($row = mysql_fetch_array($query))
{
    if ($row['adminUserName'] == $adminUserName && $row['adminPassword'] == $adminPassword)
    {
        echo "welcome to Admin Control Panel";
    }
    else
    {
        echo " problem with login";
    }
}
?>

试试这个：

<?
    $connection = mysql_pconnect("localhost","root","123") or die (mysql_error());
    mysql_select_db("reservebox",$connection) or die (mysql_error());
    $res = mysql_query("SELECT FROM admin WHERE adminUserName = '$adminUserName' AND adminPassword = '$adminPassword'");
    if(mysql_num_rows($res) == 1){
        "Welcome $adminUserName";
    }else{
        echo "Something went terrible wrong! D:";
    }
?>