使用php和简单的html dom将数据导出到CSV文件

Question

How to export grabbed data to .csv file? I'm using php simple html dom to parse data. Here is the code:

foreach ($linkoviStranica as $stranica)
{
    $podaciStranice = "http://someurl/$stranica";

    $data = file_get_html($podaciStranice);


    $name = $data->find('div[class="price-card-name-header-name"]');
    $onlinePrice = $data->find('div[class="price-box online"]');
    $diffPrice = $data->find('div[class="price-box paper"]');

     echo "<strong>".$name[0]->innertext."<strong>"."<br>";
      if (!empty($onlinePrice[0]->innertext))
      { 
        echo $onlinePrice[0]->innertext."<br>";
      }
     if (!empty($diffPrice[0]->innertext))
     {  
         echo $diffPrice[0]->innertext."<br>";

         echo "---------------------"."<br>";

     }
 }

I want to export, $name, $onlinePrice, $diffPrice to csv file with header in the following format:

name    onlinePrice diffPrice
example    10          44
xxxx       412        461
zzzzz     1414         41

Could you please help me? Thanks!

Answer 1

Something like this:

// Define a array to hold all the data
$data = [];

// OR use this line if you want the headers with names on the first line of the file
// $data = [['name', 'onlinePrice', 'diffPrice']];

// Loop the raw data
foreach ($linkoviStranica as $stranica) {
    $podaciStranice = "http://someurl/$stranica";
    $data = file_get_html($podaciStranice);

    $name = $data->find('div[class="price-card-name-header-name"]');
    $onlinePrice = $data->find('div[class="price-box online"]');
    $diffPrice = $data->find('div[class="price-box paper"]');

    // Add current row to out array
    $data[] = [
        $name[0]->innertext,
        $onlinePrice[0]->innertext,
        $diffPrice[0]->innertext
    ];
}

// Open a new file. Replace the file name with the name you'd like
$fp = fopen('file.csv', 'w');

// Loop each row in the data array
foreach ($data as $fields) {
    // This method converts a row to a CSV line (http://php.net/manual/en/function.fputcsv.php)
    fputcsv($fp, $fields);
}

// Close the file handler
fclose($fp);