import.php

<?php

include 'dbConfig.php';
$row = 1;

if(isset($_POST['importSubmit']))
{
	$file = $_FILES['file']['tmp_name'];
	$csvFile = fopen($file,"r");
	while(($csv = fgetcsv($csvFile,1000,",")) !== FALSE)
	{
		$num = count($csv);
		if ($csv[0] != NULL) {
			$row++;
		$csv0 = explode("#", $csv[0]);
		}

		$tanggal = $csv[0];
		$waktu = $csv[1];
		$waktu_berakhir = $csv[2];
		$camera = $csv[3];
		$counter = $csv[4];
		$result = $csv[5];

		$db->query("INSERT INTO teest(tanggal,waktu,waktu_berakhir,camera,counter,result) VALUES ('$tanggal','$waktu','$waktu_berakhir','$camera','$counter')");


	}
	/*
			if($sql)
		{
			echo 'data uploaded';
		}
		*/
}