How to Display CSV file content in Controller as an Array?

Question

I am trying to display CSV data to array or something as an output using Zend Framework 2

I have created "hello world" module and the controller calls works fine.

CSV File location is data/csv/Foo.csv

Below is my controller:

public function indexAction()
{
  $filename = 'data/csv/Foo.csv';
  $useFirstRecordAsHeader = true;
  $delimiter = ',';
  $enclosure = '"';
  $escape = '\\';
  $this->file = new SplFileObject($filename);
  $this->file->setFlags(SplFileObject::READ_CSV | SplFileObject::READ_AHEAD | SplFileObject::SKIP_EMPTY | SplFileObject::DROP_NEW_LINE);

  $this->file->setCsvControl($delimiter, $enclosure, $escape);

  $this->useFirstRecordAsHeader = $useFirstRecordAsHeader;

   return $this;
    
}

But right now I am getting the error:

SplFileObject::__construct(csv/Foo.csv): failed to open stream: No such file or directory

My CSV file is in the same folder controller/csv/Foo.csv

How to read a CSV file content and display as output array or any other format? I want to do it using Zend Framework 2 only.

Please try to keep csv/Foo.csv inside public folder and try again. — user3438016
– user3438016, Commented Dec 30, 2016 at 9:00

Community · Accepted Answer · 2017-04-13 12:36:24Z

4

You are trying to open $this->file = new SplFileObject('csv/Foo.csv');, since you are using a relative path, on execution time that wont resolve to the folder where your controller is at (it will probably resolve to [yourprojectroot]/csv/Foo.csv).

If you really wanted to store this csv in controller/csv, you should use something like:

 $this->file = new SplFileObject(dirname(__FILE__) . '/csv/Foo.csv');

But, saving that csv there is bad for a several reasons. First you'd need to grant write permission to your webserver to be able to write in that directory, and you'd be fundamentally messing up with your data/code structure (data and code shouldn't reside together, but in easily separated silos).

Better, create a folder "data" and and another folder "csv" in your projects directory, give your webserver permission to write there (chmod || chown, other methods), and do something like:

 $file = 'data'. DIRECTORY_SEPARATOR . 'csv' . DIRECTORY_SEPARATOR . 'Foo.csv' ;
 $this->file = new SplFileObject($file );

Besides that, I'm not sure what you are returning actually makes sense. Try something like:

public function indexAction()
{
    $filename = 'data' . DIRECTORY_SEPARATOR . 'csv' . DIRECTORY_SEPARATOR . 'Foo.csv';;
    $this->file = new SplFileObject($filename);
    $this->file->setFlags(SplFileObject::READ_CSV | SplFileObject::READ_AHEAD | SplFileObject::SKIP_EMPTY | SplFileObject::DROP_NEW_LINE);

    $this->file->setCsvControl(',', '""', '\\');
    $this->useFirstRecordAsHeader = true;

    $response = $this->getResponse();
    $headers  = $response->getHeaders();
    $headers->addHeaderLine('Content-Type', 'text/csv');

    $contents = $this->file->fread($this->file->getSize());

    $response->setContent($contents);
    return $response;
}

edited Apr 13, 2017 at 12:36

CommunityBot

11 silver badge

answered Dec 30, 2016 at 9:34

yivi

48.2k18 gold badges133 silver badges157 bronze badges

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

5 Comments

Manthan Dave Over a year ago

thanks for your answer , i have puted csv file in data directory now i guess its open but thing is i am getting blank output. not getting data . I have updated the question with updated code please help me ?

Manthan Dave Over a year ago

What i need to print to get csv file data ?

yivi Over a year ago

This will output the CSV as is... the "output as array" is kinda weird. What exactly do you want to accomplish?

Manthan Dave Over a year ago

no worries i get the output what i want , just last question where to define this DIRECTORY_SEPARATOR ? as you have mention in controller but exactly where it define ?

yivi Over a year ago

You don't have to define DIRECTORY_SEPARATOR. Is already defined. php.net/manual/en/dir.constants.php

Al Foиce ѫ · Accepted Answer · 2016-12-30 09:23:05Z

3

You should not put your csv directory in the Controller directory, as it is not a controller. It's against the MVC architecture. The good practise is to put data in the data directory, under your root directory, at the same level as your module directory.

So assuming you have it on this data directory, you can simply write:

$this->file = new SplFileObject('data/csv/Foo.csv');

or better (for portability):

$filename = 'data'. DIRECTORY_SEPARATOR . 'csv' . DIRECTORY_SEPARATOR . 'Foo.csv' ;
$this->file = new SplFileObject($filename );

answered Dec 30, 2016 at 9:23

Al Foиce ѫ

4,33112 gold badges44 silver badges51 bronze badges

Collectives™ on Stack Overflow

How to Display CSV file content in Controller as an Array?

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related