📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/chemtechieg.com/admin/course_video_manage.php
<?php require("top.php"); $msg = ""; $video_title = ''; $video_link = ''; $course_title_id = ''; $video_day = ''; // ✅ अपडेट रिक्वेस्ट चेक करें 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(); } } // ✅ वीडियो जोड़ने या अपडेट करने का प्रोसेस if (isset($_POST['submit'])) { $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']); // 🎯 वीडियो लिंक को वेरिफाई करें if (!filter_var($video_link, FILTER_VALIDATE_URL)) { $msg = "❌ Invalid video link!"; } if ($msg == '') { $res = mysqli_query($con, "SELECT * FROM course_video WHERE video_title = '$video_title' AND course_title_id = '$course_title_id'"); if (mysqli_num_rows($res) > 0) { if (isset($_GET['id']) && $_GET['id'] != '') { $getData = mysqli_fetch_assoc($res); if ($id != $getData['id']) { $msg = "❌ Title already exists in this course!"; } } else { $msg = "❌ Title already exists in this course!"; } } // ✅ अगर कोई एरर नहीं तो डेटा सेव करें if ($msg == '') { if (isset($_GET['id']) && $_GET['id'] != '') { mysqli_query($con, "UPDATE course_video SET video_title='$video_title', video_link='$video_link', video_day='$video_day' WHERE id='$id'"); } else { // ✅ New Video Insert $insert_video = mysqli_query($con, "INSERT INTO course_video(course_title_id, video_title, video_link, video_day, status) VALUES('$course_title_id', '$video_title', '$video_link', '$video_day', 1)"); if (!$insert_video) { die("Error inserting video: " . mysqli_error($con)); } // ✅ Get the last inserted video ID $video_id = mysqli_insert_id($con); if ($video_id == 0) { die("❌ Video ID Not Generated!"); } // ✅ Insert into video_day table $insert_day = mysqli_query($con, "INSERT INTO video_day(video_id, day) VALUES('$video_id', '$video_day')"); if (!$insert_day) { die("Error inserting into video_day: " . mysqli_error($con)); } // ✅ Give access to active users $users_res = mysqli_query($con, "SELECT id FROM users WHERE status = 1"); while ($user = mysqli_fetch_assoc($users_res)) { $insert_access = mysqli_query($con, "INSERT INTO user_video_access (user_id, video_id) VALUES ('" . $user['id'] . "', '$video_id')"); if (!$insert_access) { die("Error giving access: " . mysqli_error($con)); } } } header("Location: course_video.php"); exit(); } } } ?> <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">Course Video Management</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="submit" class="btn btn-primary btn-block">Submit</button> </form> </div> </div> </div>
Save
Cancel