<?php

	session_start();				
$flag=$_REQUEST['flag'];
include('../link/databaseconnection.php');
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/>";
$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";

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


			
//--------------------------------------------------------------------
	$sel125="select * from registration  order by id desc";
				$res125=mysqli_query($conn,$sel125);
				$row125=mysqli_fetch_array($res125,MYSQLI_BOTH);
				$appl=$row125['application'];
				
				$sel12="select * from registration ";
				$res12=mysqli_query($conn,$sel12);
				$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
						$app12=$row12['application'];
				
		
			
				$ins="INSERT INTO `registration` (`application`, `name`, `fname`, `mname`, `dob`, `gender`, `class`, `session`, `subject`, `ele`, `board`, `year`, `total`, `obtain`, `per`, `grade`, `city`, `village`, `postoffice`, `dist`, `state`, `mobile`, `pincode`, `picture`, `city1`, `village1`, `postoffice1`, `dist1`, `state1`, `mobile1`, `pincode1`, `datetime`, `mediam`, `adhar`, `action`, `action1`, `code`, `minority`, `caste`, `trans`, `tra`, `date`, `time`) VALUES ('$app', '$name', '$father', '$mother', '$dob1', '$gender', '$class', '$session', '$subject', '', '', '', '', '', '', '', '$city', '$village', '$postoffice', '$dist', '$state', '$mobile', '$pincode', '$newimgname', '$city1', '$village1', '$postoffice1', '$dist1', '$state1', '$mobile1', '$pincode1', '$datetime', '$mediam', '$adhar', '', '', '$code', 'HINDU', 'OBC','','','$date','$time')";
	
				if(mysqli_query($conn,$ins))
				{
					move_uploaded_file($tempname,$location.$newimgname);
				
									//----adm
					
								//-----admitcard10---
	
					//-----
					$_SESSION['user']=$app;
					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;
}

?>