text file

[onthespot]

I have a text file, which consists of many rows of data.

Each row has a name and a number. 2 fields therefore.

How can I insert this into my database ?

[onedumbcoder]

$filename= "data.txt";
$filehandler = fopen($filename, 'r');
$filedata= fread($filehandler, filesize($filename));
fclose($filehandler);
$rows = explode("\n", $filedata);
$first = true;
foreach ($rows as $row) {
   $rowdata = explode('/\s+/', $row);
   if(!$first)
      $insertvalues .= ", ";
   $insertvalues .= "('" . $rodata[0] . "', '" . $rowdata[1] . "');
   $first = false;
}
mysql_query("INSERT into table(name, id) VALUES(" . $insertvalues . ")");

 

[abazoskib]

or if you want to do it much quicker, use LOAD LOCAL DATA INFILE..check it out in the mysql online docs