<?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">Social Media
                        <div class="btn-actions-pane-right">
                            <div role="group" class="btn-group-sm btn-group">
                                <a href="create_social_media.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">Platform Name</th>
        <th class="text-center">Platform Icon</th>
        <th class="text-center">Link</th>
        <th class="text-center">Actions</th>
    </tr>
</thead>
<tbody>
    <?php
    $i = 1;
    include("connection.php");

    // Query to fetch data from social_media table
    $sql = "SELECT id, platform_name, platform_icon, link FROM social_media";
    $result = mysqli_query($conn, $sql);

    if ($result) {
        while ($row = mysqli_fetch_assoc($result)) {
            $id = $row['id'];
            $platform_name = $row['platform_name'];
            $platform_icon = $row['platform_icon'];
            $link = $row['link'];

            echo '
            <tr>
                <td class="text-center text-muted">' . $i . '</td>
                <td class="text-center">' . $platform_name . '</td>
                  <td class="text-center">' . $platform_icon . '</td>
                <td class="text-center">
                    <a href="' . $link . '" target="_blank" style="text-decoration: none; color: #007bff;">' . $link . '</a>
                </td>
                <td class="text-center">
                    <button type="button" class="btn btn-primary btn-sm">
                        <a href="update_social_links.php?update_id=' . $id . '" style="color: white;">Update</a>
                    </button>
                    <button type="button" class="btn btn-danger btn-sm">
                        <a href="delete_social_media.php?delete_id=' . $id . '" style="color: white;">Delete</a>
                    </button>
                </td>
            </tr>';
            $i++;
        }
    } else {
        echo '<tr><td colspan="5" class="text-center">No records found</td></tr>';
    }
    ?>
</tbody>

                        </table>
                    </div>
                </div>
            </div>
        </div>
        <script>
            $(document).ready(function() {
                $('#main-category-table').DataTable();
            });
        </script>
    </div>

    <?php
    include("includes/footer.php");
    ?>