<?php
global $wpdb, $signature;
$prefix = $wpdb->base_prefix;
$id = $_REQUEST['id'];
$city = Districtdetail($id);
$state_id = $city[0]->state_id;
$link = '&ho=listdistricts&state_id=' . $state_id;
$url = get_option('home') . '/wp-admin/admin.php?page=TempleState' . $link;
$result = $wpdb->query("DELETE FROM `" . $prefix . "temple_city` where district_id='{$id}'");
$result = $wpdb->query("DELETE FROM `" . $prefix . "temple_districts` where id='{$id}'");
if ($result == 1) {
$url = $url . '&del=succ';
echo "<script>window.location='" . $url . "'</script>";
}
<?php
global $wpdb;
$prefix = $wpdb->base_prefix;
$blog_id = $wpdb->blogid;
$state_id = $_REQUEST['state_id'];
$link = '&ho=listcity&state_id=' . $state_id;
$url = get_option('home') . '/wp-admin/admin.php?page=TempleState' . $link;
$querystr = "SELECT * FROM " . $prefix . "temple_state";
$states = $wpdb->get_results($querystr, OBJECT);
$districts = Districtdetail('', " and state_id='{$state_id}'");
$error = array();
if (isset($_POST['addcity'])) {
$city = $_POST['city'];
if (trim($city) == '') {
array_push($error, 'Please enter city.');
}
$district_id = $_POST['district_id'];
if (trim($district_id) == '') {
array_push($error, 'Please select district.');
}
if (count($error) <= 0) {
$sql = "INSERT INTO `" . $prefix . "temple_city` (`state_id`, `city`,`updated_on`, `district_id`) VALUES ('{$state_id}', '{$city}', now(), '{$district_id}')";
$result = $wpdb->query($sql);
if ($result == 1) {
$url = $url . '&add=succ';
echo "<script>window.location='" . $url . "'</script>";
}
}
}
?>
