อยากถามเรื่องการ import text file เข้าสู่ mysql (phpmyadmin) ครับ

<?php
require_once 'dbconnect.php';
$location_file=$_FILES['upload']['tmp_name'];
$name_file=$_FILES['upload']['name'];
$type_file=$_FILES['upload']['type'];
$size_file=$_FILES['upload']['size'];
$content = file_get_contents($_FILES['upload']['tmp_name']);
$handle = fopen($_FILES['upload']['tmp_name'],"r");
$lines = explode("\n", $content);

if($location_file==""){
	header("location:upload.php?msg=Please Choose the File");
}else if ($type_file == '.txt'){
	header("location:upload.php?msg=Upload file with .txt extension only");
}else if($size_file > 104857600){
	header("location:upload.php?msg=Max File Size is 100MB");
}
else{	$line = $lines;
		$customer = array();

	for($i=9;$i<count($line);$i++){  // วนรอบเพื่อแสดงผลข้อมูล
		$customer[$i] = $line[$i];
			
			$data[$i] = array(
		    'index' => trim(substr($customer[$i], 0, 9)),
			'name' => trim(substr($customer[$i], 10, 10)),  
			'op_mode' => trim(substr($customer[$i], 21, 3)),
			'ch_mode' => trim(substr($customer[$i], 33, 11)),
			'min_down' => trim(substr($customer[$i], 52, 2)),
			'max_down' => trim(substr($customer[$i], 59, 5)),
			'min_up' => trim(substr($customer[$i], 70, 2)),
			'max_up' => trim(substr($customer[$i], 76, 5)),
			); }
		
         // THIS IS THE PROBLEM,if this not commented then the loop will not work
		foreach($data as $data){
			$sql = "INSERT INTO report (profile_index, profile_name, operating_mode, channel_mode, min_down_rate, max_down_rate, min_up_rate, max_up_rate)"
			."VALUES ('{$data[0]}','{$data[1]}','{$data[2]}','{$data[3]}','{$data[4]}','{$data[5]}','{$data[6]}','{$data[7]}')";
				mysql_query($sql) or die ('insert error');
		}
		
		echo "<pre>";
		print_r($data);    //Checking the values
		echo "</pre>";
			 // mysqli_close($connect);
              //header("location:upload.php?msg=Upload Success!");
	}
	mysql_close($conndb);
?>

echo $sql;

$data[$i] = array(
		    'index' => trim(substr($customer[$i], 0, 9)),
			'name' => trim(substr($customer[$i], 10, 10)),  
			'op_mode' => trim(substr($customer[$i], 21, 3)),
			'ch_mode' => trim(substr($customer[$i], 33, 11)),
			'min_down' => trim(substr($customer[$i], 52, 2)),
			'max_down' => trim(substr($customer[$i], 59, 5)),
			'min_up' => trim(substr($customer[$i], 70, 2)),
			'max_up' => trim(substr($customer[$i], 76, 5)),
			); }

<title>Upload Success </title>
<?php
require_once 'dbconnect.php';
$location_file=$_FILES['upload']['tmp_name'];
$name_file=$_FILES['upload']['name'];
$type_file=$_FILES['upload']['type'];
$size_file=$_FILES['upload']['size'];
$content = file_get_contents($_FILES['upload']['tmp_name']);
$handle = fopen($_FILES['upload']['tmp_name'],"r");
$lines = explode("\n", $content);

if($location_file==""){
	header("location:upload.php?msg=Please Choose the File");
}else if ($type_file == '.txt'){
	header("location:upload.php?msg=Upload file with .txt extension only");
}else if($size_file > 104857600){
	header("location:upload.php?msg=Max File Size is 100MB");
}
else{	
		$line = $lines;
		$customer [] = array();

	for($i=9;$i<count($line);$i++){  // วนรอบเพื่อแสดงผลข้อมูล
		$customer[$i] = $line[$i];
			
			$data[$i] = array(
		    'index' => trim(substr($customer[$i], 0, 9)),
			'name' => trim(substr($customer[$i], 10, 10)),  
			'op_mode' => trim(substr($customer[$i], 21, 3)),
			'ch_mode' => trim(substr($customer[$i], 33, 11)),
			'min_down' => trim(substr($customer[$i], 52, 2)),
			'max_down' => trim(substr($customer[$i], 59, 5)),
			'min_up' => trim(substr($customer[$i], 70, 2)),
			'max_up' => trim(substr($customer[$i], 76, 5)),
			);
	}

		fclose($handle);
		
         // THIS IS THE PROBLEM,if this not commented then the loop will not work
			foreach($data as $data){
			$sql = "INSERT INTO report (node, profile_index, profile_name, operating_mode, channel_mode, min_down_rate, max_down_rate, min_up_rate, max_up_rate)"
			."VALUES ('$name_file','$data[index]','$data[name]','$data[op_mode]','$data[ch_mode]','$data[min_down]','$data[max_down]','$data[min_up]','$data[max_up]')";	
			mysql_query($sql) or die ('insert error');
		}	
		
			echo "เพิ่มข้อมูลในไฟล์ลงในฐานข้อมูลของเรียบร้อยแล้ว<br><br>";
			echo "<a href=upload.php><<== กลับหน้าเว็บการเพิ่มหรืออัปโหลดข้อมูล</a><br><br>";
			echo "<a href=show_data_node.php>ไปยังหน้าเว็บแสดงข้อมูล ==>></a>";
			
		
			
		//echo "<pre>";
		//print_r($data);    //Checking the values
		//echo "</pre>";

		
	}
	mysql_close($conndb);
?>