NYCPHP Meetup

NYPHP.org

[nycphp-talk] xls output: localhost works, www doesn't

Adrian Noland anoland at indigente.net
Tue Jan 15 08:18:07 EST 2008


Try an ob_clean() before sending the header. That way you make sure there
are no extra LF/CR in your output.

On 1/14/08, Rick Retzko <rick at click-rick.net> wrote:
>
> Hi all - Hopefully one of you have seen this and can quickly point me to
> the
> error of my ways.
>
> I need to output small files from mysql database to the user via excel
> files. I'm using the following class to do this:
>
> private function output_file(){
>                 //output the file to the user
>                 header("Content-Type: application/vnd.ms-excel;
> name='excel'");
>                 header("Content-Disposition: attachment;
> filename={$this->_file_name}");
>                 header("Pragma: no-cache");
>                 header("Expires:0");
>                 echo "{$this->_export_string}";
>                 exit();
>         }
>
> This works perfectly on localhost, but when I move it to my www site, it
> outputs the data onto the screen.
>
> I've tried using "header('Content-Type: application/octet-stream');" as
> well, with the same results.
>
> All help is appreciated!
>
> Best Regards -
>
> Rick
> ============
> MFR Holdings, LLC
> rick at click-rick.net
> 201.755.4083
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20080115/48372661/attachment.html>


More information about the talk mailing list