How to transfer data to mysql from .txt file

[tony007]

Hi all i got a txt file that has a list of urls i want to transfer this to a table in mysql but i do not know how. I have phpmyadmin and mysql installed . Could an expert show me an easy and fast way to store these urls in a database.
The text file hast the urls in this format :


http://www.localhost.com/file1.rm
http://www.localhost.com/file2.rm
http://www.localhost.com/file3.rm
http://www.localhost.com/file4.rm
.......................
.......................


Thanks

[lintz]

This should give you an idea....

$fc=file("yourfile.txt");

//loop through file
foreach($fc as $LineInfo) {
//Add your code for inserting a record into your database here
} 

[tony007]

This should give you an idea....

$fc=file("yourfile.txt");

//loop through file
foreach($fc as $LineInfo) {
//Add your code for inserting a record into your database here
} 

Thank u for u reply. could u tell me how to refere to each line url in mysql statment? insert into tablename values ( ????)

[sciguyryan]

Thank u for u reply. could u tell me how to refere to each line url in mysql statment? insert into tablename values ( ????)

Something like this (pesuadocode):

<?php
  // Presuming you have connected to the DB already...
  $Contents = file('yourfile.txt');

  foreach($Contents as $Line) {
    $Query = mysql_query("INSERT INTO `tblName` (`ID`, `URL`) VALUES('', '" . $Line . "');");
    if (mysql_error($Query)) {
      echo mysql_error($Query);
    }
  }

Cheers,

Ryan Jones

[tony007]

Something like this (pesuadocode):

<?php
  // Presuming you have connected to the DB already...
  $Contents = file('yourfile.txt');

  foreach($Contents as $Line) {
    $Query = mysql_query("INSERT INTO `tblName` (`ID`, `URL`) VALUES('', '" . $Line . "');");
    if (mysql_error($Query)) {
      echo mysql_error($Query);
    }
  }

Ryan Jones

Thank u for u reply. I keep getting the following error :

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in \text2mysql.php on line 29

an pointing at this line :

if (mysql_error($Query)) {

i got like 2000 records in the text file but only 500 get inserted and it stoped with that error. could u help me fix that.Thanks

Cheers,

[sciguyryan]

Thank u for u reply. I keep getting the following error :

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in \text2mysql.php on line 29

an pointing at this line :

if (mysql_error($Query)) {

i got like 2000 records in the text file but only 500 get inserted and it stoped with that error. could u help me fix that.Thanks

Cheers,

That can be removed anyway, its only there for error checking :-)

Try this instead (The variable is not required):

<?php 
  // Presuming you have connected to the DB already... 
  $Contents = file('yourfile.txt'); 

  foreach($Contents as $Line) { 
    $Query = mysql_query("INSERT INTO `tblName` (`ID`, `URL`) VALUES('', '" . $Line . "');"); 
    if (!empty(mysql_error())) { 
      echo mysql_error(); 
    } 
  } 
?>

That should work fine presuming each URL is in a file each on its own line.

Cheers,

Ryan Jones