<?php
session_start();
$app1=$_REQUEST['flag'];
include("../link/databaseconnection.php");
$sel="select * from  test where mobile ='$app1' and verify='1'  order by id desc";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);

//echo"$app1";
?>

<style>
    table, th, td {    
border: 1px solid black;  
margin-left: auto;  
margin-right: auto;  
border-collapse: collapse;    
text-align: center;  
font-size: 20px;  
}    
.p16{
    font-size: 16px;
    font-weight: 600;
}
tr td{
    padding:10px;
}
.text-left{
    text-align:left;
}
.w-20{
    width:25%;
}
.w-55{
    width:50%;
}
.textdec{
    color: #fff;
    background: green;
    padding: 5px;
    font-size: 15px;
    border-radius: 3px;
    text-decoration: none;
}
</style>
<table style="border:1px solid black; width:100%; margin:auto;">
<tr>
<td style='border-right:none;'><span><img src="../images/logo.png" height="140px" width="140px"/></span></td><td colspan='2'align="center"><span id="name"  style="font-size:22px;font-weight:bold">PARAMOUNT INTERNATIONAL SCHOOL</span><br/><span id="name1" style="font-size:20px;font-weight:bold">DHANAULI, DOHARIGHAT MAU</span><br/><br/><span id="name1" style="font-size:17px;font-weight:bold">SHOLARSHIP SCHEME (<?php echo $row['session']?>)</span></td>
</tr>
<tr>
    <td class="p16 text-left w-20 ">Registration No.</td>
    <td class="w-55 text-left"><?php echo $row['id']?></td>
    <td rowspan="3" class="p16"><img src="../code/img/<?php echo $row['picture'];?>" style='height:150px;width:100px' ></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Registration Date</td>
    <td class="w-55 text-left"><?php echo $row['date']?> <?php echo $row['time']?></td>
</tr>
<tr>
    <td class="p16 text-left w-20 ">Name</td>
    <td class="w-55 text-left" style='text-transform: uppercase;' ><?php echo $row['name']?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Father</td>
    <td class="w-55 text-left" style='text-transform: uppercase;' ><?php echo $row['father']?></td>  
    <td class="w-55 text-left"></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Mother</td>
    <td class="w-55 text-left" colspan="2" style='text-transform: uppercase;'><?php echo $row['mother']?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Date of Birth</td>
    <td class="w-55 text-left" colspan="2"><?php echo $row['dob']?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Gender</td>
    <td class="w-55 text-left" colspan="2" style='text-transform: uppercase;'><?php echo $row['gender']?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Aadhaar</td>
    <td class="w-55 text-left" colspan="2"><?php echo $row['adhar']?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Class</td>
    <td class="w-55 text-left" colspan="2"><?php echo $row['class']?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Previous School</td>
    <td class="w-55 text-left" colspan="2" style='text-transform: uppercase;' ><?php echo $row['pre_sc'];?></td>  
</tr>
<tr>
    <td class="p16 text-left w-20 ">Address</td>
    <td class="w-55 text-left" colspan="2" style='text-transform: uppercase;'><?php echo $row['village']?> , <?php echo $row['post']?> , <?php echo $row['dist']?> <?php echo $row['mobile']?></td>  
</tr>
</table>



</body>
</html>