<?php
error_reporting(0);
@session_start();
include("config.php");
$state=$_POST['state'];
$district=$_POST['district'];
$flag = $_REQUEST[flag];


/***********************************/
$id= $_POST[id];
if($flag=="del")
{
	$id= $_GET[id];	
	
	
	$query=sprintf("Delete from district where id ='%d'", $id);
	  $result = $conn->query($query);
	header("Location:add-district.php?flag=del");
	exit;
}
if($id=="")
{ 
    	
		 $qadd4=sprintf("INSERT INTO district set state_id='%s',district_name='%s'", $state,$district);
		   $result = $conn->query($qadd4);
		  
		 
		 header("Location:add-district.php?flag=dn");
		 exit;
}
$id= $_POST[id];
if($id!="")
{
          $query_up=sprintf("UPDATE district SET   state_id='$state',district_name='$district'
		  
		 
		  WHERE id='%d'",$id); 
		 $result = $conn->query($query_up);
   
		
		header("Location:add-district.php?flag=up");
		exit;
		
		}
?>