Datagrid Widget

@FILE assets/files/board.csv

DATE,EQ, FROM - ST, FROM CITY, TO CITY, TO ST
10/17/05,FDT,AL,MONTEVALLO,PIGGOTT,AR
10/20/05,FDT,AL,PINE APPLE ,PIGGOTT,AR
10/18/05,S/D ONLY,CA,SAN DIEGO,CORTEZ,CO

if (file_exists($modx->config['base_path'].$CSVf)) 
  {$csvlines = file($modx->config['base_path'].$CSVf); } 
  else return "Not found $modx->config['base_path'].$CSVf" ; 

$csvout = '<table border=1 cellspacing=0 cellpadding=3>';
foreach ( $csvlines as $line ) 
{
  $csv=explode(',',$line); $line='<tr><td>'.implode('</td><td>',$csv).'</td></tr>';
  $csvout=$csvout.$line;
}

return $csvout.'</table>';

// open the uploaded file
$handle = fopen($uploadfile, "r") or die("unable to open file");
// read it and generate the query...
while($data = fgetcsv($handle, 10000, ",")) { 
   $num = count($data); // how many items?
   $row++;
   $sql = "INSERT INTO $table VALUES ('','$client',";
   for($c=0; $c < $num; $c++) {  // for each row...
    $sql .= "'";
     $sql .= mysql_real_escape_string($data[$c]); 
     $sql .= "',";
   }
   $sql = substr($sql, 0, -1); // drop the last comma
   $sql .= ")"; // add the close of the query
// insert the data

   @mysql_query($sql) or die(mysql_error());
}
fclose($handle);