$query="select * from user where username='$uname' and password='$pwd'";
$res=mysqli_query($conn,$query); //$conn is your connection object
if(mysqli_num_rows($res)>0){
    $_SESSION['loggedin']=true;
}