banjalukaforum.com

<?
ini_set('memory_limit', '900M');
set_time_limit(0);
       $dbName = "Blog";
     $host = "localhost";
     $user = "root";
     $pass = "";
     mysql_connect($host,$user,$pass) or die("Coudln't connect to database");
     mysql_select_db($dbName) or die("DB error");
 
  $fcontents = file ('cities5000.txt');
  # expects the csv file to be in the same dir as this script

  for($i=0; $i<sizeof($fcontents); $i++) {
      $line = trim($fcontents[$i]);



      $arr = explode(',', $line);
       $c=0;
          foreach ($arr as $value)
{
     $arr[$c]=mysql_real_escape_string($value);
     $c++;
}
      #if your data is comma separated
      # instead of tab separated,
      # change the '\t' above to ','

      $sql ="insert into hotels(field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18) values ('".implode("','",$arr) ."')";
      mysql_query($sql);
      echo $sql ."<br>\n";
      if(mysql_error()) {
         echo mysql_error() ."<br>\n";
      }
}
?>