ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / wh / rd / VA_S_Y_RD

<?php

require __DIR__ . '/functions_csv_handle.php';

$folder_path='/home/centosnipponia/public_html/wh/rd/VA_S_Y_RD/';

check_for_updates($folder_path);
 function create_insert_db($filepath) {
	
  //echo $filepath;
$sql_delivery =//"INSERT INTO saleunitscapetown(ArticuloCodigo,AnoFactura,MesFactura,ArticuloDescripcion,ArticuloClasificacion1,Zona,Bodega,Cliente,Vendedor,FACTURA,FechaFactura,SemanaFactura,TrimestreFactura,Cantidad,Impuesto1Local,Impuesto1Dolar,TotalImpuestoLocal,vin) VALUES ";
"DROP TABLE IF EXISTS `sales_year_rd`;
CREATE TABLE IF NOT EXISTS `sales_year_rd` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `gxcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gxname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `moto_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `moto_group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_sold` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `units` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `turnover` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `sales_year_rd` (`gxcode`, `gxname`,`relcode`, `altcode`, `moto_description`,`moto_group`,`year_sold`, `units`,`turnover`) VALUES";
$max_rows=count_csv_rows($filepath);

if($max_rows>0){

$row_current_nbr=2;
$lines="";
$row_comma_separated="";
$first_row=false;//den exei epikefalides
fix_file($filepath);
$file = fopen($filepath,"r");
while($row_current_nbr<$max_rows+1)
				  {
					  $row_current_nbr=$row_current_nbr+1;
					  if($first_row) {
						  $first_row=false;
						  
						  fgetcsv($file);
							  } else
					  {
						  //echo fgetcsv($file)[0];
				  //$cleaned_row=str_replace(",","",);
				  $cleaned_row=str_replace("'","\'",fgetcsv($file)[0]);
				  //$cleaned_row=str_replace(",",";", $cleaned_row);
				  $row_array =explode(";",$cleaned_row);
				 // print_r($row_array);
			
				 $row_comma_separated="('".implode("','", $row_array)."'),";
//print_r($row_comma_separated);
				//echo ($row_comma_separated);
				  
					  }
 		$lines.= $row_comma_separated;			  
				  }
				  	
 
fclose($file);
$sql_delivery.=$lines;
$sql_delivery=substr_replace($sql_delivery,";",-1);

} else
	
	{
	$sql_delivery ="SELECT 1"; 	
	}

//echo $sql_delivery;

return $sql_delivery;
}

[+] ..
[+] imported
[-] functions_csv_handle.php [edit]
[-] sql_command_import_capetown.php [edit]
[-] .htaccess.disabled [edit]