Android อยากจะสอบถามเรื่อง /*** Check Exists ***/ ในส่วนของที่ติดต่อไปยังไฟล์ PHP

	/*** Check Iemi Exists ***/
	$strSQL = "SELECT * FROM student WHERE Idstudent = '".$strIdstudent."' and Iemi= '".$strIemi."'";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	if($objResult)
	{
		$arr['StatusID'] = "1"; 
		$arr['Error'] = "Iemi Exists!";	
		echo json_encode($arr);
		
	}
	
	else
	{
		$arr['StatusID'] = "0"; 
		$arr['Error'] = "อีมี้ไม่ตรงกับการสมัคร !";	
		echo json_encode($arr);
		exit();
	
	}
	

/*** Check Idstudent Exists ***/
	$strSQL = "SELECT * FROM student_sub WHERE Idstudent = '".$strIdstudent."' and Idsubject = '".$strIdsubject."'and Section = '".$strSection."'and term = '".$strterm."'and year = '".$stryear."'";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	if($objResult)
	{
		$arr['StatusID'] = "1"; 
		$arr['Error'] = "strIdstudent Exists!";	
		echo json_encode($arr);
		
	}
	
	else
	{
		$arr['StatusID'] = "0"; 
		$arr['Error'] = "ไม่มีข้อมูลการลงทะเบียนในรายวิชานี้ !";	
		echo json_encode($arr);
	    exit();
	
	}

 <?php

header('Content-Type: text/html; charset=utf-8');

    $objConnect = mysql_connect("localhost","root","root");
	$objDB = mysql_select_db("web84db1");
	mysql_query("SET NAMES UTF8");
	("SET NAMES 'utf8' COLLATE 'utf8_general_ci';");
date_default_timezone_set('Asia/Bangkok'); 
$CreateDate=date("Y-m-d H:i:s"); 
	/*** for Sample 
		$_POST["sUsername"] = "a";
		$_POST["sPassword"] = "b";
		$_POST["sName"] = "c";
		$_POST["sEmail"] = "d";
		$_POST["sTel"] = "e";
	*/

	$strIdstudent = $_POST["sIdstudent"];
	$strName = $_POST["sName"];
	$strLastname = $_POST["sLastname"];
	$strLatitude = $_POST["sLatitude"];
	$strLongitudel = $_POST["sLongitudel"];
    $strIdsubject = $_POST["textView1"];
	$strIdteacher = $_POST["textView2"];
	$strDatesub = $_POST["textView3"];
	$strIemi = $_POST["textView4"];
	$strNumber = $_POST["textView6"];
	$strSection = $_POST["textView5"];
	$strterm = $_POST["textView10"];
	$stryear = $_POST["textView11"];
	
	
	
	
	
	/*** Check Iemi Exists ***/
	$strSQL = "SELECT * FROM student WHERE Idstudent = '".$strIdstudent."' and Iemi= '".$strIemi."'";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	if($objResult)
	{
		$arr['StatusID'] = "1"; 
		$arr['Error'] = "Iemi Exists!";	
		echo json_encode($arr);
		
	}
	
	else
	{
		$arr['StatusID'] = "0"; 
		$arr['Error'] = "อีมี้ไม่ตรงกับการสมัคร !";	
		echo json_encode($arr);
		exit();
	
	}
	
	
	
	
	

/*** Check Idstudent Exists ***/
	$strSQL = "SELECT * FROM student_sub WHERE Idstudent = '".$strIdstudent."' and Idsubject = '".$strIdsubject."'and Section = '".$strSection."'and term = '".$strterm."'and year = '".$stryear."'";
	$objQuery = mysql_query($strSQL);
	$objResult = mysql_fetch_array($objQuery);
	if($objResult)
	{
		$arr['StatusID'] = "1"; 
		$arr['Error'] = "strIdstudent Exists!";	
		echo json_encode($arr);
		
	}
	
	else
	{
		$arr['StatusID'] = "0"; 
		$arr['Error'] = "ไม่มีข้อมูลการลงทะเบียนในรายวิชานี้ !";	
		echo json_encode($arr);
	    exit();
	
	}

	
	


	
	/*** Insert ***/
	$strSQL = "INSERT INTO memberscan (Idstudent,Name,Lastname,Latitude,Longitudel,Idsubject,Idteacher,Datesub,term,year,Section,Iemi,Number,CreateDate) 
		VALUES (
			'".$strIdstudent."',
			'".$strName."',
			'".$strLastname."',
			'".$strLatitude."',
			'".$strLongitudel."',
		    '".$strIdsubject."',
			'".$strIdteacher."',
			'".$strDatesub."',
			'".$strterm."',
			'".$stryear."',
			'".$strSection."',
			'".$strIemi."',
			'".$strNumber."',
			'".$CreateDate."'
		
			
			)
		";

	$objQuery = mysql_query($strSQL);
	if(!$objQuery)
	{
		$arr['StatusID'] = "0"; 
		$arr['Error'] = "Cannot save data!";	
	}
	else
	{
		$arr['StatusID'] = "1"; 
		$arr['Error'] = "";	
	}

	/**
		$arr['StatusID'] // (0=Failed , 1=Complete)
		$arr['Error'] // Error Message
	*/
	
	mysql_close($objConnect);
	
	echo json_encode($arr);

?>