query("SELECT *,r.id as marksheet_id FROM results as r,students as s where r.roll_no = '".$_POST['roll_no']."' and r.status = 1 AND s.enrollment_no = r.enrollment_no");
$return = ['status' => false,'html' => ''];
if($num = $result->num_rows)
{
if($num == 0){
$return['html'] = 'Result Not Found.
';
}
else if($num == 1){
$return['status'] = true;
$return['html'] = 'single hai';
$return['marksheet_url'] = marksheet_url($result->fetch_assoc()['marksheet_id']);
}
else{
$return['status'] = true;
$return['html'] = '
Marksheet Action
';
while($row = $result->fetch_assoc()){
$return['html'] .= '
'.$row['duration'].' '.ucfirst($row['duration_type']).' Result
';
}
$return['html'] .= '
';
}
}
else
$return['html'] = 'Result Not Found
';
echo json_encode($return);
break;
case 'useItems':
$page_id =$post['page_id'];
$type = $post['type'];
$chk = $con->query("SELECT * FROM `web_schema` WHERE `page_id` = '".$post['page_id']."' AND `type` = '".$post['type']."' ");
if($chk->num_rows){
$con->query("DELETE FROM `web_schema` WHERE `page_id` = '$page_id' AND `type` = '$type'");
}else{
$query = $con->query("INSERT INTO `web_schema` (`type`, `page_id`) VALUES ('$type','$page_id')");
if(!$query){
print_r($con->error);exit;
}
}
echo 1;
break;
case 'extra_setting':
unset($post['status']);
unset($post['type']);
$query = false;
$hasFile = false;
if(!empty($_FILES)){
foreach($_FILES as $key => $file){
if($file['error'] == 0 && !empty($file['name']) && $file['size'] > 0){
$logo = photo_upload($key, 'files');
if($logo['status'] == 1 && !empty($logo['file_name'])){
$val = $logo['file_name'];
$hasFile = true;
$chk = $con->query("SELECT * FROM `setting` WHERE `type` = '$key' ")->num_rows;
if($chk){
$query = $con->query("UPDATE `setting` SET `value`= '$val' WHERE `type` = '$key' ");
}else{
$query = $con->query("INSERT INTO `setting`(`type`, `value`) VALUES ('$key','$val')");
}
}
}
}
}
foreach($post as $key => $val){
if(!empty($key) && $key != 'type'){
$chk = $con->query("SELECT * FROM `setting` WHERE `type` = '$key' ")->num_rows;
if($chk){
$query = $con->query("UPDATE `setting` SET `value`= '$val' WHERE `type` = '$key' ");
}else{
$query = $con->query("INSERT INTO `setting`(`type`, `value`) VALUES ('$key','$val')");
}
}
}
if($query){
$res = 'Successfully Saved';
}else{
$res = 'Something went wrong';
}
echo json_encode($res);
break;
case 'Add_Menu':
$chk = $con->query("SELECT * FROM menu where name = '".$post['name']."'");
if(!($chk->num_rows))
{
$con->query("INSERT INTO `menu` (`id`, `timestamp`, `name`) VALUES (NULL, CURRENT_TIMESTAMP, '".$post['name']."')");
echo '1';
}
else
{
echo '0';
}
break;
case 'deleteRow':
$id = $post['id'];
$table = $post['table'];
$query = $con->query("DELETE FROM $table WHERE `id` = '$id'");
if($query){
$res = 'Successfully Deleted';
}else{
$res = 'Something went wrong';
}
echo json_encode($res);
break;
case 'change_seq_of_sliders':
$return['status'] = true;
foreach($post['order'] as $k => $id)
$con->query("UPDATE `gallery_category` SET `seq` = ($k+1) WHERE `gallery_category`.`id` = '".$id."'");
$return['text'] = 'Order successfully Change.';
$return['class_name'] = 'success';
echo json_encode($return);
break;
case 'change_seq_of_gallery':
$return['status'] = true;
foreach($post['order'] as $k => $id)
$con->query("UPDATE `gallery` SET `seq` = ($k+1) WHERE `gallery`.`id` = '".$id."'");
$return['text'] = 'Order successfully Change.';
$return['class_name'] = 'success';
echo json_encode($return);
break;
case 'Check_Login':
$post = $_POST;
if ($_SESSION['digit'] == $post['digit']) {
$username = mysqli_real_escape_string($con, $post['username']);
$password = mysqli_real_escape_string($con, $post['password']);
$stmt = $con->prepare("SELECT id, type FROM login WHERE username = ? AND password = ?");
$stmt->bind_param("ss", $username, md5($password));
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows > 0) {
$stmt->bind_result($id, $type);
$stmt->fetch();
$rand = rand(111111, 999999);
$_SESSION['admin']['id'] = $id;
$_SESSION['admin']['session_id'] = $rand;
$_SESSION['admin']['login'] = true;
$_SESSION['admin']['type'] = $type;
$con->query("INSERT INTO `check_session` (`id`, `timestamp`, `user_id`, `session_id`) VALUES (NULL, CURRENT_TIMESTAMP, '$id', '$rand')");
session_regenerate_id(true);
echo json_encode(1);
} else {
echo json_encode(0);
}
$stmt->close();
} else {
echo json_encode(2);
}
break;
case 'get_city':
$state_id = mysqli_real_escape_string($con, $post['state_id']);
$get = $con->query("SELECT * FROM city where state_id = '$state_id' ORDER BY city_name ASC");
if($get->num_rows > 0) {
echo '--Select District/City-- ';
while($g = $get->fetch_assoc())
{
echo ''.ucwords($g['city_name']).' ';
}
} else {
echo 'No District Found ';
}
break;
case 'get_city2':
$state_id = mysqli_real_escape_string($con, $post['state_id']);
$get = $con->query("SELECT * FROM city where state_id = '$state_id' ORDER BY city_name ASC");
if($get->num_rows > 0) {
echo '--Select District/City-- ';
while($g = $get->fetch_assoc())
{
echo ''.ucwords($g['city_name']).' ';
}
} else {
echo 'No District Found ';
}
break;
case 'get_subjects':
echo '
#
Subject Name
Marks
Type
Edit
Remove
Max
Min
';
$i=1;
$get = $con->query("SELECT * FROM subjects where course_id = '".$post['course_id']."' ORDER BY is_optional ASC, subject_name ASC");
if($get->num_rows > 0) {
while($g = $get->fetch_assoc())
{
$type_badge = $g['is_optional'] ?
'Optional ' :
'Compulsory ';
echo '
'.$i++.'
'.ucwords($g['subject_name']).'
'.$g['max_marks'].'
'.$g['min_marks'].'
'.$type_badge.'
';
}
} else {
echo 'No subjects found
';
break;
case 'update_subject':
$is_optional = isset($_POST['is_optional']) ? 1 : 0;
$con->query("UPDATE `subjects` SET
`max_marks` = '".$_POST['max_marks']."',
min_marks = '".$_POST['min_marks']."',
subject_name = '".$_POST['subject_name']."',
code = '".$_POST['code']."',
is_optional = '$is_optional'
WHERE `subjects`.`id` = '".$_POST['id']."'");
echo 1;
break;
// =============================================
// FIXED: subjects case for create_result.php
// =============================================
case 'subjects':
header('Content-Type: application/json');
$course_id = mysqli_real_escape_string($con, $post['course_id'] ?? '');
$duration_type = mysqli_real_escape_string($con, $post['duration_type'] ?? '');
$duration = mysqli_real_escape_string($con, $post['duration'] ?? '');
$enrollment_no = mysqli_real_escape_string($con, $post['enrollment_no'] ?? '');
// Debug log
error_log("Subjects Request - Course: $course_id, Duration: $duration, Type: $duration_type");
// Get subjects for this course (without duration filter first to check)
$get = $con->query("SELECT * FROM subjects
WHERE course_id = '$course_id'
ORDER BY is_optional ASC, subject_name ASC");
// If no subjects found with course_id only, try with duration filter
if(!$get || $get->num_rows == 0) {
$get = $con->query("SELECT * FROM subjects
WHERE course_id = '$course_id'
AND duration = '$duration'
AND duration_type = '$duration_type'
ORDER BY is_optional ASC, subject_name ASC");
}
if($get && $get->num_rows > 0) {
$html = '';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
';
$html .= 'Course ID: ' . $course_id . ', Duration: ' . $duration . ' ' . $duration_type . ' ';
$html .= 'Please add subjects for this course first. ';
$html .= '
';
$html .= '
-Select Duration- ';
$message = 'num_rows ? 'disabled' : '').'>'.$c['duration'].' '.ucwords($c['duration_type']).' ';
if($checkAdmit->num_rows)
$message = ''.$c['duration'].' '.ucfirst($c['duration_type']).' admit card created..
';
}
else{
$selectedSet = false;
for($i = 1; $i <= $c['duration']; $i++){
$checkAdmit = $con->query("SELECT * FROM admit_card WHERE enrollment_no = '".$post['enrollment_no']."' and course_id = '".$get['course_id']."' and duration = '".$i."' and duration_type = '".$c['duration_type']."' ");
if($checkAdmit->num_rows)
$option .= ''.$i.' '.ucwords($c['duration_type']).' ';
else{
if (!$selectedSet) {
$option .= ''.$i.' '.ucwords($c['duration_type']).' ';
$selectedSet = true;
} else {
$option .= ''.$i.' '.ucwords($c['duration_type']).' ';
}
}
if($checkAdmit->num_rows)
$message .= ''.$i.' '.ucfirst($c['duration_type']).' admit card created..
';
}
}
echo json_encode([
'course_id' => $c['id'],
'course_name' => $c['course_name'],
'message' => $message,
'option' => $option
]);
break;
case 'get-subject-list':
$course_id = $_POST['course_id'];
$duration = $_POST['duration'];
$duration_type = $_POST['duration_type'];
$getSubjects = $con->query("SELECT * FROM subjects WHERE course_id = '$course_id' and duration = '$duration' and duration_type = '$duration_type' ORDER BY is_optional ASC, subject_name ASC");
$html = '';
if($getSubjects->num_rows){
$html .= '
';
}
else
$html .= '
Subjects are not found of this course..
';
$html .= '