<?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;
}