mysql - Login only first user error -

mysql - Login only first user error -

iam using php 5.5 , pdo create login code. code working fine first user loged in don't know why? illustration have 5 user in database table. when login first 1 goes logedin when seek login 2nd or 3rd 1 show error message set on wrong info login. below login code...

<?php session_start(); include 'conn.php'; seek { $user = $_post['user']; $pass = $_post['pass']; $remember=$_post['remember']; $smt=$conn->prepare("select * signup"); $smt->execute(); $result=$smt->fetch(pdo::fetch_obj); $prev=$result->password; $usr=$result->username; if(password_verify($pass,$prev)& $user===$usr) { // set username session variable $_session['user'] = $user; // jump secured page header('location:index.php'); } else { header('location:signin.php'); $_session['login']="incorrect username or password"; } if($remember) { setcookie('remember-me',$user,time()+3600000); setcookie('remember-pass',$pass,time()+3600000); header('location:index.php'); } else { setcookie('remember-me',$user,false); setcookie('remember-pass',$pass,false); } } catch(pdoexception $e) { throw new pdoexception($e); } ?>

thanks in advance...

you missing where clause :

select * signup username = :user

adjust code following:

$smt=$conn->prepare("select * signup username =:user"); $smt->execute(array(':user'=>$user));

mysql pdo php-5.5