我知道这听起来像是重复的,但我真的没有找到问题的答案。
我正在做一个表格,以获得具体的细节,这是密码
这是表格

<form method="post" name="lostpass" action="forgotpass.php">
                        <ul>
                        <li>Admin Name:<input name="admin" type="text"></li>
                        <li> E.mail: <input name="email" type="text"><br></li>
                        </ul>
                        <input type="submit" name="get" value="get infos">
                        <input type="reset" name="reset" value="Reset">
                    </form>

所以从这些数据中我可以得到丢失的密码
这是php代码
 <?php
    $con=mysqli_connect("rock","mido","1234","fyp");
    // Check connection
    if (mysqli_connect_errno())
      {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      }

     $result = mysqli_query($con,"SELECT password FROM admin WHERE email = 'email', Admin = 'admin' ");
      while($row = mysqli_fetch_array($result))

    echo  $row['password'];

    mysqli_close($con);
    ?>

它给了我这个错误(mysql_fetch_array()期望参数1是mysqli_result)。
谢谢你的帮助

最佳答案

替换此代码:

$result = mysqli_query($con,"SELECT password FROM admin WHERE email = 'email', Admin = 'admin' ");

具有
 $result = mysqli_query($con,"SELECT password FROM admin WHERE email = '$_POST[email]' AND Admin = '$_POST[admin]'");

谢谢。

10-05 20:34
查看更多