25 lines
814 B
PHP
25 lines
814 B
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('log_entry.php');
|
|
|
|
$id = $_POST['id'];
|
|
$name = $_POST['name'];
|
|
$district_id = $_POST['district_id']; // Ensure this is an ID, not a name
|
|
$ohc_type_id =$_SESSION['current_ohcttype'];
|
|
|
|
error_log($district_id . "district");
|
|
|
|
if (!empty($id)) {
|
|
$query = "UPDATE tehsils SET name = '$name', district_id = '$district_id', ohc_type_id='$ohc_type_id' WHERE id = '$id'";
|
|
error_log("update districts: " . $query);
|
|
} else {
|
|
$query = "INSERT INTO tehsils (name, district_id,ohc_type_id) VALUES ('$name', '$district_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));
|
|
}
|
|
?>
|