$("#id_dept").change(function(){
$.ajax({
type: "GET",
url: "GetManager.php",
data: "department=" + $(this).find(":selected").val(),
dataType: "text",
cache: false,
success: function(msg){
$("#manager").empty();
response = $.parseJSON(msg);
for (i = 0; i < response.length; i++) {
$("#manager").append("<option value='" + response[i] + "'>" + response[i] + "</option>");
}
$("#manager").trigger('change');
}}});
$("#id_dept").trigger('change');
});
<tr>
<td><label for="id_dept"><b>Department</label></td>
<td class='centerPad'>:</td>
<td>
<select for="id_dept" name="id_dept" id="id_dept">
<option value=""></option>
<?php
$SQL = "select distinct department from Managers";
$rs = $conn->Execute($SQL);
while (!$rs->EOF) {
$a = $rs->Fields("Department")->value;
echo "<option value='".$a."'>".$a."</option>";
$rs->MoveNext();
}
?>
</select>
</td>
</tr>
<tr>
<td><label for="manager"><b>Approving Manager</label></td>
<td class='centerPad'>:</td>
<td>
<select for="manager" name="managers" id="manager">
<option value=""></option>
</select>
</td>
</tr>
The code above is in form.php.
[PHP]
$dept = $_GET['department'];
$manager = Array();
// SQL query returns multiple database records.
$query = "SELECT * FROM Managers WHERE Department = '".$dept."'";
$rs = $conn->Execute($query);
while (!$rs->EOF) {
$manager[] = $rs->Fields(1)->value;
$rs->MoveNext();
}
echo json_encode($manager);
[PHP]
The code above is Getmanager.php
Now when i try to update my table using the value i have gotten from AJAX.
$strSQL = "Select * from Managers where Names='".$manager."'";
$rs = $conn->Execute($strSQL);
Uncaught exception 'com_exception' with message 'Source: Unknown Description: Unknown'
it seems to be a problem with the datatype. something related to the "meta http-equiv="Content-Type" content="text/html; charset=UTF-8""
Please Help!