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 ,student.FPHOTOPATH from mcverify,degree,student
where degree.FDEGREE = mcverify.FDEGREE and degree.FEXAMNO = mcverify.FEXAMNO and student.FREGNO = mcverify.FREGNO
and mcverify.FREGNO='{$v1}' and mcverify.FEXAMNO='{$v2}' and mcverify.FYEAR='{$v3}' and mcverify.FEXAMTYPE='{$v4}'";
$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'];
$PHOTOPATH = $row['FPHOTOPATH'];
}
}
?>
| Degree |
: |
| Semester |
: |
| Examination |
: |
| Roll No. |
: |
| Registration No. |
: |
| Name |
: |
| Total Marks |
: |
| Result |
: |
| M.C. Number |
: |