<?php
require("top.php");

$msg = "";
$video_title = '';
$video_link = '';
$course_title_id = '';
$video_day = '';

// ✅ Check if ID is provided
if (isset($_GET['id']) && $_GET['id'] != '') {
    $id = mysqli_real_escape_string($con, $_GET['id']);
    $res = mysqli_query($con, "SELECT * FROM course_video WHERE id = '$id'");
    
    if (mysqli_num_rows($res) > 0) {
        $row = mysqli_fetch_assoc($res);
        $video_title = $row['video_title'];
        $video_link = $row['video_link'];
        $course_title_id = $row['course_title_id'];
        $video_day = $row['video_day'];
    } else {
        header("Location: course_video.php");
        exit();
    }
} else {
    header("Location: course_video.php");
    exit();
}

// ✅ Update Process
if (isset($_POST['update'])) {
    $course_title_id = mysqli_real_escape_string($con, $_POST['course_title_id']);
    $video_title = mysqli_real_escape_string($con, $_POST['video_title']);
    $video_link = mysqli_real_escape_string($con, $_POST['video_link']);
    $video_day = mysqli_real_escape_string($con, $_POST['video_day']);

    // 🎯 Validate Video Link
    if (!filter_var($video_link, FILTER_VALIDATE_URL)) {
        $msg = "❌ Invalid video link!";
    }

    if ($msg == '') {
        // ✅ Update Query
        $update_query = mysqli_query($con, "UPDATE course_video 
            SET course_title_id='$course_title_id', video_title='$video_title', video_link='$video_link', video_day='$video_day' 
            WHERE id='$id'");

        if ($update_query) {
            header("Location: course_video.php");
            exit();
        } else {
            $msg = "❌ Error updating video: " . mysqli_error($con);
        }
    }
}
?>

<div class="col-sm-9 mx-auto my-4">
    <div class="col-sm-12">
        <div class="card">
            <div class="card-body">
                <h4 class="text-center">Edit Course Video</h4>
            </div>
            <?php if ($msg != '') { ?>
                <div class="alert alert-danger"><?php echo $msg; ?></div>
            <?php } ?>
            <form method="post">
                <div class="form-group">
                    <label>Select Course</label>
                    <select name="course_title_id" class="form-control" required>
                        <option value="">Select Course</option>
                        <?php
                        $course_res = mysqli_query($con, "SELECT id, title FROM course_title WHERE status = 1 ORDER BY title ASC");
                        while ($course = mysqli_fetch_assoc($course_res)) {
                            $selected = ($course['id'] == $course_title_id) ? 'selected' : '';
                            echo "<option value='".$course['id']."' $selected>".$course['title']."</option>";
                        }
                        ?>
                    </select>
                </div>

                <div class="form-group">
                    <label>Video Title</label>
                    <input type="text" name="video_title" class="form-control" value="<?php echo htmlspecialchars($video_title); ?>" required>
                </div>

                <div class="form-group">
                    <label>Video Link</label>
                    <input type="text" name="video_link" class="form-control" value="<?php echo htmlspecialchars($video_link); ?>" required>
                </div>
                
                <div class="form-group">
                    <label>Video Day</label>
                    <input type="number" name="video_day" class="form-control" value="<?php echo htmlspecialchars($video_day); ?>" required>
                </div>

                <button type="submit" name="update" class="btn btn-success btn-block">Update</button>
                <a href="course_video.php" class="btn btn-secondary btn-block">Cancel</a>
            </form>
        </div>
    </div>
</div>
