Read file

[dreamwest]

Im trying import a txt file line by line

 

Heres the txt file:

 

one

two

three

four

five

 

etc...

 

Basically i want to import this into my database:

 

$file_names = '/home/htdocs/file_names.txt';

$sql = "INSERT INTO `forum` SET `username`='ghost' ";
$result = mysql_query($sql) or die(mysql_error());

 

 

[MasterACE14]

you can use file_get_contents();

[everisk]

If you want to read line by line you can

 

$fd = fopen ($file_names, "r");
while (!feof ($fd))
{
   $buffer = fgets($fd, 1024);
   $sql = "INSERT INTO `forum` SET `username`='$buffer' ";
   $result = mysql_query($sql) or die(mysql_error());
}

fclose ($fd);