Search the Community

Hello all! Sorry for the lame question, but I need to save XLS to my server, but how? Have removed parts that are not relevant to my question. This code saves the content into .xsl format and downloads it immediately to the desktop if run with your browser, but how can I save that file to the server? With something like file_put_contents()? But how? And does $files = header("Content-Disposition: attachment;filename=export_".date('n-j-Y').".xls "); even work? ( the `$files =` part ) Thanks for all the help! <?php // database connection etc goes here /* * START HEX writing to Excel format */ // Beginning of XLS file function xlsBOF() { echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); return; } // End of XLS file function xlsEOF() { echo pack("ss", 0x0A, 0x00); return; } // Writes text to cells function xlsWriteLabel($Row, $Col, $Value ) { $L = strlen($Value); echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L); echo $Value; return; } /* * Database connection goes here * * * * [removed] * * */ /* * Headers for the browser */ header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); $files = header("Content-Disposition: attachment;filename=export_".date('n-j-Y').".xls "); header("Content-Transfer-Encoding: binary "); // Start the file xlsBOF(); /* * To keep it in order * * [removed] * * */ // On first row $first = true; while( $qrow = mysql_fetch_assoc( $qr ) ) { if( $first ) { // [removed] } // goes through the data foreach( $qrow as $k => $v ) { // write it in the file // [removed] } // reset col and goto next row $col = 0; $row++; } xlsEOF(); exit(); ?>