<?php

//create table with header and column names

print('<table align="center" width="800">');
print('<tr><td colspan="6">Computer electronics</td></tr>');
print('<tr><td>Part</td><td>number</td><td>Product</td><td>Company</td>
<td>Link</td><td>Price</td></tr>');

//declare variable to count records
$rowcount = 0;

//get path to file assumming that file located in datafeed folder
$path_to_file="datafeed/filetoread.csv";

//open file for reading "r"
$handle = fopen($path_to_file, "r");

//read file line by line
while (($record = fgetcsv($handle, 1000, " ")) !== FALSE)
{

// read number of fields in one record
$numfields = count($record);

//Display all fields for debugging, to know which data is in which field.
//In real scv datafeed file of an affiliated program a lot of fields are stored
//data, that you do not need. Using output below you can see what fields to select
//to build your advertisement on your web page

<!---comment code below in production version--->

     for($i=0; $i<$numfields; $i++)
     {
     echo $i.":".$record[$i]."<br>";
     }
<!---end debugging part--->

//read field values in variable

     $part=$record[0];
     $number=$record[1];
     $product=$record[2];
     $company=$record[3];
     $clicklink=$record[4];
     $price=$record[5];

//skip the first record since it has field headers only
   if($rowcount > 0)
   {
   //if record has link to item display it in the table row

     if($record[3] !="")
     {
print('<tr><td>'.$part.'</td><td>'.$number.'</td><td>'.$product.'</td>
<td>'.$company.'</td>
<td><a href="'$clicklink.'">'.$product.'</a></td>'.$price.'</td></tr>');
     }

   }

$rowcount++;

}

fclose($handle);

print('</table>');

?>