query("SELECT * FROM courses where course_name = '$course_name' AND duration = '$duration'"); if($chk->num_rows) { echo ''; } else { $con->query("INSERT INTO `courses` (`id`, `timestamp`,`course_code`,`categary`, `course_name`, `duration`,`duration_type`, `short_name`) VALUES (NULL, CURRENT_TIMESTAMP,'$course_code','$categary', '$course_name', '$duration','$duration_type', '$short_name')"); echo ''; } } if(isset($_GET['action']) && $_GET['action']=='del' && isset($_GET['id'])) { $id = mysqli_real_escape_string($con, $_GET['id']); $con->query("DELETE FROM courses where id = '$id'"); $con->query("DELETE FROM subjects where course_id = '$id'"); echo ''; } if(isset($_POST['status']) && $_POST['status']=='subjects') { $code = mysqli_real_escape_string($con, $_POST['code']); $duration = mysqli_real_escape_string($con, $_POST['duration']); $course_id = mysqli_real_escape_string($con, $_POST['course_id']); $subject_name = mysqli_real_escape_string($con, $_POST['subject_name']); $max_marks = mysqli_real_escape_string($con, $_POST['max_marks']); $min_marks = mysqli_real_escape_string($con, $_POST['min_marks']); $duration_type = mysqli_real_escape_string($con, $_POST['duration_type']); $is_optional = isset($_POST['is_optional']) ? 1 : 0; // New: Check if optional $chk = $con->query("SELECT * FROM subjects where course_id = '$course_id' AND subject_name = '$subject_name'"); if(!($chk->num_rows)) { $con->query("INSERT INTO `subjects` (`code`,`duration`,`id`, `timestamp`, `course_id`, `subject_name`, `max_marks`, `min_marks`,`duration_type`, `is_optional`) VALUES ('$code','$duration',NULL, CURRENT_TIMESTAMP, '$course_id', '$subject_name', '$max_marks', '$min_marks','$duration_type', '$is_optional')"); echo ''; } else { echo ''; } } if(isset($_GET['action']) && $_GET['action']=='sub_del' && isset($_GET['sub_id'])) { $sub_id = mysqli_real_escape_string($con, $_GET['sub_id']); $con->query("DELETE FROM subjects where id = '$sub_id'"); echo ''; } if(isset($_POST['status']) && $_POST['status']=='course_update') { $id = mysqli_real_escape_string($con, $_POST['id']); $course_name = mysqli_real_escape_string($con, $_POST['course_name']); $short_name = mysqli_real_escape_string($con, $_POST['short_name']); $duration = mysqli_real_escape_string($con, $_POST['duration']); $duration_type = mysqli_real_escape_string($con, $_POST['duration_type']); $categary = mysqli_real_escape_string($con, $_POST['categary']); $con->query("UPDATE `courses` SET `course_name`='$course_name',`short_name`='$short_name',`duration`='$duration',duration_type='$duration_type',categary='$categary' WHERE id = $id"); echo ''; } // Edit mode $status = 'course'; $input = $name = $short_name = $duration = $course_code = $duration_type = ''; $catId = ''; if(isset($_GET['action']) && $_GET['action'] == 'edit' && isset($_GET['id'])) { $id = mysqli_real_escape_string($con, $_GET['id']); $chk = $con->query("SELECT * FROM courses where id = '$id'"); if($chk->num_rows) { $row = $chk->fetch_assoc(); $id = $row['id']; $name = $row['course_name']; $short_name = $row['short_name']; $catId = $row['categary']; $duration = $row['duration']; $input = ''; $status = 'course_update'; $course_code = $row['course_code']; $duration_type = $row['duration_type']; } } ?>

Course List

query("SELECT * FROM courses ORDER BY id DESC"); if($get->num_rows): while($g = $get->fetch_assoc()): $course = $con->query("SELECT * FROM site_courses WHERE id = '".$g['categary']."'")->fetch_assoc(); ?>
Code Course Name Category Duration Short Name Edit Delete
No courses found

Add Subjects

Subject List