Qfyilyi

if(isset($_POST['btnLogin']))

{

$username = $_POST['txtusername'];

$pass_word = $_POST['txtpassword'];

$hashed_password = crypt(sha1($pass_word));





$sqlQuery  = "SELECT * from users WHERE username = :username AND password = :password" ;

$statement = $conn->prepare($sqlQuery);

$statement->execute(array(':username' =>$user , ':password'=>$hashed_password));



while($row->$statement->fetch())

{

    $id       = $row['id'];

    $username = $row['username'];

    $password = $row['password'];



    if(strcmp('$password', '$hashed_password') == 0)

    {

        echo "<script type='text/javascript'>console.log("Sucess");</script>";

    }

    else

    {

        echo "<script type='text/javascript'>console.log("Failed");</script>";

    }



}



}

In here I am implementing the Sign in a page using PHP PDO codes.
I have no previous experience in using PHP PDO.I do the Sign up page without any errors but unfortunately program is not execute after

while($row->$statement->fetch())

here are the HTML codes

<section>



    <div class="container">

        <div class="login-form">

            <h1>Sign In</h1>

            <form id="login-form" method="post" action="">

            <div class="form-group">

                <input type="text" name="txtusername" placeholder="Username" data-validation="required">

            </div>

            <div>

                <input type="password" name="txtpassword" placeholder="Password" data-validation="required">

            </div>

                <input type="submit" name="btnLogin" value="Login">

            </form>

        </div>

    </div>

</section>

PHP VERSION : 5.3.8

Please give any suggestion to me for solve it

Try the below. If it doesn't work, wrap your query in this and turn error reporting on.

if(isset($_POST['btnLogin']))

{

$username = $_POST['txtusername'];

$pass_word = $_POST['txtpassword'];

$hashed_password = crypt(sha1($pass_word));





$sqlQuery  = "SELECT * from users WHERE username = :username AND password = :password" ;

$statement = $conn->prepare($sqlQuery);

$statement->execute(array(':username' =>$user , ':password'=>$hashed_password));



while($row = $statement->fetch_object())

{

    $id       = $row->id;

    $username = $row->username;

    $password = $row->password;



    if(strcmp('$password', '$hashed_password') == 0)

    {

        echo '<script type="text/javascript">console.log("Success");</script>';

    }

    else

    {

        echo '<script type="text/javascript">console.log("Failed");</script>';

    }



}

}