query("SELECT * FROM courses where course_name = '".$_POST['course_name']."' AND duration = '".$_POST['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,'".$_POST['course_code']."','".$_POST['categary']."', '".$_POST['course_name']."', '".$_POST['duration']."','".$_POST['duration_type']."', '".$_POST['short_name']."')"); echo ''; } } if ($_GET['action']=='del') { $con->query("DELETE FROM courses where id = '".$_GET['id']."'"); $con->query("DELETE FROM subjects where course_id = '".$_GET['id']."'"); echo ''; } if($_POST['status']=='subjects') { // print_r($_POST); $chk = $con->query("SELECT * FROM subjects where course_id = '".$_POST['course_id']."' AND subject_name = '".$_POST['subject_name']."'"); if(!($chk->num_rows)) { $S = $con->query("INSERT INTO `subjects` (`code`,`duration`,`id`, `timestamp`, `course_id`, `subject_name`, `max_marks`, `min_marks`,`duration_type`) VALUES ('".$_POST['code']."','".$_POST['duration']."',NULL, CURRENT_TIMESTAMP, '".$_POST['course_id']."', '".$_POST['subject_name']."', '".$_POST['max_marks']."', '".$_POST['min_marks']."','".$_POST['duration_type']."')"); echo ''; } } if($_GET['action']=='sub_del') { $con->query("DELETE FROM subjects where id = '".$_GET['sub_id']."'"); echo ''; } if($_POST['status']=='course_update') { $id = $_POST['id']; $course_name = $_POST['course_name']; $short_name = $_POST['short_name']; $con->query("UPDATE `courses` SET `course_name`='$course_name',`short_name`='$short_name',`duration`='".$_POST['duration']."',duration_type = '".$_POST['duration_type']."',categary = '".$_POST['categary']."' WHERE id = $id"); echo ''; } ?>

Courses

query("SELECT * FROM courses where id = '".$id."'"); $input = $name = $short_name = $duration = $course_code= $duration_type = ''; $catId = ''; 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']; } } ?>
Select Duration
query("SELECT * FROM courses"); while ($g = $get->fetch_assoc()) { // Fetch additional data from site_courses for each row $course = $con->query("SELECT * FROM site_courses WHERE id = '" . $g['categary'] . "'")->fetch_assoc(); echo ' '; } ?>
Course Code Course Name Course Category Course Duration Short Name Edit Delete
' . $g['course_code'] . ' ' . ucwords($g['course_name']) . ' ' . $course['title'] . ' ' . $g['duration'] . ' '.ucwords($g['duration_type']).' ' . $g['short_name'] . '

Add Subjects

List Subjects