GenMatricNoPG

<?php

echo "Hello World!\n";function genMatricpg(){	
    $prog_type=array('Postgraduate Diploma','Masters','Doctorate');
	$tno=0;
	$faculties=array("Sciences","Basic Medical Sciences","Clinical Sciences","Dentistry","Nursing Science","Medical Rehabilitation","Allied Health Sciences","Public Health");
    $startno=3431;
	foreach($prog_type as $prog){
        $sql=resultnewspgs("SELECT regno, UCASE(surname), UCASE(onames), state, lg, sex, dob, faculty, dept, title FROM spgsportal_pgschooldb.admitted_2022 WHERE programme='$prog' AND regno IN (SELECT matricno FROM unimed5_unimedportaldb.paymentinvoice WHERE feetype='UNIMED SPGS SCHOOL FEE' AND session='2021/2022' AND feestatus='PAID') ORDER BY faculty, dept, surname, onames");
//        $startno=matricStartId($prog);
        while($rec=mysqli_fetch_array($sql)){
            $ckey=deptcodepg($rec['dept']);
            $matno=$ckey.'/21/'.sprintf("%04d",$startno);
            $age=intval(date('Y', time() - strtotime($rec[6]))) - 1970;
            $val=array($rec[0],$matno,addslashes($rec[1]),addslashes($rec[2]),$rec[3],$rec[4],$rec[5],$rec[6],$age,$prog,$rec[7],$rec[8],$startno);
				inputpg($val,"matric_table_pg");
				$startno+=1;
				$tno+=1;
		}

	}

	return $tno;
}