<?php
error_reporting(0);
@session_start();
include("config.php");
$state=$_POST['state'];
$flag = $_REQUEST[flag];


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