Importing Data

[Anon]

Let's say there is a file named data.txt and it has the following contents in it:

john, smith, 2222 fake dr
sally, sue, 7982 home ave
guy, montag, 8551 lovers lane

now i want to add it into a database..... i know how to do it if there is only one row but how do i do it for multiple rows from ONE file?

[nashirak]

try:

$fp = fopen("data.txt", "r");

while(!feof($fp)) {

// This gets the line up till the \n
// Or until the buffer limit 1024 is reached

$line = fgets($fp,1024);

$nice = explode(",",$line);

// I use mysql but you can do whatever. 🙂

$query = "Insert into blah values('nice[1]', nice[2],'nice[3]')";

MYSQL_QUERY($query);

}// end while

So basically its just like adding 1 row... just do it in a loop. 🙂