<?php
session_start();
ob_start(); // Start output buffering at the beginning
include("connection.php");
include("includes/header.php");
include("includes/sidebar.php");

$user_profile = $_SESSION['user_name'];
if ($user_profile == true) {
} else {
    // header('location:index.php');
}
?>

<?php
// Fetch the social media record based on the ID passed in the URL
$id = $_GET['update_id'];

$sql = "SELECT * FROM social_media WHERE id='$id'";
$result = mysqli_query($conn, $sql);

if ($result && mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);

    $platform_name = $row['platform_name'];
    $platform_icon = $row['platform_icon'];
    $link = $row['link'];
} else {
    echo "Record not found!";
    exit;
}
?>

<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="pe-7s-car icon-gradient bg-mean-fruit">
                        </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="card mb-3">
                    <div class="card-header">
                        <strong>Update Social Media</strong>
                    </div>
                    <div class="card-body">
    <form action="" method="POST">
        <div class="form-group">
            <label for="platform_name">Platform Name</label>
            <input type="text" class="form-control" name="platform_name" id="platform_name" 
                value="<?php echo htmlspecialchars($platform_name); ?>" placeholder="Enter Platform Name" required>
        </div>

        <div class="form-group">
            <label for="platform_icon">Platform Icon (CSS Class)</label>
            <input type="text" class="form-control" name="platform_icon" id="platform_icon" 
                value="<?php echo htmlspecialchars($platform_icon); ?>" placeholder="Enter Icon Class" required>
        </div>

        <div class="form-group">
            <label for="link">Platform Link</label>
            <input type="url" class="form-control" name="link" id="link" 
                value="<?php echo htmlspecialchars($link); ?>" placeholder="Enter Link" required>
        </div>

        <input type="submit" value="Update" name="update" class="btn btn-primary">
    </form>
</div>
                </div>
            </div>
        </div>

    </div>

    <?php
// Handle form submission
if (isset($_POST['update'])) {
    $platform_name = mysqli_real_escape_string($conn, $_POST['platform_name']);
    $platform_icon = mysqli_real_escape_string($conn, $_POST['platform_icon']);
    $link = mysqli_real_escape_string($conn, $_POST['link']);

    $update_sql = "UPDATE social_media SET 
                    platform_name='$platform_name', 
                    platform_icon='$platform_icon', 
                    link='$link',
                    updated_at=NOW() 
                  WHERE id='$id'";

    if (mysqli_query($conn, $update_sql)) {
        echo "<script>alert('Social media record updated successfully!');</script>";
        echo "<script>window.location.href='view_social_media.php';</script>";
    } else {
        echo "Error updating record: " . mysqli_error($conn);
    }
}
?>
</div>

<?php
include("includes/footer.php");
ob_end_flush(); // Send the buffered output to the client
?>