select specific row php and mysql

Question

I know its sounds like repeated but really I didn't find an answer for the problem am having.

am making a form to get specific details which is password this is the form

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

so from it this data I get I can get the lost password

and this is the php codes

 <?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);
    ?>

its giving me this error (mysql_fetch_array() expects parameter 1 to be mysqli_result).

thanx for your help

Muhammad Ashikuzzaman · Accepted Answer · 2014-05-21 08:28:35Z

1

Replace this code :

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

with

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

Thanks.

answered May 21, 2014 at 8:28

Muhammad Ashikuzzaman

3,1736 gold badges32 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

opa.mido Over a year ago

do u have any idea how to make the result or the echo on popup window ?

Muhammad Ashikuzzaman Over a year ago

Do you want like this :echo "<script>alert('Hellow Muhammad Ashikuzzaman Odesk Password of your ID Has been Changed!');</script>";

opa.mido Over a year ago

almost. I want it to show the password stored in the database .. somehow like a massage says : your password is: 12345678

Muhammad Ashikuzzaman Over a year ago

Please describe the problem again.

opa.mido Over a year ago

I did like this but it didn't work echo "<script>alert("<?php echo "your password is:" . "$row['password']"?>") </script>"

|

Collectives™ on Stack Overflow

select specific row php and mysql

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related