根据下拉值运行SQL查询[关闭]

Question

<?php
include("dbconfig.php");
if(isset($_POST['type'])== "enquiry")
{
    query for enuiry;

}
else{
    query for enroll;
}

?>
<form action="dropd.php" method="POST">
<select name="type">
<option>Please select:</option>
<option value="enquiry">Student enquiry</option>
<option value="enroll">Student enrollment</option>
<input type="submit" name="submit" value="SUBMIT">
</select>
</form>

Hi.. I want to run two different SQL query based on drop down selection. I dont know how to do it. I am fresh to php. Guide me please.

Answer 1

<?php
include("dbconfig.php");
if(isset($_POST['submit']))
{
   if(isset($_POST['type']))
   {
       if($_POST['type'] == "enquiry")
       {
            Query
       }
       elseif($_POST['type'] == "enroll")
       {
            Query
       }
       else
       {
          echo "Please select enquiry or enrollment";
       }
   }
   else
   {
      echo "Please select an option";
   }

}

?>
<form action="dropd.php" method="POST">
<select name="type">
<option value="">Please select:</option>
<option value="enquiry">Student enquiry</option>
<option value="enroll">Student enrollment</option>
<input type="submit" name="submit" value="SUBMIT">
</select>
</form>