One Hat Cyber Team

View File Name : assign_stud_reg_no2.php

<?
include("inc/header.php");

//include("inc/fxn.php");
include "inc/config_essay.php"; 

?>
<?
$stud_id=$_GET['stud_id'];

$reg=mysql_query("SELECT * FROM reg_profile WHERE stud_id='$stud_id'");
if(!$reg){echo mysql_error(); }
$row=mysql_fetch_array($reg);
//$row=GetMany("reg_profile",$stud_id,"stud_id");
$surname=$row['surname'];
$othernames=$row['othernames'];
$names=explode(" ",$othernames);
$firstname=$names[0];
$lastname=$names[1];

$dob=$row['dob'];
$grade='1';
$nationality="Nigerian";
$contact=$row['address'];
$phone=$row['phone'];
$email=$row['email'];
$branch=$row['branch_id'];
$deregister="No";
$fullnames="$surname $othernames";

$last_stud_no=getLastStudentMember();
//echo "$last_stud_no<br>";
//echo stripFirst($last_stud_no);
if($last_stud_no[1]=="/"){
$break=explode("/",$last_stud_no);
$lastregno=$break[1];
}
else{
	$break=explode("/",$last_stud_no);
$lastregno=$break[0];
$lastregno=substr($lastregno,1);
}
//echo $lastregno;
$lastregno=$lastregno + 1;
$nseregno="S".$lastregno."/12";
if(checkNseregno($nseregno)){
		echo "NSE Reg NO Exists";
	include("inc/footer.php");

die();
}
else{
//echo $nseregno;
//updateRegprofile($stud_id,$nseregno);
include "inc/config_essay.php";
$rs=mysql_query("UPDATE reg_profile SET nseregno='$nseregno',regno_assign='1' WHERE stud_id='$stud_id'");

include "inc/config_nsemem.php";
$membership=mysql_query("INSERT INTO nsemem SET nseregno='$nseregno',lastname='$surname',firstname='$firstname',middlename='$lastname',dob='$dob',grade='$grade',nationalty='$nationality',contactaddr='$contact',mobilephone='$phone',email='$email',branch='$branch',deregister='No'");

$payment=mysql_query("INSERT INTO payitem_amount SET nseregno='$nseregno'");
if($payment){
			$str = "ADMISSION TO STUDENT AFFILIATION";
			$html_data='<html><head><title>'.$str.'</title></head><body>
<table width="639" border="0" align="center" cellpadding="5" cellspacing="0">
  <tr>
    <td align="center"><img src="logo.jpg" width="120" height="91" alt="logo" /></td>
  </tr>
  <tr>
    <td><p>'.$fullnames.'</p>
    <p>'.$contact.'</p>
    <p>Dear Student Member,</p>
    <p><strong><U>ADMISSION INTO STUDENT AFFILIATE</U></strong></p>
    <div>Please accept my very hearty congratulations on the event of your  admission as a Student Member of the Nigerian Society of Engineers. </div>
    <div> </div>
    <div><strong> </strong></div>
    <div><strong>Your reference Number is  '.$nseregno.'</strong>, which  henceforth should be quoted as your reference in subsequent correspondence with  this office.</div>
    <div> </div>
    <div>We hereby acknowledge your payment of the <strong>N1000.00</strong> for your Student Membership Application. Your annual subscription  of <strong>N500</strong> becomes due on the <strong>1st of July of each year</strong>, in  accordance with articles 19 and 20 of the Articles of Association of the  Society. Payment can also be made through our Account with <strong>First Bank No. 2020502052</strong>, sort code<strong> 011150000,</strong> Maitama Branch, Abuja. </div>
    <div> </div>
    <div>Your Membership Material (NSE Face Cap) will be made available to  you through the NUESA Office in your school. You can also download the NSE  Membership Guidelines at </div>
    <div> </div>
    <div>We sincerely look forward to your active participation in the  Societies activities at the Branch and National Levels.</div>
    <div> </div>
    <div>
      <p>Yours  faithfully, </p>
      <div><strong>Maureen Onah,FCAI </strong></div>
      <div><strong>Membership Services Officer</strong></div>
      <p>&nbsp;</p>
    </div>
    <p>&nbsp;</p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
</body></html>';
	include("mimemail/MIME.class");
$mime = new MIME_mail("info@nse.org.ng", $email, $str);
$mime->attach($html_data, "", HTML, BASE64);
$mime->send_mail();
	
}
if($mime){
	echo "Number Successfully Assigned";
	header("refresh: 2; url=assign_stud_reg_no2.php");
	}
else{
	echo mysql_error();
}
}

function getLastStudentMember(){
	include("inc/config_nsemem.php"); 
	$result=mysql_query("SELECT nseregno FROM nsemem WHERE grade='1' ORDER BY id DESC");
	$row=mysql_fetch_array($result);
	return $row['nseregno'];
}
/*function GetMany($table,$value,$field){
	$result=mysql_query("SELECT * FROM $table WHERE $field='$value'");
	$row=mysql_fetch_array($result);
	return $row;
}*/
/*function GetMany ($table, $value, $where) {
include "config.php";
$query = "SELECT *
	FROM $table
	WHERE $where='$value'
	LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num = mysql_num_rows($result);

return $row;
}*/
function checkNseregno($nseregno){
	$result=mysql_query("SELECT id FROM nsemem WHERE nseregno='$nseregno'");
	return mysql_num_rows($result);
}

	

?>
<? include("inc/footer.php"); ?>