<?php 
#gemaakt door marijn Bos//
?>
	
	<?php
	function import()
	{
		 global $g_type;
		?>  
	   <div id="paneel">
<?php 


//connect to the database
include"include/connect_voorkant.php";
//


if ($_FILES[csv][size] > 0) {


	//get the csv file
	$file = $_FILES[csv][tmp_name];
	$handle = fopen($file,"r");
	
	//loop through the csv file and insert into database
	do {
    	if ($data[0]) {
        	$sql=("INSERT INTO materiaal (artikelcode_leverancier, afnamegroep, leveranciersomschrijving, ingangsdatum, deeplink_productinfo, aantal_prijseenheden_per_prijs, bruto_prijs) VALUES
			(
                 	'".addslashes($data[0])."',


         	'".addslashes($data[1])."',


         	'".addslashes($data[2])."',
         	
'".addslashes($data[3])."',


                    '".addslashes($data[4])."',


                    '".addslashes($data[5])."'


'".addslashes($data[6])."'
            	)
        	");
			mysql_query($sql);
    	}
	} while ($data = fgetcsv($handle,10000,",","'"));
	if (mysql_query($sql))
  {
  echo "Data is upgeload";
  }
else
  {
  echo "Error Uploaden is niet gelukt!: " . mysql_error();
  }
	//
	
	//redirect 
	?>
   <a href="http://www.q-bouwbestek.nl/admin/admin.php?actie=import">Ga terug</a>
<?
}


?> 
<?php if (!empty($_GET[success])) { echo "<b>Uw bestand is upgeload.</b><br><br>"; } //generic success notice ?>


<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
  Upload uw bestand: <br />
  <input name="csv" type="file" id="csv" />
  <input type="submit" name="Submit" value="Submit" />
</form>
<?
	}
	?>

<?php 
#gemaakt door marijn Bos//
?>
	
	<?php
	function import()
	{
		 global $g_type;
		?>  
	   <div id="paneel">
<?php 


//connect to the database
include"include/connect_voorkant.php";
// ?>
	<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
  	Upload uw bestand: <br />
  	<input name="csv" type="file" id="csv" />
  	<input type="submit" name="Submit" value="Submit" />
	</form>
	
	<?
	if ($_FILES[csv][size] > 0) {


	$csv_file = $_FILES[csv][tmp_name];
	$csvfile = fopen($csv_file, 'r');
	$theData = fgets($csvfile);
	$i = 0;
	while ($thedata = fgetcsv($csvfile,10000));
	$csv_array = explode(",", $csv_data[$i]);
	$insert_csv = array();
	$insert_csv['artikelcode_leverancier'] = $csv_array[0];
	$insert_csv['afnamegroep'] = $csv_array[1];
	$insert_csv['leveranciersomschrijving'] = $csv_array[2];
	$insert_csv['ingangsdatum'] = $csv_array[3];
	$insert_csv['deeplink_productinfo'] = $csv_array[4];
	$insert_csv['aantal_prijseenheden_per_prijs'] = $csv_array[5];
	$insert_csv['bruto_prijs'] = $csv_array[6];
	
	$query = "INSERT INTO materiaal(artikelcode_leverancier, afnamegroep, leveranciersomschrijving, ingangsdatum, deeplink_productinfo, aantal_prijseenheden_per_prijs, bruto_prijs)
	VALUES('".$insert_csv['artikelcode_leverancier']."','".$insert_csv['afnamegroep']."','".$insert_csv['leveranciersomschrijving']."','".$insert_csv['ingangsdatum']."','".$insert_csv['deeplink_productinfo']."','".$insert_csv['aantal_prijseenheden_per_prijs']."','".$insert_csv['bruto_prijs']."')";
	$n=mysql_query($query);
	$i++;
	}
	if (mysql_query($query))
  	{
  	echo "Data is upgeload";
  	}
	else
	{
  	echo "Error Uploaden is niet gelukt!: " . mysql_error();
	}
	fclose($csvfile);
	}
?>