importcsv.php

<?php
include 'dbconfig.php';

if(isset($_POST['submit']))
{

	$file = $_FILES['file']['tmp_name'];

	$handle = fopen($file,"r");

	while (($filecsv = fgetcsv($handle,1000,",")) !==false)
	{
		$tanggal = $filecsv[0];
		$waktu   = $filecsv[1];
		$waktu_berakhir = $filecsv[2];
		$camera  = $filecsv[3];
		$counter = $filecsv[4];
		$result = $filecsv[5];
		$sql =mysql_query("INSERT INTO csv_coba (tanggal,waktu,waktu_berakhir,camera,counter,result) VALUES (
			'$tanggal','$waktu','$waktu_berakhir','$camera','$counter','$result') ");
	}


}

?>

<html lang= en>
<head>
	<meta charset="utf-8">
	<title>test</title>
</head>
<body>
	<form method="post" action="import.php" enctype="multipart/form-data">
		<input type="file" name="file"/>
		<br>
		<input type="submit" name="submit" value="Submit">
	</form>