<?php
		session_start();
		$dir_db="../connection/connect_to_db.php";//name of folder that contin the "connect_to_db.php"
		require_once("$dir_db");
		if($_POST['apply']){
			$empl_id=$_POST['empl_id'];
			$name=$_POST['name'];
			$day=$_POST['day'];
			$nat=$_POST['nat'];
			$dep=$_POST['dep'];
			$sec=$_POST['sec'];
			$jop=$_POST['jop'];
			$type=$_POST['v_type'];
			$start=$_POST['start'];
			$end=$_POST['end'];
			$daynum=$_POST['d_num'];
			$address=$_POST['address'];
			$phon=$_POST['phon'];
			if(strcasecmp($_SESSION['empl_id'],$empl_id)==0){
				//check if all information is completed
				if($empl_id && $name && $day && $nat && $dep && $sec && $jop && $type && $start && $end && $daynum && $address&& $phon){ 
					mysql_query("UPDATE $tale_name SET empl_id=$empl_id, name='$name',day='$day',nationalty='$nat',department='$dep',section='$sec',
					jop='$jop',vacation_type='$type',vacation_start='$start',vacation_end='$end',day_number=$daynum,address='$address',phon=$phon WHERE id='$_SESSION[id]';") or die(mysql_error());
				}
				else{
			
				  header("location :../compny/update.php");
				}
		    }
			else{
			
				header("location :../compny/update.php");
			 }
			header("location:../compny/display_vacation.php");
			display_table($table_name,$session_id);
		}
		else{
			header("location :../compny/update.php");
		 }

	  

?>