global $conn;
      $sql=$_SESSION['export'];
      $query = $conn->query($sql);

        if($query->num_rows > 0){
            $delimiter = ",";
            $filename = "requests.csv";
            $fields = array("Project_id", "CuratorI", "CuratorP", "Theme", "Type", "StudentI", "StudentP", "Email", "Group", "dtCreation", "dtAccepted");
            $f = fopen('php://memory', 'w');
            fputcsv($f, $fields, $delimiter);
            while($row = $query->fetch_assoc()){
                
                $lineData = array($row["project_id"],$row["CuratorI"],$row["CuratorP"],$row["theme"],$row["type"],$row["StudentI"],
                $row["StudentP"],$row["email"],$row["group_name"],$row["dtCreation"],$row["dtAccepted"]);
                fputcsv($f, $lineData, $delimiter);
            }
            fseek($f, 0);
            header('Content-Type: text/csv');
            header('Content-Disposition: attachment; filename="' . $filename . '";');
            fpassthru($f);
        }
        exit;