📁 File Manager

Dosya Düzenle: export_excel.php

<?php
include("connect.php");

$selected_subject = isset($_GET['subject']) ? trim($_GET['subject']) : '';

$where = [];

if ($selected_subject !== '') {
    $escaped_sub = mysqli_real_escape_string($con, $selected_subject);
    $where[] = "(
        (admission_scheme = '2 Minor' AND (subject1 = '$escaped_sub' OR subject2 = '$escaped_sub')) 
        OR 
        (admission_scheme = '1 Major 1 Minor' AND subject2 = '$escaped_sub')
    )";
}

$where_sql = count($where) ? 'WHERE ' . implode(' AND ', $where) : '';
$sql = "SELECT * FROM student_admission_25 $where_sql ORDER BY formNo ASC";
$result = mysqli_query($con, $sql);

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=filtered_student_data.csv');

$output = fopen('php://output', 'w');

// Column headers
fputcsv($output, [
    'S.No.', 'Form No', 'Registration ID', 'Programme', 'Name', 'Mobile',
    'Alt. Mobile', 'College Roll', 'Scheme', 'Subject 1', 'Subject 2',
    'AECC', 'Gender', 'Category', 'Email'
]);

$serial = 1;

while ($row = mysqli_fetch_assoc($result)) {
    $scheme = $row['admission_scheme'];
    $sub1 = $row['subject1'];
    $sub2 = $row['subject2'];

// Filtering logic
    if ($selected_subject !== '') {
        if ($scheme === '1 Major 1 Minor' && $sub2 !== $selected_subject) continue;
        if ($scheme === '1 Major 1 Minor' && $sub1 === $selected_subject) continue;
        if ($scheme === '2 Minor' && ($sub1 !== $selected_subject && $sub2 !== $selected_subject)) continue;
    }

fputcsv($output, [
        $serial++,
        $row['formNo'],
        $row['registration_id'],
        $row['programme_name'],
        $row['applicant_name'],
        $row['mobile'],
        $row['mobile_alt'],
        $row['clgroll'],
        $scheme,
        $sub1,
        $sub2,
        $row['aec_subject'],
        $row['gender'],
        $row['category'],
        $row['email']
    ]);
}

fclose($output);
exit;

İptal