<?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 class="page-title-actions">
                    <button type="button" data-toggle="tooltip" title="Example Tooltip" data-placement="bottom" class="btn-shadow mr-3 btn btn-dark">
                        <i class="fa fa-star"></i>
                    </button>

                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-12">
                <div class="main-card mb-3 card">
                    <div class="card-header">Footer-Links
                        <div class="btn-actions-pane-right">
                            <div role="group" class="btn-group-sm btn-group">
                                <a href="create_footer_links.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">Title</th>
        <th class="text-center">Link</th>
        <th class="text-center">Order</th>
        <th class="text-center">Actions</th>
    </tr>
</thead>
<tbody>
    <?php
    $i = 1;
    include("connection.php");
    $sql = "SELECT `id`, `title`, `link`, `order` FROM `quick_links`";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        while ($row = mysqli_fetch_assoc($result)) {
            $id = $row['id'];
            $title = $row['title'];
            $link = $row['link'];
            $order = $row['order'];
         
            echo '
            <tr>
                <td class="text-center text-muted">' . $i . '</td>
                <td class="text-center">' . $title . '</td>
                <td class="text-center"><a href="' . $link . '" target="_blank">' . $link . '</a></td>
                <td class="text-center">' . $order . '</td>
             
                <td class="text-center">
                    <button type="button" class="btn btn-primary btn-sm">
                        <a href="update_footer_links.php?update_id=' . $id . '" style="color: white;">Update</a>
                    </button>
                    <button type="button" class="btn btn-danger btn-sm">
                        <a href="delete_footer_links.php?delete_id=' . $id . '" style="color: white;">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");
    ?>