query("SELECT id,class_name,section FROM result_classes"); while($c=$cr->fetch_assoc()) $classes_map[strtolower($c['class_name'].' '.$c['section'])]=$c['id']; $file=fopen($_FILES['csv_file']['tmp_name'],'r'); $header=fgetcsv($file); // skip header while(($row=fgetcsv($file))!==false){ if(count($row)<5) continue; [$adm,$fn,$ln,$dob,$gen,$fat,$mot,$mob,$cls,$sec,$roll]=$row+array_fill(0,11,''); $cls_key=strtolower(trim($cls).' '.trim($sec)); $cid=$classes_map[$cls_key]??0; if(!$cid){echo "
Class '$cls $sec' not found, skipping $fn
"; continue;} $adm=$conn->real_escape_string(trim($adm)); $fn=$conn->real_escape_string(trim($fn)); $ln=$conn->real_escape_string(trim($ln)); $dob=$conn->real_escape_string(trim($dob)); $gen=$conn->real_escape_string(trim($gen)?:'Male'); $fat=$conn->real_escape_string(trim($fat)); $mot=$conn->real_escape_string(trim($mot)); $mob=$conn->real_escape_string(trim($mob)); $roll=intval(trim($roll)); $conn->query("INSERT IGNORE INTO result_students (admission_no,first_name,last_name,dob,gender,father_name,mother_name,parent_mobile,class_id,roll_no) VALUES ('$adm','$fn','$ln','$dob','$gen','$fat','$mot','$mob',$cid,$roll)"); if($conn->affected_rows>0) $imported++; } fclose($file); $msg="✅ Imported $imported students successfully!"; } // CSV Download template if(isset($_GET['download_template'])){ header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="student_import_template.csv"'); echo "admission_no,first_name,last_name,dob(YYYY-MM-DD),gender,father_name,mother_name,mobile,class_name,section,roll_no\n"; echo "BSPS-001,Rahul,Sharma,2015-05-20,Male,Rajesh Sharma,Sunita Sharma,9876543210,Class 5,A,1\n"; echo "BSPS-002,Priya,Singh,2016-03-14,Female,Mohan Singh,Geeta Singh,9876543211,Class 4,A,2\n"; exit; } $classes=$conn->query("SELECT rc.*,rs.session_name FROM result_classes rc JOIN result_sessions rs ON rc.session_id=rs.id ORDER BY rs.is_active DESC,rc.numeric_level,rc.section"); ?> Bulk Import | Result

Bulk Student Import (CSV)

📂 Upload CSV File
CSV Column Order: admission_no, first_name, last_name, dob, gender, father_name, mother_name, mobile, class_name, section, roll_no
Class names must match exactly as created in Classes setup (e.g., "Class 5", "Nursery", "LKG")
📋 Available Classes
fetch_assoc()): ?>
— Section []
Download CSV Template
📊 Import Tips
  • DOB format: YYYY-MM-DD
  • Gender: Male, Female, Other
  • Class name must exactly match
  • Section: A, B, C etc
  • Duplicate admission_no rows are skipped