<?php

// CONNECT TO DATABASE //
//$connect = mysql_connect("localhost","user","password");
//mysql_select_db("Database", $connect);

// SELECTED DATE //
$date = '2012/04/02';

// TXT FILE PATH //
$file_path = 'data.txt';

// OPEN TXT FILE //
$file = fopen($file_path,'r') or exit();

// READ FILE TO THE END //
while(!feof($file)) {
	
	// READ THE FILE LINE BY LINE AND SPLIT IT //
	$file_data = fgets($file);
	$line_string = preg_replace('/\s[\s]+/', '|', $file_data);
	$file_AGL_001 = explode('|', $line_string);
		if($file_AGL_001[6] == $date) {
			$No = $file_AGL_001[0];
			$Mchn = $file_AGL_001[1];
			$EnNo = $file_AGL_001[2];
			$Name = $file_AGL_001[3];
			$Mode = $file_AGL_001[4];
			$IOMd = $file_AGL_001[5];
			$DateTime = $file_AGL_001[6] .' '. $file_AGL_001[7];
			
			// DISPLAY DATA //
			echo '<pre>No:'. $No .' Mchn:'. $Mchn .' EnNo:'. $EnNo .' Name:'. $Name .' Mode:'. $Mode .' IOMd:'. $IOMd .' DateTime:'. $DateTime .'</pre>';
			
			// INSERT STATEMENT //
			//mysql_query("INSERT INTO table_name (date, id, time) VALUES ('$fdate', '$fid', '$ftime')");
		}

}

?>