<?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">Menu
                        <div class="btn-actions-pane-right">
                            <div role="group" class="btn-group-sm btn-group">
                                <a href="create_menu.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">Parent ID</th>
        <th class="text-center">Name</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 * FROM menus";  // Query to fetch data from 'menus' table
    $result = mysqli_query($conn, $sql);

    if ($result) {
        while ($row = mysqli_fetch_assoc($result)) {
            $id = $row['id'];
            $parent_id = $row['parent_id'];
            $name = $row['name'];
            $link = $row['link'];
            $order = $row['order'];
           
            
            echo '
            <tr>
                <td class="text-center text-muted">' . $i . '</td>
                <td class="text-center">' . $parent_id . '</td>
                <td class="text-center">' . $name . '</td>
                <td class="text-center">' . $link . '</td>
                <td class="text-center">' . $order . '</td>
              
                <td class="text-center">
                    <button type="button" class="btn btn-primary btn-sm">
                        <a href="update_menu.php?update_id=' . $id . '" style="color: white;">Update</a>
                    </button>
                    <button type="button" class="btn btn-danger btn-sm">
                        <a href="delete_menu.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");
    ?>