1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org / jay /
Filename : forall_ajax.php
back
<?php
include("../Connecter/dataconn.php");

$id = $_POST['id'];
$action = $_POST['action'];
$tab = $_POST['tab'];
$ses = $_POST['ses'];


// unsuspend or unexpel record	
if($action=='good'){
	
	$a1=$id;	
	$sqlwork="update tempstudents set status='good' where sn = $a1";
	$work=@mysql_query($sqlwork);

	$sqlwork="select * from tempstudents where sn = $a1";
	$rework=@mysql_query($sqlwork);
	$rowwork=mysql_fetch_array($rework);

	$sqlwork="delete from studentsexisting where matric = '".$rowwork['matric']."' and session>'".$rowwork['session']."'";
	$work=@mysql_query($sqlwork);

	//Begin of register courses
		$mat2=$rowwork['matric'];
		
		$adeprogid=$rowwork['programmesn'];
		$adesession=$rowwork['session'];
		$adelevel=$rowwork['level'];
		$adede=$rowwork['de'];
		
		//Go through registered courses for all
		$query_vin = "SELECT *,r.sn as dsn,t.sn as dcode FROM coursesregisteredall as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$adeprogid and t.session='$adesession' and t.level=$adelevel and t.de='$adede'";
		$vin = mysql_query($query_vin, $csn) or die(mysql_error());
		$num_vin=mysql_num_rows($vin);
		//if any exists
		if($num_vin>0){
			while($row_vin=mysql_fetch_array($vin)){
				$a1=$row_vin['dcode'];
				
				$sqlwork2="select * from coursesregistered where coursesn=$a1 and matric='$mat2'";
				$work2=mysql_query($sqlwork2);
				$num_work3=mysql_num_rows($work2);
				if($num_work3==0){
					$sql="insert into coursesregistered (coursesn,matric,archived) values ($a1,'$mat2','No')";	
					$result=@mysql_query($sql);
				}
				
				
			}
		}
	//End of register courses
}
// End of unsuspend or unexpel record	











// suspend record	
if($action=='suspend'){
	$a1=$id;	
$sqlwork="update tempstudents set status='suspend' where sn = $a1";
$work=@mysql_query($sqlwork);

$sqlwork="select * from tempstudents where sn = $a1";
$rework=@mysql_query($sqlwork);
$rowwork=mysql_fetch_array($rework);

$sqlwork="delete from studentsexisting where matric = '".$rowwork['matric']."' and session>'".$rowwork['session']."'";
$work=@mysql_query($sqlwork);

//Begin of Delete of registered courses from session onwards
$mat2=$rowwork['matric'];		
		$adeprogid=$rowwork['programmesn'];
		$adesession=$rowwork['session'];
		$adede=$rowwork['de'];
		
$sqlcourse="select * from coursestobetaken where programmesn=$adeprogid and session>='$adesession' and de='$adede'";
$recourse = mysql_query($sqlcourse, $csn) or die(mysql_error());
while($rowcourse=mysql_fetch_array($recourse)){
	$sqlwork="delete from coursesregistered where matric = '".$mat2."' and coursesn=".$rowcourse['sn'];
	$work=mysql_query($sqlwork) or die(mysql_error());
}
//End of Delete of registered courses from session onwards	
}
// End of suspend record






// expel record	
if($action=='expel'){
	$a1=$id;	
$sqlwork="update tempstudents set status='expel' where sn = $a1";
$work=@mysql_query($sqlwork);

$sqlwork="select * from tempstudents where sn = $a1";
$rework=@mysql_query($sqlwork);
$rowwork=mysql_fetch_array($rework);

$sqlwork="delete from studentsexisting where matric = '".$rowwork['matric']."' and session>'".$rowwork['session']."'";
$work=@mysql_query($sqlwork);

//Begin of Delete of registered courses from session onwards
$mat2=$rowwork['matric'];		
		$adeprogid=$rowwork['programmesn'];
		$adesession=$rowwork['session'];
		$adede=$rowwork['de'];
		
$sqlcourse="select * from coursestobetaken where programmesn=$adeprogid and session>='$adesession' and de='$adede'";
$recourse = mysql_query($sqlcourse, $csn) or die(mysql_error());
while($rowcourse=mysql_fetch_array($recourse)){
	$sqlwork="delete from coursesregistered where matric = '".$mat2."' and coursesn=".$rowcourse['sn'];
	$work=mysql_query($sqlwork) or die(mysql_error());
}
//End of Delete of registered courses from session onwards
}
// End of expel record




echo("");


?>