Php explode function returning empty values

Question

I am trying to read data from a comma separated text file called test.txt using PHP. The file contents is as follows:

Sel,10,5,4
Tati,5,6,7
Vinny,10,10,10

I tried to read these values using a loop with fgets(), which is used to print line by line and fgets() and explode(), which are supposed to write element per element in each line.

<?php
    $file=fopen('test.txt','r');

    if(!$file)
    {
        echo "Error reading file";
        die;
    }

    echo"Reading Line by Line";

    while(!feof($file))
    {
          $pointer=fgets($file,4096);
          echo "<p>".$pointer."<p>";    
    }

    rewind($file);

    echo "Reading value by value per line";

    while(!feof($file))
    {
          $pointer=fgets($file,4096);
          $pieces = explode(",", $pointer);
          echo"<hr>";
          echo "<p> Name:".$pieces[0]."<p>";
          echo "<p> Grade 1:".$pieces[1]."<p>";
          echo "<p> Grade 2:".$pieces[2]."<p>";
          echo "<p> Grade 3:".$pieces[3]."<p>";
          echo"<hr>";
    }   
    fclose($file);
?>

However, when I use fgets() and explode() functions in php there is a line printed with no values. This is strange, as I have only three lines in my text file and when I use fgets() without explode() it returns the values in the correct number of lines.

What is wrong in this code?

Edit: here is my code

is the line with no values at the beginning or end of your result? Is it possible you have a line break at the end of your text file? — Sean
– Sean, Commented Apr 1, 2016 at 16:08
If you use SPLFileObject and treat this csv file as a csv file, you have options too ignore empty lines — Mark Baker
– Mark Baker, Commented Apr 1, 2016 at 16:10

Death-is-the-real-truth · Accepted Answer · 2016-04-01 17:13:20Z

1

@Mad i test your code and got that problem is because of  tag is not closed inside loop, So close them and your problem will solve:-

<?php
$file=fopen('test.txt','r');

if(!$file)
{
    echo "Error reading file";
    die;
}

echo"Reading Line by Line";

while(!feof($file))
{
      $pointer=fgets($file,4096);
      if(strlen($pointer) !==0){
        echo "<p>".$pointer."</p>";
      }       
}

rewind($file);

echo "Reading value by value per line";

while(!feof($file))
{
      $pointer=fgets($file,4096);
      $pieces = explode(",", $pointer);
      if(strlen($pointer) !==0){
          echo"<hr>";
          echo "<p> Name:".$pieces[0]."</p>";
          echo "<p> Grade 1:".$pieces[1]."</p>";
          echo "<p> Grade 2:".$pieces[2]."</p>";
          echo "<p> Grade 3:".$pieces[3]."</p>";
          echo"<hr>";
      }
}   
fclose($file);
?>

Output:- at my local PC:- http://prntscr.com/amufst

Note:- my text file have no empty lines in starting as well as ending.

edited Apr 1, 2016 at 17:13

answered Apr 1, 2016 at 16:23

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

7 Comments

mad Over a year ago

I repeated your code and it is still not working. I will check my cache.

mad Over a year ago

How do I check if there are empty lines in my text file?

mad Over a year ago

Here is the console output: Reading Line by LineSel,10,5,4 Tati,5,6,7 Vinny,10,10,10 Reading value by value per line<hr> Name:Sel Grade 1:10 Grade 2:5 Grade 3:4 <hr><hr> Name:Tati Grade 1:5 Grade 2:6 Grade 3:7 <hr><hr> Name:Vinny Grade 1:10 Grade 2:10 Grade 3:10 <hr><hr> Name: Grade 1: Grade 2: Grade 3:<hr>

Death-is-the-real-truth Over a year ago

lot of possibility:- $pieces = explode(",", $pointer); if(count($pieces) <=0){empty lines} or $pointer=fgets($file,4096);if(strlen($pointer) ==0){empty line}

Death-is-the-real-truth Over a year ago

Take my code, remove empty lines from text file, and check first by clearing cache of your browser.

|

Collectives™ on Stack Overflow

Php explode function returning empty values

1 Answer 1

7 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Related