php - 选择特定行 php 和 mysql

Question

我知道这听起来像是在重复，但实际上我没有找到问题的答案。

我正在制作一个表格来获取特定的详细信息，即密码这是表格

<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)。

谢谢你的帮助

Answer 1

替换这段代码:

$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]'");

谢谢。