📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/chemtechieg.com/admin/course_video_edit.php
<?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>
Save
Cancel