1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : searchstringer.php
back
<?php
$att="dob";

$searchstring="Birthday Anniversary";

if($_POST['valbir']=="mo"){
$added=$added . " and month(" . $att . ") = " . $_POST['mobir'];
if($_POST['mobir']==1){
$searchstring=$searchstring . " for the month of January";
}
if($_POST['mobir']==2){
$searchstring=$searchstring . " for the month of February";
}
if($_POST['mobir']==3){
$searchstring=$searchstring . " for the month of March";
}
if($_POST['mobir']==4){
$searchstring=$searchstring . " for the month of April";
}
if($_POST['mobir']==5){
$searchstring=$searchstring . " for the month of May";
}
if($_POST['mobir']==6){
$searchstring=$searchstring . " for the month of June";
}
if($_POST['mobir']==7){
$searchstring=$searchstring . " for the month of July";
}
if($_POST['mobir']==8){
$searchstring=$searchstring . " for the month of August";
}
if($_POST['mobir']==9){
$searchstring=$searchstring . " for the month of September";
}
if($_POST['mobir']==10){
$searchstring=$searchstring . " for the month of October";
}
if($_POST['mobir']==11){
$searchstring=$searchstring . " for the month of November";
}
if($_POST['mobir']==12){
$searchstring=$searchstring . " for the month of December";
}

}





if($_POST['valbir']=="da"){
$added=$added . " and month(" . $att . ") = " . $_POST['birmo'] . " and dayofmonth(" . $att . ") = " . $_POST['birda'];
if($_POST['birmo']==1){
$searchstring=$searchstring . " for the month of January " . $_POST['birda'];
}
if($_POST['birmo']==2){
$searchstring=$searchstring . " for the month of February " . $_POST['birda'];
}
if($_POST['birmo']==3){
$searchstring=$searchstring . " for the month of March " . $_POST['birda'];
}
if($_POST['birmo']==4){
$searchstring=$searchstring . " for the month of April " . $_POST['birda'];
}
if($_POST['birmo']==5){
$searchstring=$searchstring . " for the month of May " . $_POST['birda'];
}
if($_POST['birmo']==6){
$searchstring=$searchstring . " for the month of June " . $_POST['birda'];
}
if($_POST['birmo']==7){
$searchstring=$searchstring . " for the month of July " . $_POST['birda'];
}
if($_POST['birmo']==8){
$searchstring=$searchstring . " for the month of August " . $_POST['birda'];
}
if($_POST['birmo']==9){
$searchstring=$searchstring . " for the month of September " . $_POST['birda'];
}
if($_POST['birmo']==10){
$searchstring=$searchstring . " for the month of October " . $_POST['birda'];
}
if($_POST['birmo']==11){
$searchstring=$searchstring . " for the month of November " . $_POST['birda'];
}
if($_POST['birmo']==12){
$searchstring=$searchstring . " for the month of December " . $_POST['birda'];
}
}



if($_POST['valbir']=="tod"){
$added=$added . " and month(" . $att . ") = month(curdate()) and dayofmonth(" . $att . ") = dayofmonth(curdate())";
$searchstring=$searchstring . " for Today";
}




if($_POST['anbir']=="" || !is_numeric($_POST['anbir'])){ $_POST['anbir']='20'; }	
	if($_POST['valbir']=="equal"){
$added=$added . " and (year(curdate()) - year(" . $att . ")) - (right(current_date(),5)<right(".$att.",5)) = " . $_POST['anbir'];
$searchstring="Celebrating " . $_POST['anbir'] . " years of " . $searchstring;
	}
	if($_POST['valbir']=="greater"){
$added=$added . " and (year(curdate()) - year(" . $att . ")) - (right(current_date(),5)<right(".$att.",5)) > " . $_POST['anbir'] . " and " . $att . "<>0";
$searchstring="Celebrating greater than " . $_POST['anbir'] . " years of " . $searchstring;
	}
	if($_POST['valbir']=="less"){
$added=$added . " and (year(curdate()) - year(" . $att . ")) - (right(current_date(),5)<right(".$att.",5)) < " . $_POST['anbir'];
$searchstring="Celebrating less than " . $_POST['anbir'] . " years of " . $searchstring;
	}





if($_POST['valbir']=="anbtw"){
if($_POST['anbira']!="" && $_POST['anbirb']!="" && is_numeric($_POST['anbira']) && is_numeric($_POST['anbirb'])){ 
	
$added=$added . " and (year(curdate()) - year(" . $att . ")) - (right(current_date(),5)<right(".$att.",5)) between " . $_POST['anbira'] . " and " . $_POST['anbirb'];
$searchstring="Age between " . $_POST['anbira'] . " and " . $_POST['anbirb'];

}
}



if($_POST['biryea']=="" || !is_numeric($_POST['biryea'])){ $_POST['biryea']=date('Y'); }	
	if($_POST['valbir']=="equal4"){
$added=$added . " and year(" . $att . ") = " . $_POST['biryea'];
$searchstring="Born in " . $_POST['biryea'];
	}
	if($_POST['valbir']=="greater4"){
$added=$added . " and year(" . $att . ") > " . $_POST['biryea'] . " and " . $att . "<>0";
$searchstring="Born after " . $_POST['biryea'];
	}
	if($_POST['valbir']=="less4"){
$added=$added . " and year(" . $att . ") < " . $_POST['biryea'] . " and " . $att . "<>0";
$searchstring="Born before " . $_POST['biryea'];
	}















if($_POST['valbir']=="moy"){
	if($_POST['biryea3']=="" || !is_numeric($_POST['biryea3'])){ $_POST['biryea3']=date('Y'); }
$added=$added . " and month(" . $att . ") = " . $_POST['birmo3'] . " and year(" . $att . ") = " . $_POST['biryea3'];
if($_POST['birmo3']==1){
$searchstring=$searchstring . " in January " . $_POST['biryea3'];
}
if($_POST['birmo3']==2){
$searchstring=$searchstring . " in February " . $_POST['biryea3'];
}
if($_POST['birmo3']==3){
$searchstring=$searchstring . " in March " . $_POST['biryea3'];
}
if($_POST['birmo3']==4){
$searchstring=$searchstring . " in April " . $_POST['biryea3'];
}
if($_POST['birmo3']==5){
$searchstring=$searchstring . " in May " . $_POST['biryea3'];
}
if($_POST['birmo3']==6){
$searchstring=$searchstring . " in June " . $_POST['biryea3'];
}
if($_POST['birmo3']==7){
$searchstring=$searchstring . " in July " . $_POST['biryea3'];
}
if($_POST['birmo3']==8){
$searchstring=$searchstring . " in August " . $_POST['biryea3'];
}
if($_POST['birmo3']==9){
$searchstring=$searchstring . " in September " . $_POST['biryea3'];
}
if($_POST['birmo3']==10){
$searchstring=$searchstring . " in October " . $_POST['biryea3'];
}
if($_POST['birmo3']==11){
$searchstring=$searchstring . " in November " . $_POST['biryea3'];
}
if($_POST['birmo3']==12){
$searchstring=$searchstring . " in December " . $_POST['biryea3'];
}
}














if($_POST['biryea2']=="" || !is_numeric($_POST['biryea2'])){ $_POST['biryea2']=date('Y'); }	
$xx=str_pad($_POST['birmo2'], 2, '0', STR_PAD_LEFT);
$vv=str_pad($_POST['birda2'], 2, '0', STR_PAD_LEFT);	
	$backpain=$_POST['biryea2'] ."-". $xx ."-". $vv;
	
	if($_POST['valbir']=="equal2"){
$added= $added . ' and ' . $att . " = '".$backpain."'";
$searchstring="Born on " . $backpain;
	}
	if($_POST['valbir']=="greater2"){
$added= $added . ' and ' . $att . " > '".$backpain."'" . " and " . $att . "<>0";
$searchstring="Born after " . $backpain;
	}
	if($_POST['valbir']=="less2"){
$added= $added . ' and ' . $att . " < '".$backpain."'" . " and " . $att . "<>0";
$searchstring="Born before " . $backpain;
	}
	
	
	
	
	
	
	
	
	
	if($_POST['valbir']=="datbtw"){	
if($_POST['biryea2a']=="" || !is_numeric($_POST['biryea2a'])){ $_POST['biryea2a']=1900; }
if($_POST['biryea2b']=="" || !is_numeric($_POST['biryea2b'])){ $_POST['biryea2b']=date('Y'); }
	
$xxa=str_pad($_POST['birmo2a'], 2, '0', STR_PAD_LEFT);
$vva=str_pad($_POST['birda2a'], 2, '0', STR_PAD_LEFT);	
	$backpaina=$_POST['biryea2a'] ."-". $xxa ."-". $vva;

$xxb=str_pad($_POST['birmo2b'], 2, '0', STR_PAD_LEFT);
$vvb=str_pad($_POST['birda2b'], 2, '0', STR_PAD_LEFT);	
	$backpainb=$_POST['biryea2b'] ."-". $xxb ."-". $vvb;
	

$added= $added . ' and ' . $att . " between '".$backpaina."' and '".$backpainb."'";
$searchstring="Born between " . $backpaina ." and ". $backpainb;
	}
	
	
		


if($searchstring=='Birthday Anniversary'){
	$searchstring='';
} else {
	$ss=$ss . ' AND ' . $searchstring;
}


?>


























































<?php
if($_POST['namer']!=""){
	$added=$added . " and namer like '%" . $_POST['namer'] . "%'";
	$ss=$ss . ", AND Name contains " . $_POST['namer'];
	}
if($_POST['code']!=""){
	$added=$added . " and code like '%" . $_POST['code'] . "%'";
	$ss=$ss . ", AND Course Code contains " . $_POST['code'];
	}
if($_POST['unit']!=""){
	$added=$added . " and unit = '" . $_POST['unit'] . "'";
	$ss=$ss . ", AND Unit is " . $_POST['unit'];
	}
if($_POST['status']!=""){
	$added=$added . " and status = '" . $_POST['status'] . "'";
	$ss=$ss . ", AND Status is " . $_POST['status'];
	}
	


if($_POST['matric']!=""){
	$added=$added . " and matric = '" . $_POST['matric'] . "'";
	$ss=$ss . ", AND Matric Number is " . $_POST['matric'];
	}

if($_POST['surname']!=""){
	$added=$added . " and surname like '%" . $_POST['surname'] . "%'";
	$ss=$ss . ", AND Surname contains " . $_POST['surname'];
	}

if($_POST['firstname']!=""){
	$added=$added . " and firstname like '%" . $_POST['firstname'] . "%'";
	$ss=$ss . ", AND First Name contains " . $_POST['firstname'];
	}	

if($_POST['othernames']!=""){
	$added=$added . " and othernames like '%" . $_POST['othernames'] . "%'";
	$ss=$ss . ", AND Other Name contains " . $_POST['othernames'];
	}

if($_POST['yearofentry']!=""){
	$added=$added . " and yearofentry = '" . $_POST['yearofentry'] . "'";
	$ss=$ss . ", AND Year of Entry is " . $_POST['yearofentry'];
	}





if($_POST['progsn']!=""){
	$added=$added . " and programmesn = '" . $_POST['progsn'] . "'";
	
$sqll="select * from programmes where sn=".$_POST['progsn'];
$resultl = @mysql_query($sqll, $csn);
$rowl = mysql_fetch_assoc($resultl);
$blessing=$rowl['namer'];

$sqll="select * from departments where sn=".$rowl['departmentsn'];
				  $resultl=mysql_query($sqll);
				  $rowl=mysql_fetch_array($resultl);
				  $blessing=$blessing . " [ in ".$rowl['namer']." ]";	
	
	$ss=$ss . ", AND Programme of Study is " . $blessing;
	}






if($_POST['de']!=""){
	if($_POST['de']=="DE"){
	$added=$added . " and de = 'DE'";
	$ss=$ss . ", AND Type of Entry is Direct Entry";
	} else {
	$added=$added . " and de <> 'DE'";
	$ss=$ss . ", AND Type of Entry is Normal Entry";	
	}
	}



if($_POST['allergies']!=""){
	$added=$added . " and allergies like '%" . $_POST['allergies'] . "%'";
	$ss=$ss . ", AND Allergies info contains " . $_POST['allergies'];
	}


		
?>