<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
     <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous">
  
</head>
<body style="margin:50px;">
    <h1 style="text-align:center"> List Of New Volunteers </h1>
    <br>
    <table class="table">
        <thread>
        <tr>
            <th>ID</th>
            <th>FULLNAME </th>
            <th>EMAIL</th>
            <th>PHONENUMBER</th>
            <th>PRNNO</th>
            <th>CLUB</th>
            <th>BRANCH</th>
            <th>YEAR</th>
            <th>GENDER</th>
            <th>INTERESTED</th>
            
        </tr>
</thread>
<tbody>
    <?php
    include './connection.php';
    $sql = "SELECT * FROM tbfinalmembers";
    $result = $con->query($sql);
    if(!$result)
    {
        die("Invalid query: ".$con->error);
    }
    
    while($row=$result->fetch_assoc())
    {
        echo"<tr>
        <td>" . $row["iid"]. "</td>
        <td>" . $row["sFullName"]. "</td>
        <td>" . $row["sEmail"]. "</td>
        <td>" . $row["sPhoneNumber"]. "</td>
        <td>" . $row["sPrnNo"]. "</td>
        <td>" . $row["sClub"]. "</td>
        <td>" . $row["sBranch"]. "</td>
        <td>" . $row["sYear"]. "</td>
        <td>" . $row["sGender"]. "</td>
        <td>" .$row["sReason"]. "</td>
        
    </tr>";
    }
    ?>
    
</tbody>

    </table>
</body>
</html>