How to convert CSV file's table values in Array?

Question

I have below value in 1st Column of My CSV file

<table border="1">
<tr>
    <th align="left">First Name</th>
    <th align="left">Gender</th>
    <th align="left">Nationality</th>
</tr>
<tr>
    <td align="left">Mike</td>
    <td align="left">M</td>
    <td align="left">Singaporean</td>
</tr>

I already followed: Read each line of txt file to new array element

How to convert above CSV file to Array. So output will be

Array
(
    [0] => Array
        (
            [0] => First Name
            [1] => Gender
            [2] => Nationality
        )

    [1] => Array
        (
            [0] => Mike
            [1] => M
            [2] => Singaporean
        )
)

http://stackoverflow.com/questions/7502370/converting-csv-to-array go through this article may be it will resolve your problem — Adi, Oct 13 '16 at 11:13

score 1 · Answer 1 · answered Oct 13 '16 at 11:11

HTML representation to php array using DOMDocument::saveHTML

Refer this example code:

$htmlString = '
    <td align="left">Mike</td>
    <td align="left">M</td>
    <td align="left">Singaporean</td>
';

$dom = new DOMDocument;
$dom->loadHTML($htmlString);
foreach($dom->getElementsByTagName('td') as $node)
{
    $arrayTd[] = $dom->saveHTML($node);
}

print_r($arrayTd);

score 0 · Answer 2 · answered Oct 13 '16 at 11:18

0

You can use any csv reading library also. For example this one - http://csv.thephpleague.com/basic-usage/ . the manipulation through libraries will be very easy

answered Oct 13 '16 at 11:18

d3vdpro

2,887
4
25
29

this is a comment, not an answer – RST Oct 13 '16 at 11:26

score 0 · Answer 3 · answered Oct 13 '16 at 11:48

you need the folde and location as param to pick the file and you can use simpleExcel lib for parsing CSV like this

function parseCSV($location,$folder){
    $excel = new SimpleExcel('CSV');

    try{
      $csv=$excel->parser->loadFile($location);
    }catch (Exception $ex){
      $logger->info($ex->getMessage());
    }

    $j = 1;
    /****column name ****/
    if($excel->parser->isRowExists($j)){
        $cols = $excel->parser->getRow($j);
    }

    $i=2;
    $arrval = array();
    /***csv data****/
    while($excel->parser->isRowExists($i)){
        $data=$excel->parser->getRow($i);
    }
}

use this function and pass required param then do var_dump($cols) and var_dump($data). this is not tested but will work

How to convert CSV file's table values in Array?

3 Answers3

Linked