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
        )
)

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

Kushan · Accepted Answer · 2016-10-13 11:11:59Z

1

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);

answered Oct 13, 2016 at 11:11

Kushan

10.7k4 gold badges39 silver badges41 bronze badges

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

Comments

d3vdpro · Accepted Answer · 2016-10-13 11:18:31Z

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, 2016 at 11:18

d3vdpro

3,0474 gold badges26 silver badges31 bronze badges

1 Comment

RST Over a year ago

this is a comment, not an answer

black · Accepted Answer · 2016-10-13 11:48:35Z

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

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related