Help with text file reading.

mrbaseball34

I need to read a file with this format and be able to parse it to
place each field into a new mySQL query to insert into a table.:

field1
field2
.
.
.
..
fieldn

How would I loop this file to read each field into a variable and
stop when the blank line is reached, insert the record and then
begin again until the eof?

dewen

try this

$f = @fopen ('data_test', "r") or die ('file not found'); 

while (!feof($f)) 
{ 

   /* Get file content, one line at a time */ 
   $line = trim(fgets($f, 1024)); 

   if (empty($line)){

	/**
	 * if fields is read
	 * do SQL here
	 */
	if (isset($arr_x)){

		// sql ...		
		echo 'sql process ... <BR>';

	}

	unset($arr_x);

   }else{

   $arr_x[] = $line;
   echo 'adding fields '.$line.' ... <BR>';
   }
}