File Manager

Editing File: /home/quiczmwg/affordablerealtycorporation.com/admin/manage_applications.php

<?php
// session_start();
include 'head.php';
include 'header.php';
?>

<?php 
    include 'sidebar.php';

// Fetch rental applications
    $sql = $conn->query("SELECT * FROM rental_applications ORDER BY created_at DESC");
    ?>

<div class="page-wrapper">
    <section>
        <div class="">
        <?php
            include 'nav1.php';
        ?>
            <div class="container-fluid">
                <div class="card">
                    <div class="card-header">
                        <h4>Manage Rental Applications</h4>
                        <?php echo isset($_SESSION['mgs'])?$_SESSION['mgs']:""?>                   
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered table-striped">
                                <thead class="table-dark">
                                    <tr>
                                        <th>#</th>
                                        <th>Full Name</th>
                                        <th>Date of Birth</th>
                                        <th>Phone</th>
                                        <th>Pets</th>
                                        <th>Income Amount</th>
                                        <th>Roommate</th>
                                        <th>Housing Voucher</th>
                                        <th>Application Date</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php 
                                    if($sql->num_rows > 0){
                                        $num = 1;
                                        while($row = $sql->fetch_assoc()){                               
                                    ?>
                                    <tr>
                                        <td><?php echo $num++; ?></td>
                                        <td><?php echo htmlspecialchars($row['full_name']); ?></td>
                                        <td><?php echo !empty($row['dob']) ? date("j M Y", strtotime($row['dob'])) : "N/A"; ?></td>
                                        <td><?php echo htmlspecialchars($row['phone']); ?></td>
                                        <td>
                                            <?php 
                                                echo ($row['pets'] == "yes") ? "Yes - " . htmlspecialchars($row['pet_info']) : "No";
                                            ?>
                                        </td>
                                        <td><?php echo htmlspecialchars($row['income_amount']); ?></td>
                                        <td><?php echo ucfirst($row['has_roommate']); ?></td>
                                        <td>
                                            <?php 
                                                echo ($row['housing_voucher'] == "yes") 
                                                    ? htmlspecialchars($row['voucher_type']) . " ($" . htmlspecialchars($row['voucher_amount']) . ")" 
                                                    : "No";
                                            ?>
                                        </td>
                                        <td><?php echo date("j M Y", strtotime($row['created_at'])); ?></td>
                                        <td>
                                            <a href="application_details.php?id=<?php echo $row['id']; ?>" class="btn btn-info btn-sm">Details</a>
                                            <a href="delete_application.php?id=<?php echo $row['id']; ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this application?');">Delete</a>
                                        </td>
                                    </tr>
                                    <?php 
                                        } 
                                    } else {
                                        echo "<tr><td colspan='10' class='text-center'>No applications found.</td></tr>";
                                    }
                                    ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

</section>
</div>
</div>
<?php include 'footer.php'; ?>
</body>
</html>

Back to Directory File Manager