Wednesday, 15 April 2015

Transfer file between two csv with php -



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