📁 File Manager

Dosya Düzenle: export_csv.php

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

// Set CSV headers
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="student_admissions.csv"');

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

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

// Filters
$programme = $_GET['programme_name'] ?? '';
$scheme    = $_GET['admission_scheme'] ?? '';
$sub1      = $_GET['subject1'] ?? '';
$sub2      = $_GET['subject2'] ?? '';
$aecc      = $_GET['aec_subject'] ?? '';

// Build query
$sql = "SELECT * FROM student_admission_25 WHERE 1";
if ($programme) $sql .= " AND programme_name = '".mysqli_real_escape_string($con, $programme)."'";
if ($scheme)    $sql .= " AND admission_scheme = '".mysqli_real_escape_string($con, $scheme)."'";
if ($sub1)      $sql .= " AND subject1 = '".mysqli_real_escape_string($con, $sub1)."'";
if ($sub2)      $sql .= " AND subject2 = '".mysqli_real_escape_string($con, $sub2)."'";
if ($aecc)      $sql .= " AND aec_subject = '".mysqli_real_escape_string($con, $aecc)."'";

// Execute query
$result = mysqli_query($con, $sql);

// Output data
while ($row = mysqli_fetch_assoc($result)) {
    fputcsv($output, [
        $row['formNo'],
        $row['registration_id'],
        $row['programme_name'],
        $row['applicant_name'],
        $row['mobile'],
        $row['clgroll'],
        $row['admission_scheme'],
        $row['subject1'],
        $row['subject2'],
        $row['aec_subject'],
        $row['gender'],
        $row['category'],
        $row['email']
    ]);
}

fclose($output);
exit;
?>

İptal