<?php

        $username=$_GET['username'];
        $password=$_GET['password'];

        $connect=mysql_connect("localhost","root","password");
        $db=mysql_select_db("testdb");

        $query="SELECT * FROM testtab WHERE username = '".$username."' AND password = '".$password."'";
        $res=mysql_query($query);

        while($rows=mysql_fetch_assoc($res)){
                echo "<b>Username:</b> ".$rows['username']."<br>";
                echo "<b>Password:</b> ".$rows['password']."<br>";
                echo "<b>Userstatus:</b> ";
                if($rows['admin']==0){
                        echo "User<br>";
                }
                else {
                        echo "Administrator<br>";
                }
}
?>