<?php

	session_start();				
$flag=$_REQUEST['flag'];
include('../link/databaseconnection.php');
if(!$flag)
			{
				header("location:http://mdsnizamabad.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/>";
$father=$_POST['father'];
//echo"$father";
$mother=$_POST['mother'];
//echo"$mother";
//echo"<br/>";
$app=$_POST['app'];
//echo"$app";
//echo"<br/>";
$whatsapp=$_POST['whatsapp'];
$gender=$_POST['gnd'];
$session=$_POST['session'];
//echo"$gender";
$dob=$_POST['dob'];
//echo"$dob";
//$dob=date("d-m-Y",strtotime($dob1));
$last=$_POST['last'];
$class='';
//echo"$class";
$mother=$_POST['mother'];
//echo"$mother";


//echo"$high1";


$subject=$_POST['group'];
$section=$_POST['section'];
//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($app12!=$app)
				{
				$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,last,whatsapp,action,action1,trans,tra,status,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','$last','$whatsapp','','','','','','$section')";
				if(mysqli_query($conn,$ins))
				{
					move_uploaded_file($tempname,$location.$newimgname);
					
							//-----admitcard10---

					//-----
					$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);
					$_SESSION['user']=$id;
				
						echo"Submit";
						$sel126="select * from convence where code='$code' order by id desc";
				$res126=mysqli_query($conn,$sel126);
				$row126=mysqli_fetch_array($res126,MYSQLI_BOTH);
				
					////msm
					if(!$row126){	
					    $ins12="insert into convence(conv,vill,code,session) values('$code','$village','$code','$session')";
	$res12=mysqli_query($conn,$ins12);}
					$to=$mobile;

					///msm
			
						
				}
				else
				{
					echo"not insert";
				}
				}
				else
				{
					echo "Scholer No. Already Exist plz Use Another Scholer No. ";
				}
//-------------------------------------------------------------
			
		
	
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;
}

?>