importFile() public method

Imports and parses a CSV file.
public importFile ( string $filename, boolean $header = false, string $sep = ',', string $quote = '', integer $fields = null, $import_mapping = [], string $charset = null, string $crlf = null ) : array
$filename string The name of the file to parse.
$header boolean Does the first line contain the field/column names?
$sep string The field/column separator.
$quote string The quoting character.
$fields integer The number or fields/columns.
$charset string The file's charset.
$crlf string The file's linefeed characters.
return array A two-dimensional array of all imported data rows. If $header was true the rows are associative arrays with the field/column names as the keys.
Horde_Data_Csv Class Documentation
Esempio n. 1
0
    public function testImportFile()
    {
        $data = new Horde_Data_Csv(new Horde_Data_Storage_Mock());
        $expected = array(array(0 => 'one', 1 => 'two', 2 => 'three four', 3 => 'five'), array(0 => 'six', 1 => 'seven', 2 => 'eight nine', 3 => 'ten'));
        $this->assertEquals($expected, $data->importFile(__DIR__ . '/fixtures/simple_dos.csv', false, ',', '', 4));
        $this->assertEquals($expected, $data->importFile(__DIR__ . '/fixtures/simple_unix.csv', false, ',', '', 4));
        $expected = array(array('one' => 'six', 'two' => 'seven', 'three four' => 'eight nine', 'five' => 'ten'));
        $this->assertEquals($expected, $data->importFile(__DIR__ . '/fixtures/simple_dos.csv', true, ',', '', 4));
        $this->assertEquals($expected, $data->importFile(__DIR__ . '/fixtures/simple_unix.csv', true, ',', '', 4));
        $expected = array(array('one' => 'four', 'two' => 'five"six', 'three' => 'seven
"eight"', '' => ''));
        $this->assertEquals($expected, $data->importFile(__DIR__ . '/fixtures/quotes1.csv', true, ',', '"', 4));
        $this->assertEquals($expected, $data->importFile(__DIR__ . '/fixtures/quotes2.csv', true, ',', '"', 4));
    }