<?php  


      //export.php  

 if(isset($_POST["export"]))  

 {  

      $connect = mysqli_connect("localhost", "root", "", "test");
      $connect -> set_charset("utf8");

      header('Content-Type: text/csv; charset=utf-8');  

      header('Content-Disposition: attachment; filename=data.csv');  

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

      fputcsv($output, array('ID','název', 'zdroj'));

      $query = "SELECT ind.id as id, ind.nazev as nazev, ind.zdroj as zdroj
                FROM indikatory as ind join vazba on ind.ID=vazba.ID_ind join specif_cil as sp_cil on sp_cil.ID=vazba.id_spec_cil join strate_cil as st_cil on st_cil.ID=sp_cil.id_stra join oblast_zmen as oz on oz.ID=st_cil.id_oz WHERE 1 ".$_POST["filter"]." group by ind.id";

      $result = mysqli_query($connect, $query);  

      while($row = mysqli_fetch_assoc($result))  

      {  

           fputcsv($output, $row);  

      }  

      fclose($output);  

 }  

 ?>