php reading csv data into a single line

Question

It's strange PHP Reading my Excel generated CSV file into a single line. Code is:

if ($file) {
                while (($line = fgets($file)) !== false) {
                    print '<div>'.$line.'</div>'."<br/>";
                }

            } else {
                // error opening the file.
            }

            fclose($file);

CSV

Name, City
Jon,Paris
Doe,Madrid

You can try my CSV parser (special for big data and line by line): github.com/DeepVarvar/PHP-CSV-Parser-Writer/blob/master/… — Deep
– Deep, Commented Jan 8, 2016 at 19:51

aayush93 · Accepted Answer · 2016-01-08 19:57:29Z

2

Add this code before reading the file.

ini_set("auto_detect_line_endings", true);

When turned on, PHP will examine the data read by fgets() and file() to see if it is using Unix, MS-Dos or Macintosh line-ending conventions.

This enables PHP to interoperate with Macintosh systems, but defaults to Off, as there is a very small performance penalty when detecting the EOL conventions for the first line, and also because people using carriage-returns as item separators under Unix systems would experience non-backwards-compatible behaviour.

answered Jan 8, 2016 at 19:57

aayush93

991 silver badge3 bronze badges

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

Comments

jbafford · Accepted Answer · 2016-01-08 19:52:12Z

1

Most likely, PHP is not correctly detecting the line endings in your file. The fgets documentation points this out.

You will probably want to write code like this:

$oldLineEndings = ini_set('auto_detect_line_endings', true);

//your while loop here

ini_set('auto_detect_line_endings', $oldLineEndings);

If you need to actually parse the csv, you may also want to look at fgetcsv.

answered Jan 8, 2016 at 19:52

jbafford

5,6681 gold badge27 silver badges38 bronze badges

Collectives™ on Stack Overflow

php reading csv data into a single line

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related