[SOLVED] Read Text File Line by Line

[stevesimo]

Hi, I have been given a textfile which contains data on 1000 businesses.  Each line contains a name and a code which are seperated by a comma.  The code below allows me to display the entire textfile but I want to read in the values from each line and store these in a database.

 

$filename = "businesses.txt";
$fileToOpen = fopen($filename,"r");
$content = fread($fileToOpen, filesize($filename));
$content = nl2br($content);
fclose($fileToOpen);
echo($content);

 

Does anyone know how I can read the data in line by line so that I can store it in a database.

 

Thanks, Steve

[trq]

file. eg;

 

<?php

  $file = file("business.txt");
  foreach ($file as $line) {
    echo $line."\n";
  }

?>

[stevesimo]

I managed to do this using a while loop which continues until the end of the file is encountered.  Then read a line at a time using fgets() function

 

while(!feof($fp)){ 
  $line = fgets($fp, 1024); 
}

 

Thanks for the help

 

Steve