32 lines
856 B
PHP
32 lines
856 B
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('log_entry.php');
|
|
include_once("includes/functions.php");
|
|
|
|
if ($conn->connect_error) {
|
|
die("Connection failed: " . $conn->connect_error);
|
|
}
|
|
|
|
$ohctype = isset($_REQUEST['ohctype']) ? intval($_REQUEST['ohctype']) : 0;
|
|
|
|
$role_type = mysqli_real_escape_string($conn, $_SESSION['role_type']);
|
|
|
|
$item_sql = "SELECT id, agency_name FROM agency WHERE ohc_type_id = '$ohctype'";
|
|
|
|
$result = mysqli_query($conn, $item_sql);
|
|
|
|
$options_html = '';
|
|
|
|
if ($result && mysqli_num_rows($result) > 0) {
|
|
while ($row = mysqli_fetch_assoc($result)) {
|
|
$options_html .= '<option value="' . $row['id'] . '">' . $row['agency_name'] . '</option>';
|
|
}
|
|
} else {
|
|
$options_html .= '<option value="">No agencies available</option>';
|
|
}
|
|
|
|
echo json_encode(['options_html' => $options_html]);
|
|
|
|
mysqli_close($conn);
|
|
?>
|