Importing a txt file to MySQL Database using PHP script 1

// open database connection

$conn = mysql_connect("localhost", "$user", "$pass");
echo "Connected to database : $conn<br>";
mysql_select_db("nameofdb", $conn);

// open csv file

$filename = "mycvsfile.csv";
$fp = fopen($filename, "r") or die("Failed to open flat file");
echo "Opened flat file ok...<br>";
flock($fp, LOCK_EX); // lock the file while we got it open

// the first line of the csv usually contains
// the descriptions of the columns. We don't want
// to write this into the db so set a flag
$firstline = true;

// now we read each line and write that to the database
while (!feof($fp)){
  if ($firstline) {
    // skip this iteration of the while loop
    // and carry on with next line
    $firstline = false;
    continue;
  }

  // read this line
  $line = fgets($fp,16384);

  // remove any ' and replace with `
  $line = str_replace("'", "`", $line);
  
  // next split this line into it's componates
  $delim = ",";
  $data = explode($delim, $line);
  // now $data will be an array contining
  // all the fields. eg the first field will be
  // $data[0] and the second $data[1] etc
  // do any processing you want with these now
  
    
  // now we have all the luvly data ...
  $sql = "insert into tablename values (";
  $sql .= $data[0] . ", " ;  // a numberic value
  $sql .= "'" . $data[1] . "', "; // a string
  $sql .= "'" . $data[2] . "')"; // the last value

  // remember that string value must be enclosed in
  //  quotes ' and numeric don't


  echo "Inserting item: <br> ";
  $result = mysql_query($sql, $conn) or die (mysql_error());
   
 }

echo "all done we hope! <br>";

mysql_close($conn); // close db connection
flock($fp, LOCK_UN); // unlock the file