cleaningdisplay.php

<?php
include ("header.php");


$user=$_GET['un'];
$hostelid=$_GET['hid'];
$hostel=$_GET['hn'];
// $user=$_SESSION['username'];
// $hostel=$_SESSION['hostelname'];
// $hostelid=$_SESSION['hostelid'];
if ($user == true)
{

}
else{
    header("location:index.php"); 
}
?>
<table style=" border: 3px solid black;">
<tr>
    <th>HostelID</th>
    <th>StudentID</th>
    <th>R.NO</th>
    <th>Sweeping</th>
    <th>washroom</th>
    <th>washbasin</th>
    <th>floor</th>
    <th>Complaint</th>
    <th>Delete</th>

    </tr>

    <?php
    $user=$_GET['un'];
    $hostelid=$_GET['hid'];
    $hostel=$_GET['hn'];
    $query="SELECT * FROM `cleaning` WHERE hostelid ='".$hostelid."'";
    $data= mysqli_query($conn,$query);

    $total = mysqli_num_rows($data);
    if($total!=0){
        while($result=mysqli_fetch_assoc($data)){
            echo "<tr>
            <td align='center'>".$result['hostelid']."</td>
            <td align='center'>".$result['stdid']."</td>
                <td align='center'>".$result['rmnumber']."</td>
                <td align='center'>".$result['sweeping']."</td>
                <td align='center'>".$result['washroom']."</td>
                <td align='center'>".$result['washbasin']."</td>
                <td align='center'>".$result['floor']."</td>
                <td align='center'>".$result['text']."</td>
                <td><a href='cleaningdelete.php?en=$result[entryno]'>Delete</a></td>

                </tr>";
                }
                }
                else{
                    echo "No Records found";
                }

?>