prepare("INSERT INTO `student` (regno,first_name,middle_name,last_name,phone_no,username,password,user_role,department) VALUES('$regno','$first_name','$middle_name','$last_name','$phone_no','$username','$password','$user_role','$department')") or die(""); header('location: index.php'); $statement->execute(); } ?>