PHP - 单击重置按钮时清除“职务”下拉列表中的值


PHP - clear the value on job title drop down list when reset button clicked

Department

dept_ID       dept_name
   1           Account

职称

job_title_ID       job_title_name      dept_ID
     1             Account Manager        1 
     2              Account Clerk         1

用户.php

<html>
<head>
<link rel="stylesheet" href="js/jquery-ui-themes-1.11.1/themes/smoothness/jquery-ui.css" />
<script type="text/javascript" src="js/jquery-1.11.1.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.11.1/jquery-ui.js">   </script>
<script>
$(document).ready(function(){
    //---SELECT DEPARTMENT DROP DOWN LIST---
    $("#userdepartment").change(function(){
        var departmentID = $(this).val();
        $.ajax({
            type: 'POST',
            url: 'change.php',
            data: {departmentID: departmentID},
            success: function(html)
            {
                 $("#userjobtitle").html(html);
            }
        });
    });
});
</script>
</head>
<body>
<form name="adduser" method="post" action="user.php">
<table>
     <tr>
         <td>Department:</td>
         <td>
             <select name="userdepartment" id="userdepartment">
             <?php
             //---Db connection---
             $query = "SELECT *
                       FROM department
                       ORDER BY dept_name ASC";
             $result = mysql_query($query);
             print("<option value='"'">select one</option><br>");
             while($row = mysql_fetch_array($result))
             {
                 print("<option value='"" . $row['dept_ID'] . "'">" . $row['dept_name'] . "</option><br />");   
             }   
             ?>
             </select>
         </td> 
     </tr>
     <tr>
         <td>Job Title:</td>
         <td>
             <select name="userjobtitle" id="userjobtitle">
                  <option value="">select one</option>
             </select>
         </td>
     </tr>
    <tr>
         <td><input type="submit" name="submit" value="Add" /></td>
         <td><input type="reset" name="reset" value="Reset" /></td>
    </tr>
</table>
</form>
</body>
</html>

改变.php

<?php
//---DB connection---
$departmentID = $_POST['departmentID'];
$q = "SELECT j.job_title_ID, j.job_title_name 
      FROM job_title j, department d
      WHERE j.job_title_dept = d.dept_ID && d.dept_ID = $departmentID";
$r = mysqli_query($dbc, $q);
echo '<option value="">select one</option>';
while($row = mysqli_fetch_array($r, MYSQLI_ASSOC))
{
    echo '<option value="'.$row['job_title_ID'].'">'.$row['job_title_name'].'</option>';
} 
?>

上面的代码中,当我从部门下拉列表中选择帐户时,职位下拉列表将显示客户经理和帐户文员。
我的问题是当我单击重置按钮时,我应该如何清除职位下拉列表中的值?这是因为当我单击重置按钮时,职务下拉列表不会清除该值。有人可以帮助我吗?

尝试清空选择:

$('input[type="reset"]').click(function(e){
  e.preventDefault();
$('#userjobtitle').empty().append('<option value="">select one</option>');
});
您可以使用

如下Javascript来执行此操作:

.HTML:

<input type="reset" name="reset" value="Reset" onclick="reset();" />

Javascript:

function reset(){
  $('#userjobtitle').prop('selectedIndex',0);
}

你应该通过jquery在onclick事件上清除它,以及任何下拉菜单:

$('#userjobtitle').val('');

您可以使用和onclick事件

<input type="reset" name="reset" value="Reset"
       onclick="document.getElementById('userjobtitle').value='';" />