Error when output binary data with PHP

Question

I write a simple php to load some binary data from DB then output to client.

    $sql="select FightPlayEnd from ZMTXLogic.FightLog where ID=".addslashes($id);
    $result=$db->query($sql);

    if($db->num_rows($result)>0)
    {

        $row = mysql_fetch_assoc($result);
        $nByteCount = mb_strlen($row["FightPlayEnd"], '8bit');
        //echo $nByteCount;

        header("Content-type:application/octet-stream");
        header("Accept-Ranges:bytes");
        header("Accept-Length:".$nByteCount);
        header("Content-Disposition:attachment;filename=FightPlayEnd.bin");
        header( "Content-type: application/octet-stream");

        echo $row["FightPlayEnd"];
    }

The problem is the data got from IE is not same as original binary data but added EF BB BF(view in UltraEdit) at the header and 0D 0A 0D 0A at the end. What is wrong with it?

Dennis · Accepted Answer · 2011-10-20 02:59:50Z

4

0D 0A 0D 0A is just \r\n\r\n, that is, two linebreaks.

EE BB BF is a byte order mark. It signals UTF-8 encoding.

Edit (see comments):

Your script might be outputting more than it should (particularly those \r\n\r\n).

You need to clean the output buffer before you start outputting the data (ob_clean()) and exit right after your echo.

edited Oct 20, 2011 at 2:59

answered Oct 20, 2011 at 2:39

Dennis

14.5k3 gold badges51 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ben Over a year ago

@Spark I would add to this, your script might be outputting more than it should (particularly those \r\n\r\n). You need to clean the output buffer before you start outputting the data (ob_clean()) and exit right after your echo

Spark Over a year ago

@Ben Oh, you are perfectly right! Thank you very much! May be you can add a answer to my question, so I can accept you：）

Ben Over a year ago

@Spark Maybe you should give Dennis the answer credit for pointing us all in the right direction..

Spark Over a year ago

@Dennis Would you edit your answer and append what Ben said to it? So I can accept your answer.

Collectives™ on Stack Overflow

Error when output binary data with PHP

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related