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;

}