PHP header text/csv unwanted line feed character

05-10-2010

Registered User

1, 0

Join Date: May 2010

Last Activity: 12 May 2010, 1:58 PM EDT

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

PHP header text/csv unwanted line feed character

We have successfully created a comma delimited file, the results are correct from an sql database query. When using the following headers to print the file using print $data, an extra line feed is added and a blank row appears on the top of the data in Excel:

Code:

    header("Expires: 0");
    header("Cache-Control: private");
    header("Pragma: cache");
    header("Content-type: text/csv");    
    header("Content-Disposition: attachment; filename=test.csv");
    print $data;

Note: this character is not in $data itself, but appears after the above headers are sent. Does anyone know why this new line feed character is added and how to remove? Thanks in advance for your help.

Last edited by Scott; 05-10-2010 at 07:08 PM.. Reason: Please use code tags

ifimbres

View Public Profile for ifimbres

Find all posts by ifimbres

PDO.QUERY(3) 1 PDO.QUERY(3) PDO
::query - Executes an SQL statement, returning a result set as a PDOStatement object SYNOPSIS
public PDOStatement PDO::query (string $statement) DESCRIPTION
PDOStatement PDO::query (string $statement, int $PDO::FETCH_COLUMN, int $colno) PDOStatement PDO::query (string $statement, int $PDO::FETCH_CLASS, string $classname, array $ctorargs) PDOStatement PDO::query (string $statement, int $PDO::FETCH_INTO, object $object) PDO.query(3) executes an SQL statement in a single function call, returning the result set (if any) returned by the statement as a PDOStatement object. For a query that you need to issue multiple times, you will realize better performance if you prepare a PDOStatement object using PDO.pre- pare(3) and issue the statement with multiple calls to PDOStatement.execute(3). If you do not fetch all of the data in a result set before issuing your next call to PDO.query(3), your call may fail. Call PDOState- ment.closeCursor(3) to release the database resources associated with the PDOStatement object before issuing your next call to PDO.query(3). Note Although this function is only documented as having a single parameter, you may pass additional arguments to this function. They will be treated as though you called PDOStatement.setFetchMode(3) on the resultant statement object. PARAMETERS
o $statement - The SQL statement to prepare and execute. Data inside the query should be properly escaped. RETURN VALUES
PDO.query(3) returns a PDOStatement object, or FALSE on failure. EXAMPLES
Example #1 Demonstrate PDO::query A nice feature of PDO.query(3) is that it enables you to iterate over the rowset returned by a successfully executed SELECT state- ment. <?php function getFruit($conn) { $sql = 'SELECT name, color, calories FROM fruit ORDER BY name'; foreach ($conn->query($sql) as $row) { print $row['name'] . " "; print $row['color'] . " "; print $row['calories'] . " "; } } ?> The above example will output: apple red 150 banana yellow 250 kiwi brown 75 lemon yellow 25 orange orange 300 pear green 150 watermelon pink 90 SEE ALSO
PDO.exec(3), PDO.prepare(3), PDOStatement.execute(3). PHP Documentation Group PDO.QUERY(3)

Shell Programming and Scripting

PHP header text/csv unwanted line feed character

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find header in a text file and prepend it to all lines until another header is found

Discussion started by: verdepollo

2. UNIX for Beginners Questions & Answers

How to change name of the file with first line of the file which has some unwanted text in it?

Discussion started by: Sekhar419

3. Shell Programming and Scripting

How to remove unwanted commas from a .csv file?

Discussion started by: ranjancom2000

4. Shell Programming and Scripting

Insert text line to specific location CSV

Discussion started by: whyte_rhyno

5. Shell Programming and Scripting

new line after n'th character in text file

Discussion started by: Amit.saini333

6. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Discussion started by: Shiny_Roy

7. Shell Programming and Scripting

Remove line feed from csv file column

Discussion started by: r_t_1601

8. Shell Programming and Scripting

Remove line feed from csv file column

Discussion started by: r_t_1601

9. Shell Programming and Scripting

unwanted control character in the input

Discussion started by: jeff_cen

10. Shell Programming and Scripting

replace last form feed with line feed

Discussion started by: prvnrk

LEARN ABOUT PHP

pdo.query