Proposing SQL Statement Coverage Metrics: Difference between revisions

   $username = $_POST[‘username’];  

   $password = $_POST[‘password’];  

   //query the database for a user with username/pw  

   $result = mysql_query(“select * from users where username =  ‘$username’ AND password = ‘$password’”);  

   //extract the first row of the resultset  

   $firstresult = mysql_fetch_array($result);  

   //extract the “role” column from the result  

   $role = $firstresult[‘role’];  

   //set a cookie for the user with their role  

   setcookie(“userrole”, $role);