<?php
session_start();
include("connection.php");
$user_profile=$_SESSION['user_name'];
// if($user_profile==true){

// }else{
//     header('location:index.php');
// }
?>
              <?php 
include("includes/header.php");
include("includes/sidebar.php");
?>  
                <div class="app-main__outer">
                    <div class="app-main__inner">
                        <div class="app-page-title">
                            <div class="page-title-wrapper">
                                <div class="page-title-heading">
                                    <div class="page-title-icon">
                                    <i class="fas fa-tachometer-alt"></i>

                                    </div>
                                    <div>Admin Dashboard
                                        
                                    </div>
                                </div>
                        
                             </div>
                         </div>
                   
                        <div class="row">
    <div class="col-md-12">
        <div class="main-card mb-3 card">
            <div class="card-header">Contact Details
                <div class="btn-actions-pane-right">
                    <div role="group" class="btn-group-sm btn-group">
                        <!-- <a href="create_banner.php">
                            <button class="active btn btn-focus">Add</button>
                        </a> -->
                    </div>
                </div>
            </div>
            <div class="table-responsive">
                <table id="main-category-table"
                    class="align-middle mb-0 table table-borderless table-striped table-hover">
                    <thead>
                                    <tr>
                                        <th class="text-center">ID</th>
                                        <th class="text-center">Name</th>
                                        <th class="text-center">Phone</th>
                                        <th class="text-center">Email</th>
                                        <th class="text-center">Message</th>
                                        <th class="text-center">Actions</th>
                                    </tr>
                                </thead>
                                <tbody>

                                    <?php
                                    $i = 1;
                                    include("connection.php");

                                    // SELECT `id`, `name`, `phone`, `select_option`, `message`, `created_at`, `updated_at` FROM `contact` WHERE 1
                                    $sql = "SELECT * FROM contact";
                                    $result = mysqli_query($conn, $sql);

                                    if ($result) {
                                        while ($row = mysqli_fetch_assoc($result)) {
                                            $id = $row['id'];
                                            $name = $row['fname'];
                                            $lname = $row['lname'];
                                            $phone = $row['mobile'];
                                            $select_option = $row['email'];
                                            $message = $row['comment'];

                                            echo '
        <tr>
            <td class="text-center text-muted">' . $i . '</td>
            <td class="text-center">' . $name . ' ' . $lname . '</td>
            <td class="text-center">' . $phone . '</td>
            <td class="text-center">' . $select_option . '</td>
            <td class="text-center">' . $message . '</td>
            <td class="text-center">
                <button type="button" class="btn-sm"><a href="delete_contact.php?delete_id=' . $id . '">Delete</a></button>
            </td>
        </tr>';
                                            $i++;
                                        }
                                    }
                                    ?>
                                </tbody>

                </table>
            </div>
        </div>
    </div>
</div>
<script>
    $(document).ready(function () {
        $('#main-category-table').DataTable();
    });
</script>

                        </div>

<?php
include("includes/footer.php");
?>
