<?php include "header.php"; ?>
   
	
    
<div id="page-wrapper">

            <div class="row">
                <!-- Page Header -->
                <div class="col-lg-12">
                    <h1 class="page-header">Verification</h1>
	
    
    <br>
    <br> <?php
		$en=$_POST['en'];$en=htmlentities($en, ENT_QUOTES);
		$feild=$_POST['feild'];$feild=htmlentities($feild, ENT_QUOTES);
		
?>
        <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table table-bordered table-striped">
        <form action="<?php echo $PHP_SELF; ?>" name="date" method="post" >
  
  <tr>
    <td width="7%" >&nbsp;</td>
    <td width="30%"  class="txt_form"><div align="right">Keyword
       <input type="text" name="en" id="en"  style="width:150px" value="<?php echo $en; ?>"  />
    </div></td>
    <td width="56%"  class="txt_form2">Select Feild
     
      <select name="feild" id="feild" style="width:200px">
        <option value="college_roll" <?php if($feild=='college_roll'){?>selected="selected"<?php } ?>>College Roll Number</option>
        <option value="StudentName" <?php if($feild=='StudentName'){?>selected="selected"<?php } ?>>Student Name</option>
        <option value="txt_dob" <?php if($feild=='txt_dob'){?>selected="selected"<?php } ?>>DOB</option>
        <option value="fno" <?php if($feild=='fno'){?>selected="selected"<?php } ?>>Form No</option>
        <option value="datee" <?php if($feild=='datee'){?>selected="selected"<?php } ?>>Date - (YYYY-MM-DD)</option>
        <option value="college" <?php if($feild=='college'){?>selected="selected"<?php } ?>>College Code</option>
        
        <option value="acard" <?php if($feild=='acard'){?>selected="selected"<?php } ?>>Aadhar No</option>
        <option value="MobileNO" <?php if($feild=='MobileNO'){?>selected="selected"<?php } ?>>Mobile No</option>
        <option value="mno2" <?php if($feild=='mno2'){?>selected="selected"<?php } ?>>Mobile No-2</option>
        <option value="txtEmailID" <?php if($feild=='txtEmailID'){?>selected="selected"<?php } ?>>Attachment</option>
         <option value="status" <?php if($feild=='status'){?>selected="selected"<?php } ?>>Un-Lock Students Form</option>
         
      </select>
      
          <input type="submit" name="Submit2" value="Search"  style="width:100px"/>
        <input type="reset" name="Submit" value="Cancel"  style="width:100px"/>
          </div></td>
    <td width="7%" >&nbsp;</td>
  </tr>
  <tr>
    <td >&nbsp;</td>
    <td colspan="2"  ><div align="right" >
      <div align="center"><br> 
        &nbsp;&nbsp;</div>
    </div>      </td>
    <td >&nbsp;</td>
  </tr>
  </form></table>
  
        <table width="100%" border="1" cellspacing="2" cellpadding="2" class="table table-bordered table-striped">
<?php
if($en!=""){
$query = "SELECT * FROM class2 where $feild LIKE '%$en%' and session='$session' and code='$code' order by id";
//$query = "SELECT * FROM class2 where $feild='$en'";
$numresults=mysql_query($query);
$numrowss=mysql_num_rows($numresults);
$result = mysql_query($query) or die("Couldn't execute query");
}

?>
 <?php if($numrowss!=""){?>
  <tr bgcolor="#990000" class="text_white">
    <td width="2%"><div align="center"><span style="text-align: right">No</span></div></td>
    <td width="4%"><div align="center"><span style="text-align: right">Student Picture</span></div></td>
    <td width="4%"><div align="center"><span style="text-align: right">Student Name</span></div></td>
    <td width="4%"><div align="center"><span style="text-align: right">Father Name</span></div></td>
    <td width="4%">Mobile No-1<br />
      ---<br />
      Mobile No-2</td>
    <td width="4%"><div align="center"><span style="text-align: right">CourseType / Course / Year</span></div></td>
    <td width="4%"><div align="center"><span style="text-align: right">Status</span></div></td>
    <td width="4%"><div align="center"><span style="text-align: right">Verification</span></div></td>
    <td width="4%"><div align="center"><span style="text-align: right">Delete Form</span></div></td>
    </tr>
  <?php 
$counter = 1;?>
 <?php
while ( $a_row = mysql_fetch_array( $result ) )
 {?>
 
  <tr>
    <td><div align="center"><?php echo $counter; ?></div></td>
    <td class="img"><img src="../uploads/<?php echo $a_row['class_std_ing'];?>" height="50" width="50" /></td>
    <td><div align="center"><strong><?php echo $a_row['StudentName'];?></strong></div></td>
    <td><div align="center"><strong><?php echo $a_row['FatherName'];?></strong></div></td>
    <td><div align="center"><strong><?php echo $a_row['MobileNO'];?><br/><?php echo $a_row['mno2'];?></strong></div></td>
    <td><div align="center"><strong><?php echo $a_row['CourseType'];?>-
	
	
                                            
                                            <?php 
											$Course=$a_row['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");
 $a_roww = mysql_fetch_row( $resulty );
 ?>
	
	<?php echo $a_roww[1];?>-<?php echo $a_row['Course_Details'];?></strong></div></td>
    <td  <?php if($a_row['status']=='Locked'){?> style="background-color:#006600; color:; font-size:16px" <?php }else{ ?> style="background-color:#FF0000; color:; font-size:16px"  <?php } ?>><div align="center"><strong><?php 
	$st=$a_row['status'];
	if($st==""){
	echo "Un-Lock";
	}else{
	echo $st;
	}
	
	//echo $a_row['status'];?></strong></div></td>
    <td bgcolor="#FFFF99"><div align="center">
    <script language="javascript" type="text/javascript">
<!--
function popitup(url) {
	newwindow=window.open(url,'name1','height=600,width=800');
	if (window.focus) {newwindow.focus()}
	return false;
}

// -->
</script>
    <a href="veri_form_2.php" onclick="return popitup('veri_form_2.php?fno=<?php echo $a_row['fno'];?>&&btnSave2=Save&&all_game_valueb=<?php echo $a_row['class_app'];?>&&CourseType=<?php echo $a_row['CourseType'];?>&&Course=<?php echo $a_row['Course'];?>&&Course_Details=<?php echo $a_row['Course_Details'];?>&&session=<?php echo $a_row['session'];?>&&Student_Type=<?php echo $a_row['Student_Type'];?>&college=<?php echo $a_row['college'];?>')"
	>View</a>
   </div></td>
<td>
<?php if($login_type=='admin'){ ?>
<?php  //if($st==""){ ?>
<a href="debit_delete.php?fno=<?php echo $a_row['college_roll'];?>&&table=class2" onclick="return confirm('Are you sure you want to Delete Admission Form and All Fees Records...?')">Delete</a><?php }else{ ?>
Not Delete - Form Locked
<?php //}
} ?></td>
    </tr>
 
 
  <?php 
  $counterr=$counter;  
  $counter++;}?></table>
  
  <?php } ?>
  <?php if($numrowss==""){?>
  <center><h4 style="color:#FF0000;">No Record Found...</h4></center>
  <?php } ?>

</table>    <center><div align="center" style="padding:5px; background-color:#0000FF; width:300px; color:; font-size:35px;"><?php echo $counterr; ?></div></center>     </td>
      
</div></div></div>
<?php 
include "footer.php"; ?>