<?php
include('headMain.php');
?>
<table width="100%" cellspacing="5" cellpadding="3">
          <tr>
            <td align="center"><!-- InstanceBeginEditable name="EditRegion3" -->
       <?php
		 if (isset($_SESSION['sName'] )){
			echo 'The Admin user Editing is: '.$_SESSION['sName'];
			echo'<br />';
			//require_once('../connect.php');
			$names =htmlspecialchars($_POST['names']);
			$sql = $db->query("SELECT * FROM realdata WHERE names like '%$names%'");
			//$result = mysql_query($sql);
			$num = $sql->rowCount();

       if ($num>0)
      // $sql_fetch= $sql->fetch(PDO::FETCH_BOTH);
			{
				?>
			<table width="200" border="1">
			<tr>
    			<th scope="col">No</th>
                <th scope="col">FormNo</th>
   				<th scope="col">Names</th>
                <th scope="col">Department</th>
                <th scope="col">Email</th>
                <th scope="col">Change</th>
  			</tr>
            <?php
            $i=0;
            $no=1;

			 while ($row=$sql->fetch(PDO::FETCH_BOTH))
			 { 

			  	echo '<tr>';
    		  	echo '<td>'.$no.'</td>';
				echo '<td>'.$row['formNo'].'</td>';
    		   	echo '<td>'.$row['names'].'</td>';
 				echo '<td>'.$row['course'].'</td>';
 				echo '<td>'.$row['email'].'</td>';
				echo '<td><a href="changeName_process.php?formEmail='.$row['email'].'&formNo='.$row['formNo'].'" >Change Name</a></td>';
                 ++$no;
			 }
			 echo '</table>';
				} else {
					echo'No such Record Found';
				}
			
		}else{
			echo 'Un-Authorized Access....';
		}
				ob_end_flush();
	  ?>
          		<br />
<a href="logout.php">Log Out </a>
<!-- InstanceEndEditable --></td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<p>&nbsp;</p>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>