Export data z csv to csv

Export data z csv to csv

~ Anonymní uživatel
~ 61 příspěvků

8. 6. 2017 #1

Ahojte poradí mi niekto ?
Script mi funguje tak ako ma ale neviem ako správne zapísať do kódu aby mi vyexportoval údaje do CSV

Poradíte mi prosím ?

<html>
<head>
<title>Export</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<h1>Export</h1>
<form target="_blank" action="" method="post" enctype="multipart/form-data">
<input type="file" name="file" />
<input type="submit" value="Nahrat na server" />
</form>				
</body>
</html>
<?php
function str_getcsv4($input, $delimiter = ';', $enclosure = '"') {
    if( ! preg_match("/[$enclosure]/", $input) ) {
      return (array)preg_replace(array("/^\\s*/", "/\\s*$/"), '', explode($delimiter, $input));
    }
    $token = "##"; $token2 = "::";
    $t1 = preg_replace(array("/\\\[$enclosure]/", "/$enclosure{2}/",
         "/[$enclosure]\\s*[$delimiter]\\s*[$enclosure]\\s*/", "/\\s*[$enclosure]\\s*/"),
         array($token2, $token2, $token, $token), trim(trim(trim($input), $enclosure)));

    $a = explode($token, $t1);
    foreach($a as $k=>$v) {
        if ( preg_match("/^{$delimiter}/", $v) || preg_match("/{$delimiter}$/", $v) ) {
            $a[$k] = trim($v, $delimiter); $a[$k] = preg_replace("/$delimiter/", "$token", $a[$k]); }
    }
    $a = explode($token, implode($token, $a));
    return (array)preg_replace(array("/^\\s/", "/\\s$/", "/$token2/"), array('', '', $enclosure), $a);
}

function zmaz(){	
$files = glob('directory/data.csv'); 
foreach($files as $file){
    if(is_file($file))
    unlink($file);
	}	
}

zmaz();


if(isset($_FILES['file'])) {    
 							 if(@move_uploaded_file($_FILES['file']['tmp_name'], 'directory/data.csv')) {	 
											
											
											$data = array_map('str_getcsv4', file('directory/data.csv'));
								
											 $hlava = "customer_name;customer_street;customer_zipcode;customer_city;customer_country_ID;customer_phone;customer_email;customer_type;parcel_type;parcel_weight;parcel_order_number;parcel_reference;parcel_COD;parcel_COD_amount;parcel_COD_variable_symbol;parcel_COD_currency\n";
											
											foreach($data as $key=>$value)
											{		
												if ($key != 0) {
													$meno = ($value[1]); //19
													$ulica = ($value[20]);
													$psc = ($value[25]);
													$mesto = ($value[23]);
													$krajina = ($value[26]);
													$phone = ($value[27]);
													$email = ($value[4]);
													$vs  = ($value[0]);
														
														
														
							// v takomto poradí    to ma byť vypisané 		echo''.$meno.';'.$ulica.';'.$psc.';'.$mesto.';'.$krajina.';'.$phone.';'.$email.';B;D;1;'.$vs.';'.$vs.';N;;;N';'';
							//zalomiť riadok								echo "\n";
												
												}
										}
																		
								}								
 else 
	 echo 'Chyba pri uploadu';
}

zmaz();
?>

Nahlásit jako SPAM

IP: 2a02:ab04:540:100:452c:8b...–

peter

~ Anonymní uživatel
~ 4016 příspěvků

8. 6. 2017 #2

php.net/fputcsv

<?php

$file = "file.csv";

$list = array(
    array('John A. Smith'  , 'San Francisco', 19),
    array('Bob I. Uncle'   , 'Los Angele'   , '789'),
    array('"Joan K. Jones"', '"New York"')
    );

$fp = fopen($file, 'w');

foreach ($list as $row) {
    fputcsv($fp, $row);
    }

fclose($fp);

echo '<pre>'; var_dump($list);

?>

<?php

$file = "file.csv";

$list = array();

if (($fp = fopen($file, "r")) !== false) {
    while (($row = fgetcsv($fp, 1000, ",")) !== false) {
        $list[] = $row;
        }
    fclose($fp);
    }

echo '<pre>'; var_dump($list);

?>

Nahlásit jako SPAM

IP: 2001:718:2601:26c:11f0:1c...–