Export from PHP to excel

0

When I export the data from my database in the localhost if it gives and saves the file and everything but at the moment of loading it to the server, the option no longer appears and shows me the data on the screen (I no longer see the document to keep).

I'm using these tags to save the file

header('Pragma: public'); 
header('Expires: Sat, 26 Jul 1997 05:00:00 GMT'); // Date in the past    
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); 
header('Cache-Control: no-store, no-cache, must-revalidate'); // HTTP/1.1 
header('Cache-Control: pre-check=0, post-check=0, max-age=0'); // HTTP/1.1 
header('Pragma: no-cache'); 
header('Expires: 0'); 
header('Content-Transfer-Encoding: none'); 
header('Content-Type: application/vnd.ms-excel'); // This should work for IE & Opera 
header('Content-type: application/x-msexcel'); // This should work for the rest 
header('Content-Disposition: attachment; filename="nombre.xls"');
    
asked by Eduardo Castro 15.02.2018 в 05:31
source

0 answers