<?php

	session_start();				
$flag=$_REQUEST['flag'];
include('../link/databaseconnection.php');
if(!$flag)
			{
				header("location:http://gcschool.co.in");
			}
switch($flag)
{
	case 1:
	

$name=$_POST['name'];
$code=$_POST['code'];
$adhar=$_POST['adhar'];
$mediam=$_POST['mediam'];
$caste=$_POST['caste'];
$minority=$_POST['minority'];
//echo"$name";
//echo"<br/>";
$depart=$_POST['depart'];
$father=$_POST['father'];
//echo"$father";
$mother=$_POST['mother'];
//echo"$mother";
//echo"<br/>";
$app=$_POST['app'];
//echo"$app";
//echo"<br/>";

$gender=$_POST['gnd'];
$session=$_POST['session'];
//echo"$gender";
$dob=$_POST['dob'];
$whatsapp=$_POST['whatsapp'];
//echo"$dob";
//$dob=date("d-m-Y",strtotime($dob1));
$class=$_POST['class'];
//echo"$class";
$mother=$_POST['mother'];
//echo"$mother";


//echo"$high1";

$section=$_POST['section'];
$subject=$_POST['group'];
//echo"$inter1";
$ele=$_POST['ele'];
//echo"$ele";
$board=$_POST['board'];
//echo"$board";
$year=$_POST['year'];
//echo"$year";
$tmark=$_POST['tmark'];
//echo"$tmark";
$omark=$_POST['omark'];
//echo"$omark";
$per=$_POST['per'];
//echo"$per";
$grade=$_POST['grade'];
//echo"$grade";
$city=$_POST['city'];
//echo"$city";
$city1=$_POST['city1'];
//echo"$city";
$village=$_POST['village'];
//echo"$village";
$village1=$_POST['village1'];
//echo"$village1";
$postoffice=$_POST['postoffice'];
//echo"$postoffice";
$postoffice1=$_POST['postoffice1'];
//echo"$postoffice1";
$dist=$_POST['dist'];
//echo"$dist";
$dist1=$_POST['dist1'];
//echo"$dist1";
$state=$_POST['state'];
//echo"$state";
$state1=$_POST['state1'];
//echo"$state1";
$mobile=$_POST['mobile'];
//echo"$mobile";
$mobile1=$_POST['mobile1'];
//echo"$mobile1";
$pincode=$_POST['pincode'];
//echo"$pincode";
$pincode1=$_POST['pincode1'];
//echo"$pincode1";
$imgname=$_FILES['picture']['name'];
//echo"$imgname";
$size=$_FILES['picture']['size'];
//echo"$size";
$type=$_FILES['picture']['type'];
//echo"$type";
$tempname=$_FILES['picture']['tmp_name'];
//echo"$tempname";
$pathinfo=pathinfo($imgname,PATHINFO_EXTENSION);
  //echo"$pathinfo";
  if($pathinfo!=""|| $pathinfo!=null)
  {
	  $newimgname=time()."_".$name.".".$pathinfo;
	  //echo$newimgname;
  }
  else
  {
	  $newimgname="";
  }

$date=date("d/m/Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$location="img/";
$location1="img/";
$size=$size/1024;


			
//--------------------------------------------------------------------
					
					$sel12="select * from registration where application='$app'";
				$res12=mysqli_query($conn,$sel12);
				$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
				$app12=$row12['application'];
				if($row12)
				{
					echo 'Allready Scholar Exist';
				}
				else
				{
				$ins="insert into  registration(application,name,fname,	mname,dob,gender,class,ele,board,year,total,obtain,per,grade,subject,city,village,postoffice,dist,state,mobile,pincode,picture,city1,village1,postoffice1,dist1, state1,mobile1,pincode1,session,mediam,adhar,datetime,minority,caste,code,whatsapp,signature,section) values('$app','$name','$father','$mother','$dob','$gender','$class','$ele','$board','$year','$tmark','$omark','$per','$grade','$subject','$city','$village','$postoffice','$dist','$state','$mobile','$pincode','$newimgname','$city1','$village1','$postoffice1','$dist1','$state1','$mobile1','$pincode1','$session','$mediam','$adhar','$datetime','$minority','$caste','$code','$whatsapp','$depart','$section')";
				if(mysqli_query($conn,$ins))
				{
					move_uploaded_file($tempname,$location.$newimgname);
					
					//----
					$sel12="select * from registration where application='$app' order by id desc";
				$res12=mysqli_query($conn,$sel12);
				$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
				$app12=$row12['application'];
				$id=$row12['id'];
				
					$up="update registration set application='$id' where application='$app' order by id desc";
					mysqli_query($conn,$up);
							//-----admitcard10---
	
					//-----
				
				$_SESSION['user']=$id;
				
					echo"Submit";
				
						
				}
				else
				{
					echo"not insert";
				}
				}
//-------------------------------------------------------------
			
		
	
break;
case 4:
$clas=$_POST['class12'];
//echo $clas;
$sel="select * from subclass where classname='$clas'";
$res=mysqli_query($conn,$sel);
echo "<option>--select--</option>";
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
	echo "<option>".$row['subclass']."</option>";
}
break;
case 100:
$name=$_POST['name'];
$email=$_POST['email'];
$mobile=$_POST['mobile'];
$address=$_POST['address'];
$position=$_POST['position'];
$gender=$_POST['gnd'];
$date=date("d/m/Y");
$imgname=$_FILES['picture']['name'];
//echo"$imgname";
$size=$_FILES['picture']['size'];
//echo"$size";
$type=$_FILES['picture']['type'];
//echo"$type";
$tempname=$_FILES['picture']['tmp_name'];
//echo"$tempname";
$pathinfo=pathinfo($imgname,PATHINFO_EXTENSION);
  //echo"$pathinfo";
  if($pathinfo!=""|| $pathinfo!=null)
  {
	  $newimgname=time()."_".$name.".".$pathinfo;
	  //echo$newimgname;
  }
  else
  {
	  $newimgname="";
  }
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$location="img/";

	$ins="insert into  resume(name,email,position,mobile,address,resume,date,time,gender) values('$name','$email','$position','$mobile','$address','$newimgname','$date','$time','$gender')";
				if(mysqli_query($conn,$ins))
				{
					move_uploaded_file($tempname,$location.$newimgname);
					echo 'Your Request Send ';
				}
				else
				{
				    echo 'not send';
				}
break;

case 101:
$book=$_POST['book'];
$adm=$_POST['adm'];
echo $name=$_POST['name'];
$mother=$_POST['mother'];
$gender=$_POST['gender'];
$adhar=$_POST['adhar'];
$caste=$_POST['caste'];
$con=$_POST['con'];
$ncc=$_POST['ncc'];
$cut=$_POST['cut'];
$promotion=$_POST['promotion'];
$reason=$_POST['reason'];
$paid=$_POST['paid'];
$conduct=$_POST['conduct'];
$renew=$_POST['renew'];
$father=$_POST['father'];
$dob=$_POST['dob'];
$hdob=$_POST['hdob'];
$status=$_POST['status'];
$sub=$_POST['sub'];
$class=$_POST['class'];
$class_h=$_POST['class_h'];
$result=$_POST['result'];
$present=$_POST['present'];
$school_p=$_POST['school_p'];
$govt=$_POST['govt'];
$remark=$_POST['remark'];
$issue=$_POST['issue'];
echo  $reg_id=$_POST['reg_id'];

$date=date("d/m/Y");

date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$location="img/";
$sel12="select * from tc where reg_id='$reg_id'";
				$res12=mysqli_query($conn,$sel12);
				$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
				if($row12)
				{
			$up="update tc set book='$book', adm='$adm', name='$name', mother='$mother', gender='$gender', adhar='$adhar', caste='$caste', con='$con', ncc='$ncc', cut='$cut', promotion='$promotion', reason='$reason', paid='$paid', conduct='$conduct', renew='$renew', father='$father', dob='$dob', hdob='$hdob', status='$status', sub='$sub', class='$class', class_h='$class_h', result='$result', present='$present', school_p='$school_p', govt='$govt', remark='$remark', issue='$issue', date='$date' where reg_id='$reg_id'";
				mysqli_query($conn,$up);
				echo 'Tc Update Success ';
				}
				else
				{
			$ins="INSERT INTO `tc` ( `book`, `adm`, `name`, `mother`, `gender`, `adhar`, `caste`, `con`, `ncc`, `cut`, `promotion`, `reason`, `paid`, `conduct`, `renew`, `father`, `dob`, `hdob`, `status`, `sub`, `class`, `class_h`, `result`, `present`, `school_p`, `govt`, `remark`, `issue`, `date`, `reg_id`) VALUES ('$book', '$adm', '$name', '$mother', '$gender', '$adhar', '$caste', '$con', '$ncc', '$cut', '$promotion', '$reason', '$paid', '$conduct', '$renew', '$father', '$dob', '$hdob', '$status', '$sub', '$class', '$class_h', '$result', '$present', '$school_p', '$govt', '$remark', '$issue', '$date','$reg_id')";
				if(mysqli_query($conn,$ins))
				{
					
					echo 'Tc Create Success ';
				}
				else
				{
				    echo 'not Add Please Try Again';
				}
				}
	
break;
}

?>