false, 'message' => 'Class parameter required']); exit(); } // Extract class number and level from the class value // Your classes table: 'Secondary (Class 10)', 'Senior Secondary - Arts', etc. // Your students table stores class like: '12', 'Senior Secondary - S', '10' $class_num = preg_replace('/[^0-9]/', '', $class); // Map class to database values $db_class_values = [$class, $class_num]; // For Senior Secondary, add stream-based values if (strpos($class, 'Senior Secondary') !== false || $class_num == '12') { $db_class_values[] = 'Senior Secondary - ' . ($stream ?: 'Science'); $db_class_values[] = 'Senior Secondary - Arts'; $db_class_values[] = 'Senior Secondary - Commerce'; $db_class_values[] = 'Senior Secondary - Science'; } // Build IN clause $class_list = "'" . implode("','", array_unique($db_class_values)) . "'"; $query = "SELECT * FROM subjects WHERE class IN ($class_list) ORDER BY id ASC"; $result = $conn->query($query); $subjects = []; if ($result && $result->num_rows > 0) { while($row = $result->fetch_assoc()) { $subjects[] = [ 'id' => $row['id'], 'subject_name' => $row['subject_name'], 'max_marks' => $row['max_marks'], 'passing_marks' => $row['passing_marks'], 'practical_marks' => $row['practical_marks'] ]; } } // If no subjects found, return default subjects based on class if (empty($subjects)) { if ($class_num == '10') { $subjects = [ ['id' => 0, 'subject_name' => 'Punjabi', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'English', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'Hindi', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'Mathematics', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'Science', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'Social Science', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ]; } else { $subjects = [ ['id' => 0, 'subject_name' => 'Punjabi', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'English', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ['id' => 0, 'subject_name' => 'Physics', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 30], ['id' => 0, 'subject_name' => 'Chemistry', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 30], ['id' => 0, 'subject_name' => 'Mathematics', 'max_marks' => 100, 'passing_marks' => 33, 'practical_marks' => 0], ]; } } echo json_encode(['success' => true, 'subjects' => $subjects]); ?>