<?php

	session_start();				
$flag=$_REQUEST['flag'];
include('../link/databaseconnection.php');
switch($flag)
{
	case 1:
	

$name=$_POST['name'];
$adhar=$_POST['adhar'];
$mediam=$_POST['mediam'];
//echo"$name";
//echo"<br/>";
$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";
$dob1=$_POST['dob'];
//echo"$dob";
$dob=date("d-m-Y",strtotime($dob1));

$class=$_POST['class'];
//echo"$class";
$mother=$_POST['mother'];
//echo"$mother";


//echo"$high1";


$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";
$citym=$_POST['city'];
//echo"$city";
$city= strtoupper($citym);
$city1=$_POST['city1'];
//echo"$city";
$villagem=$_POST['village'];
$village= strtoupper($villagem);
//echo"$village";
$village1=$_POST['village1'];
//echo"$village1";
$postofficem=$_POST['postoffice'];
//echo"$postoffice";
$postoffice= strtoupper($postofficem);
$postoffice1=$_POST['postoffice1'];
//echo"$postoffice1";
$distm=$_POST['dist'];
//echo"$dist";
$dist= strtoupper($distm);
$dist1=$_POST['dist1'];
//echo"$dist1";
$statem=$_POST['state'];
//echo"$state";
$state= strtoupper($statem);
$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;
$selmatch="select * from registration order by id desc";
$resmatch=mysqli_query($conn,$selmatch);
$rowmatch=mysqli_fetch_array($resmatch,MYSQLI_BOTH);
$appmatch=$rowmatch['application'];
//echo $appmatch;

if($name!='' and $father!='' and $mother!='' and $class!='' and $village!=''and $dist!=''and $mobile!='')
{
if($size>=1 && $size<=70)
{
	if($type=="image/png" || $type=="image/jpg" || $type=="image/jpeg")
	{
		
			
//--------------------------------------------------------------------
				
				$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,signature,action,action1,action2,action3,code,caste,minority,trans,tra) 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','','','','','','','','','','')";
				if(mysqli_query($conn,$ins))
				{
					move_uploaded_file($tempname,$location.$newimgname);
					
					//----
							//-----admitcard10---
					
					//-----
					$_SESSION['user']=$app;
					echo"Submit";
				
					
				}
				else
				{
					echo"not insert";
				}
				
//-------------------------------------------------------------
			
		
	}
	else
	{
		echo"Upload Picture jpg,jpeg,png";
	}
}
else
{
	echo"Picture Upload 1kb to 70kb";
}
}
else
{
	echo"Please Fillup require box";
}

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;
}

?>