connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$get_data="select FUNIVCODE,FUNIVNAME,FUNIVADD1,pdf_logo_path
from control";
$result=$conn->query($get_data);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
$FUNIVCODE=$row['FUNIVCODE'];
$FUNIVNAME=$row['FUNIVNAME'];
$FUNIVADD1=$row['FUNIVADD1'];
$pdf_logo_path=$row['pdf_logo_path'];
}
}
$query="select degree.FDESCPN, degree.FEXAMNAME, degree.FEXAMDATE, mcverify.FREGNO, mcverify.FNAME, mcverify.FTOTMARKS,
mcverify.FRESULT, mcverify.FMCNUMBER, mcverify.FENROLL, mcverify.FEXAMDATE from mcverify,degree
where degree.FDEGREE = mcverify.FDEGREE and degree.FEXAMNO = mcverify.FEXAMNO
and mcverify.FREGNO='{$v1}' and mcverify.FEXAMNO='{$v2}' and mcverify.FYEAR='{$v3}'";
$rst=$conn->query($query);
if (mysqli_num_rows($rst) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($rst)) {
$FDESCPN=$row['FDESCPN'];
$FEXAMNAME=$row['FEXAMNAME'];
$FEXAMDATE=$row['FEXAMDATE'];
$FREGNO=$row['FREGNO'];
$FNAME=$row['FNAME'];
$FTOTMARKS=$row['FTOTMARKS'];
$FRESULT=$row['FRESULT'];
$FMCNUMBER=$row['FMCNUMBER'];
$FENROLL=$row['FENROLL'];
$FDESCPN=$row['FDESCPN'];
}
}
?>
Degree :
Semester :
Examination :
Roll No. :
Registration No. :
Name :
Total Marks :
Result :
M.C. Number :