JSFiddle - React, Tailwind, and code Playground
by Gonzalo
JavaScript
<?php
$fileName = "analisis.csv";
$fp = fopen( $fileName , 'r' );
$space = 0;
$data = array();
$data_arr = array();
$date_arr = array();
$twon = "";
$brand = "";
while($csv_line = fgetcsv($fp,2084)){
# echo "<br/>Count:";
#echo $j = count($csv_line)."<br/> ";
#echo "<br/><br/>";
$space = 0;
foreach ($csv_line as $key => $value) {
if($value){
if($space==2 && $key >= 1){
#echo "<br/>space 2: ". $space."<> :-".$value;
$date_arr[] = $value;
}
elseif( $space==1 && $key >= 1 ){
if($key==1){
#echo "<br/>space:1 key:1 ". $space."<> :-".$value;
$brand = $value;
}
else{
#echo "<br/>space:1 key:!1 ". $space."<> :-".$value;
$data_arr['value'] = $value;
$data_arr['town'] = $town;
$data_arr['brand'] = $brand;
$data_arr['date'] = $date_arr[$key-2];
}
}
elseif ( $space==0 && $key==0 ) {
#echo "<br/>space:0 ".$space."<> :-".$value;
$town = $value;
}
else{
}
}
else{
$space++;
}
if(sizeof( $data_arr )){
$data[] = $data_arr;
}
}
}
echo "<pre>";print_r( $data ); echo "</pre>";
?>