1#@!#!123s

: / home / schoolcampuserp / educationalprepschool.in / admin /
Filename : enquiries.php
back
<?php
include('includes/header.php');
include('includes/navbar.php');
include('security.php');
session_start();

?>

<div class="container-fluid">
    
    <?php
    if (isset($_SESSION['status']) && $_SESSION['status'] != "") {
        ?>
        <div class="alert alert-<?php echo ($_SESSION['status_code'] == "success") ? "success" : "danger"; ?> alert-dismissible fade show" role="alert">
            <?php echo $_SESSION['status']; ?>
            <!--<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>-->
        </div>
        <?php
        unset($_SESSION['status']);
        unset($_SESSION['status_code']);
    }
    
    ?>

 <div class="card shadow border-top-primary mb-4" >
        <div class="card-header py-2" style="display: flex; justify-content: space-between; align-items: center;">
            <h5 class="m-0 font-weight-bold text-primary">Enquiries</h5>
            
        </div>
        <form action="code.php" method="POST" enctype="multipart/form-data">
        <div class="card-body">
            <div class="table-responsive">

                <?php
                $query = "SELECT * FROM enquiries ORDER BY created_at DESC";
                $query_run = mysqli_query($conn, $query);
                if (mysqli_num_rows($query_run) > 0) {

                ?>


                    <table class="table table-striped" id="dataTable" width="100%" >
                        <thead>
                            <tr>
                                <th scope='col'>Sl no.</th>
                                <th scope='col'>Name</th>
                                <th scope='col'>Email</th>
                                <th scope='col'>Phone</th>
                                <th scope='col'>Status</th>
                                <th scope='col'>Action</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['email']; ?></td>
                                    <td><?php echo $row['phone']; ?></td>
                                    <td>
                                        <span class="badge 
                                            <?php echo ($row['status'] == 'pending') ? 'bg-warning text-dark' : 'bg-success text-white'; ?>">
                                            <?php echo ($row['status'] == 'pending') ? 'Pending' : 'Resolved'; ?>
                                        </span>
                                    </td>

                                    <td>
                                        <div class="btn btn-group">
                                            <form action="code.php" method="post">
                                                <input type="hidden" name="change_enquiries_id" value="<?php echo $row['id']; ?>">
                                                <input type="hidden" name="enquiries_status" value="<?php echo $row['status']; ?>">
                                                <button type="submit" name="change_enquiries_status_btn" class="btn btn-sm btn-info">Change Status </button>
                                            </form>
                                            <form action="code.php" method="post">
                                                <input type="hidden" name="enquiries_id" value="<?php echo $row['id']; ?>">
                                                <button type="submit" name="delete_enquiries_btn" class="btn btn-danger btn-sm"> DELETE</button>
                                            </form>
                                        </div>
                                    </td>
                                </tr>

                            <?php

                            }
                            ?>

                        </tbody>
                    </table>
                <?php
                } else { ?>
                    <p class="text-center" style="color: red;">No Records Found</p>

               <?php }
                ?>
            </div>
        </div>
        
         
        </form>
    </div>

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