student-5 search

</form>

 <form action = "viewrecord.php" method = "GET">

Search a Record: <input type = "text" name = "search">

<input type = "submit" name = "submit" value = "Find Now">

</form>

       <?php

if(isset($_GET['search'])){

       $search_record = $_GET['search'];

      

       $query2 = "SELECT * FROM  details where Name = '$search_record' OR roll = '$search_record' ";

       $run2 = mysqli_query($conn,$query2);

      

       while($row2 = $run2->fetch_assoc())

       {

              $email=$row2['Email'];

              $name123= $row2['Name'];

      

       ?>

       <table width = '800' bgcolor = 'yellow' align = 'center' border = '1'>

       <tr align = 'center'>

      

<td><?php echo $name123; ?></td>

<td><?php echo $email; ?></td>

</tr>

</table>

<?php }} ?>