Transfer file between two csv with php -
i tried code in way. writes part of first csv in sec don't understand because doesn't not re-create all. why? // sopprimo gli errori del php //error_reporting(0);
// includo la libreria require_once 'excel_reader2.php'; $file_handle = fopen("satconcluse.csv", "r"); while (!feof($file_handle) ) { $line_of_text = fgetcsv($file_handle, 0); $arr = array('nr sat' => $line_of_text[0],'data apertura' => $line_of_text[13], 'tipo servizio' => $line_of_text[1], 'stato sat' => $line_of_text[2],'marca terminale' => $line_of_text[4], 'modello terminale' => $line_of_text[5], 'imei guasto' => $line_of_text[6],'imei consegnato' => $line_of_text[7],'famiglia guasto' => $line_of_text[8],'descrizione guasto' => $line_of_text[9] ); $data[] = $arr; } fclose($file_handle); $file = fopen("eccomiquacisono.csv","w"); foreach ($data $arr){ fputcsv($file,$arr); } fclose($file);
use fgetcsv load file in array, , carry on processing. if areusing php5, can set sec parameter 0 whole line:
$line_of_text = fgetcsv($file_handle, 0); likewise, utilize fputcsv save individual records in csv file. in code, trying fill in file empty array. meant add together each $arr in $data sequentially:
$data[] = $arr; and loop on each entry , set in other file:
foreach ($data $arr) fputcsv($file,$arr); the whole code be:
$data = array(); while (!feof($file_handle) ) { $line_of_text = fgetcsv($file_handle, 0); $arr = array(...); $data[] = $arr; } fclose($file_handle); $file = fopen("eccomiquacisono.csv","w"); foreach ($data $arr) fputcsv($file,$arr); fclose($file); php
No comments:
Post a Comment