25 lines
873 B
PHP
25 lines
873 B
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('log_entry.php');
|
|
|
|
$district_id = $_POST['district_id'];
|
|
$district_name = $_POST['district_name'];
|
|
$state_id = $_POST['state_id']; // Ensure this is an ID, not a name
|
|
$ohc_type_id =$_SESSION['current_ohcttype'];
|
|
|
|
error_log($district_id . "district");
|
|
|
|
if (!empty($district_id)) {
|
|
$query = "UPDATE districts SET name = '$district_name', state_id = '$state_id',ohc_type_id = '$ohc_type_id' WHERE id = '$district_id'";
|
|
error_log("update districts: " . $query);
|
|
} else {
|
|
$query = "INSERT INTO districts (name, state_id,ohc_type_id) VALUES ('$district_name', '$state_id','$ohc_type_id')";
|
|
error_log("insert districts: " . $query);
|
|
}
|
|
|
|
if (!$result = mysqli_query($conn, $query)) {
|
|
error_log("Database query failed: " . mysqli_error($conn));
|
|
exit("Database query failed: " . mysqli_error($conn));
|
|
}
|
|
?>
|