Export DB table in csv format with columns separated by semicolons

Question

Export DB table in csv format with columns separated by semicolons

Navigation

#1 by (3 votes)

0

I can already export in CSV , but the columns are coming separated by vírgula , how to make them separated by ponto e vírgula ?

My code:

<?php  
      //export.php  
 if(isset($_POST["export"]))  
 {  
      $connect = mysqli_connect("localhost", "root", "", "simrede");  
      header('Content-Type: text/csv; charset=utf-8');  
      header('Content-Disposition: attachment; filename=Cadastro_Alunos-Simrede.csv');  
      $output = fopen("php://output", "w");  
      fputcsv($output, array('lastname', 'firstname', 'department', 'institution', 'username',  'email', 'city', 'course1', 'password'),';');  
      $query = "SELECT * from cs_alunos ORDER BY institution";  
      $result = mysqli_query($connect, $query);  
      while($row = mysqli_fetch_assoc($result))  
      {
           fputcsv($output, $row);  
      }  
      fclose($output);  
 }  
 ?>

php mysql

asked by anonymous 11.08.2018 / 17:56

1 answer

Targeting failure: Image of the recorded core name is not defined - name / variable not defined, tkinter and slite3 help

score 3 · Accepted Answer

Following the documentation , simply add the string $delimiter = "," flag by changing it to ";"

$out = fopen('php://output', 'w');
fputcsv($out, array('this','is some', 'csv "stuff", you know.'),';');
fclose($out);