holiday_add.php

<?php
    	
	include_once 'config/config.php';
	//var_dump($_POST);
	
    	
    	
    	$holidayid=$_POST['holidayid'];	
      $holidayname=$_POST['holidayname'];
    $holidaydescription=$_POST['holidaydescription'];
    $holidaydate=$_POST['holidaydate'];
    
    $createddate=$_POST['createddate'];
    $modifieddate=$_POST['modifieddate'];
    $status=$_POST['status'];


     $q="INSERT INTO holidays (`Holiday_id`, `Holiday_name`, `Holiday_description`, `Holiday_date`,`Created_date`, `Modified_date`, `Status`) values('".$holidayid."','".$holidayname."','".$holidaydescription."','".$holidaydate."','".$createddate."','".$modifieddate."','".$status."')";
	
	
    
      if(mysqli_affected_rows($connection_obj) > 0)
	
	{
			$data = mysqli_fetch_assoc($q);

	}
	else
	{
		echo "error".mysqli_error($connection_obj);
		//header("location:./500.php");

	}


	$status = mysqli_query($connection_obj,$q);
	if($status)
	{
		
		header("location:./holiday_count.php");
	}
	else
	{
		echo "error".mysqli_error($connection_obj);
		
		//header("location:./500.php");
	}


?>