<?php 

include "dbconfig.php";
$croll_on=$_POST['croll_on'];

$sname=$_POST['sname'];

$fname=$_POST['fname'];

$subject=$_POST['subject'];

$vdate=$_POST['vdate'];

$vtime=$_POST['vtime'];

$class=$_POST['class'];

$gender=$_POST['gender'];

$user_name=$_POST['user_name'];

$ex_form_no=$_POST['ex_form_no'];

$no=1;

$counter=$_POST['counter'];

$ckbb=isset($ckbb);

$ckbb=$_POST['ckbb'];

$register_no=$_POST['register_no'];



$slist=$_POST['slist'];$slist=isset($slist);$slistt = implode(",",$_POST['slist']);



if($total_found2==""){



	$ins_qry_cpr="INSERT INTO `fverify` (`croll_on`, `ex_form_no`, `sname`, `fname`, `subject`, `vdate`, `vtime`, `class`, `gender`, `user_name`, `no`, `counter`, `class_app_list_new`, `register_no`,`code`,`session`) VALUES ('$croll_on', '$ex_form_no', '$sname', '$fname', '$subject', '$vdate', '$vtime', '$class', '$gender', '$user_name', '$no', '$counter', '$subject', '$register_no','$code','$session');";

	$retval_challan = mysql_query($ins_qry_cpr);
	}
$check_exist_qry3="select * from fverify where croll_on='$croll_on' and session='$session' and code='$code'";
$run_qry3=mysql_query($check_exist_qry3);
$total_found3=mysql_num_rows($run_qry3);
if($total_found3!=""){
////////////////////
 $check_exist_qry21="select * from class2 where college_roll='$croll_on' and session='$session' and code='$code'";
$run_qry21=mysql_query($check_exist_qry21);

$total_found21=mysql_num_rows($run_qry21);

$row21 = mysql_fetch_array($run_qry21, MYSQL_BOTH);
$college=$row21['college'];
$queryyo = "SELECT * FROM college_info where code='$college' and code='$code'";

$numresultsyo=mysql_query($queryyo);

$resultyo= mysql_query($queryyo) or die("Couldn't execute query");

$a_rowwo = mysql_fetch_row( $resultyo );
?>

<center><table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:2px #990000 solid; height:270px; width:800px; background-image:url(water_mark.png); background-repeat:repeat;">

  <tr>

    <td><table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:none">

      <tr>

        

        <td width="100%" style="border:none"><table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td><div align="left" style="float:left; width:90px;"><img src="../<?php echo $a_rowwo['4']; ?>" height="80" width="80" align="right"></div></td>

    <td><div align="center" style="font-family:'Times New Roman', Times, serif; font-size:28px; font-weight:bold; margin:0px; padding:0px; "><?php echo $a_rowwo['2']; ?> ( <?php echo $a_rowwo['1']; ?>)<br><p align="center" style="font:'Times New Roman', Times, serif; font-size:16px;"><?php echo $a_rowwo['3']; ?></p></div></td>

    <td align="right"><img src="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=[Form No :<?php echo $fno.'/'.$college.'/'.$CourseType.'/'.$Course.'/'.$Course_Details.'/'.$session.'/'.$Student_Type; ?>]&choe=UTF-8"  width="112" height="117" style="border:1px #000000 solid"/></td>

  </tr>

</table>

         

          <div align="center"><strong>Examination Form Verification </strong><br />

         </div></td>

      </tr>

    </table></td>

  </tr>

  <tr>

    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">

      

      <tr>

        <td width="18%"><strong>College Roll Number</strong></td>

        <td width="24%"><span class="style3"><?php echo $croll_on; ?></span></td>

        <td width="24%"><strong>Examination Form Number</strong></td>

        <td width="34%"><span class="style3"><?php echo $ex_form_no; ?></span></td>
      </tr>

      <tr>

        <td><strong>Student Name</strong></td>

        <td><span class="style3"><?php echo $sname; ?></span></td>

        <td>Register Roll Number</td>

        <td><span class="style3"><?php echo $register_no; ?></span></td>
        </tr>

      <tr>

        <td><strong>Class</strong></td>

        <td><span class="style3"><?php 

																	

																	$Course=$row21['Course'];

																	$queryy = "SELECT * FROM course_name where id='$Course' and session='$session' and code='$code'";

$numresultsy=mysql_query($queryy);

$resulty= mysql_query($queryy) or die("Couldn't execute query");

 ?>

	 <?php

while ( $a_roww = mysql_fetch_row( $resulty ) )

 {?>

                 

                  

                 <?php echo $a_roww[1];?>

                  <?php } ?>



( <?php echo $row21['Course_Details']; ?>)</td>

        <td><strong>Father Name</strong></td>

        <td><span class="style3"><?php echo $fname; ?></span></td>
      </tr>

      <tr>

        <td><strong>Subject</strong></td>

        <td ><span class="style3"><?php echo $subject; ?></span></td>

         <td><strong>Gender</strong></td>

         <td><?php echo $gender; ?></td>
      </tr>

      <tr>

        <td><strong>Verification Date</strong></td>

        <td><span ><span class="style3"><?php echo $vdate; ?></span></span></td>

        <td><strong>Verification Time</strong></td>

        <td><span class="style3"><?php echo $vtime; ?></span></td>
        </tr>

      <tr>

        <td><strong>UIN</strong></td>

        <td ><?php echo $row21['uid']; ?></td>

        <td ><strong>Mobile</strong></td>

        <td ><?php echo $row21['MobileNO']; ?></td>
      </tr>
      <tr>
        <td><strong>DOB</strong></td>
        <td ><?php echo $row21['txt_dob']; ?></td>
        <td ><strong>Verification Counter Name</strong></td>
        <td ><?php echo $counter; ?></td>
      </tr>

      
      <tr>

        <td colspan="4"><p>&nbsp;</p>

          <p align="right"><strong>Signature Form Verification Officer </strong></p></td>
        </tr>

    </table></td>

  </tr>

  

</table><br />

<a href="Student_veryfication.php" style="font-size:16px;" >Click Here to Back</a></center>
<?php }else{?>
<h1>Records Not Found.................?</h1>

<?php } ?>