במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

]]jkjjgdjffksdkdfdkfjgsldkfhgjkgjkhjkgjkdascxvxcvxcvjdklfgjslkdfgjlskdfgjdskfgj במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

<?php
include('includes/header.php');
include('includes/navbar.php');
include('security.php');
?>

<div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">Messages</h6>
        </div>
        <div class="card-body">
            <div class="table-responsive">

<?php
                $query = "SELECT * FROM viewpayment";
                $query_run = mysqli_query($connection, $query);
                if (mysqli_num_rows($query_run) > 0) {

<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                        <thead>
                            <tr>
                                <th>Sl no.</th>
                                <th>Candidate Name</th>
                                <th>Mother's Name</th>
                                <th>Father's Name</th>
                                <th>Address</th>
                                <th>Whatsapp </th>
                                 <th>Aadhar Number </th>
                                <th>Secured Percentage </th>
                                <th>Stream Applied For </th>
                                 <th>Enter Transaction ID</th>
                                 <th>Screen Short</th>
                                 <th>Date & Time</th>
                                  <th>Address</th>
                               
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $sl = 1;
                            while ($row = mysqli_fetch_assoc($query_run)) {
                                
                            ?>
                                <tr>
                                    <td><?php echo $sl++; ?></td>
                                    <td><?php echo $row['name']; ?></td>
                                    <td><?php echo $row['father']; ?></td>
                                     <td><?php echo $row['school']; ?></td>
                                    <td><?php echo $row['mobile']; ?></td>
                                    <td><?php echo $row['wp']; ?></td>
                                    <td><?php echo $row['aad']; ?></td>
                                    <td><?php echo $row['per']; ?></td>
                                    <td><?php echo $row['stream']; ?></td>
                                    <td><?php echo $row['tid']; ?></td>
                                     <td><?php echo '<img src="recept/' . $row['st'] . '"width ="100px" alt="Images">' ?></td>
                                    <td><?php echo $row['add_date']; ?></td>
                                     <td><?php echo $row['address']; ?></td>
                                
                                    
                                   
                                </tr>

<?php

}
                            ?>

</tbody>
                    </table>
                <?php
                } else {
                    echo "no records found";
                }
                ?>
            </div>
        </div>
    </div>

</div>

<?php
include('includes/scripts.php');
include('includes/footer.php');
?>