<?php
$file_name = 'ad.txt';
$link2 = mysql_connect('localhost','xxxx','xxxxx',TRUE);
mysql_selectdb('xxxxxxx',$link2);

if (($handle_f = fopen($file_name, "r")) !== FALSE)
{
  // проверяется, надо ли продолжать импорт с определенного места
  // если да, то указатель перемещается на это место
  if(isset($_GET['ftell'])){
      fseek($handle_f,$_GET['ftell']);
  }
  $i=0;
  if(isset($_GET['x'])){
      $x=$_GET['x'];
  } else {
      $x = 0;
  }
  // построчное считывание и анализ строк из файла
  $xs = 0;
  $idmy = 0;
   while ( ($data_f = fgetcsv($handle_f, 65536, "^"))!== FALSE) {
	$data_f[] = $list;
	$insert_q = 'INSERT INTO `1s` VALUES ('.$x.',\''.$data_f[$xs][0].'\',\''.$data_f[$xs][1].'\',\''.iconv("windows-1251","UTF-8",$data_f[$xs][2]).'\',\''.iconv("windows-1251","UTF-8",$data_f[$xs][3]).'\',\''.iconv("windows-1251","UTF-8",$data_f[$xs][4]).'\',\''.iconv("windows-1251","UTF-8",$data_f[$xs][5]).'\',\''.$data_f[$xs][6].'\',\''.$data_f[$xs][7].'\',\''.$data_f[$xs][8].'\',\''.$data_f[$xs][9].'\',\''.$data_f[$xs][10].'\',\''.$data_f[$xs][11].'\',\''.$data_f[$xs][12].'\',\''.$data_f[$xs][13].'\',\''.$data_f[$xs][14].'\',\''.$data_f[$xs][15].'\',\''.iconv("windows-1251","UTF-8",$data_f[$xs][16]).'\')';
	
	 mysql_query($insert_q);

      if(!strstr($i/5000,'.')){
		sleep(30);
	    mysql_ping($link2);
      }

    $x++;
    $i++;
	$idmy++;
	$xs++;
  }
  fclose($handle_f);
} else {$err = 1; echo "Не получилось открыть файл";}
?>

<?php
class File_FGetCSV {

	function fgetcsv($f, $length, $d=",", $q='"') {
		$list = array();
		$st = fgets($f, $length);
		if ($st === false || $st === null) return $st;
		while ($st !== "" && $st !== false) {
			if ($st[0] !== $q) {
				# Non-quoted.
				list ($field) = explode($d, $st, 2);
				$st = substr($st, strlen($field)+strlen($d));
			} else {
				# Quoted field.
				$st = substr($st, 1);
				$field = "";
				while (1) {
					# Find until finishing quote (EXCLUDING) or eol (including)
					preg_match("/^((?:[^$q]+|$q$q)*)/sx", $st, $p);
					$part = $p[1];
					$partlen = strlen($part);
					$st = substr($st, strlen($p[0]));
					$field .= str_replace($q.$q, $q, $part);
					if (strlen($st) && $st[0] === $q) {
						# Found finishing quote.
						list ($dummy) = explode($d, $st, 2);
						$st = substr($st, strlen($dummy)+strlen($d));
						break;
					} else {
						# No finishing quote - newline.
						$st = fgets($f, $length);
					}
				}

			}
			$list[] = $field;
		}
		return $list;
	}

	function fputcsv($f, $list, $d=",", $q='"') {
		$line = ""; 
		foreach ($list as $field) { 
			# remove any windows new lines, 
			# as they interfere with the parsing at the other end 
			$field = str_replace("\r\n", "\n", $field); 
			# if a deliminator char, a double quote char or a newline 
			# are in the field, add quotes 
			if(ereg("[$d$q\n\r]", $field)) { 
				$field = $q.str_replace($q, $q.$q, $field).$q; 
			}
			$line .= $field.$d; 
		}
		# strip the last deliminator 
		$line = substr($line, 0, -1); 
		# add the newline 
		$line .= "\n"; 
		# we don't care if the file pointer is invalid, 
		# let fputs take care of it 
		return fputs($f, $line); 
	}
}

$x=0;
$cfg_File = '/var/www/httpdocs/dump/sklad.txt';

$link2 = mysql_connect('localhost','xxxx','xxxx',TRUE);
mysql_selectdb('xxxxxxx',$link2);
mysql_query("SET NAMES utf8");

if (($handle_f = fopen($cfg_File, "r")) !== FALSE) {
  $i=0;
  while ($list = File_FGetCSV::fgetcsv($handle_f, 65536, "^")) {
 
	$insert_q = 'INSERT INTO `1s_aug` VALUES ('.$x.',\''.$list[0].'\',\''.$list[1].'\',\''.iconv("windows-1251","UTF-8",$list[2]).'\',\''.iconv("windows-1251","UTF-8",$list[3]).'\',\''.iconv("windows-1251","UTF-8",$list[4]).'\',\''.iconv("windows-1251","UTF-8",$list[5]).'\',\''.$list[6].'\',\''.$list[7].'\',\''.$list[8].'\',\''.$list[9].'\',\''.$list[10].'\',\''.$list[11].'\',\''.$list[12].'\',\''.$list[13].'\',\''.$list[14].'\',\''.$list[15].'\',\''.iconv("windows-1251","UTF-8",$list[16]).'\')';
	
	 mysql_query($insert_q);

      if(!strstr($i/5000,'.')){
		sleep(30);
	    mysql_ping($link2);
      }

    
      $x++;
      $i++;

  }

  fclose($handle_f);
} else {$err = 1; echo "Не получилось открыть файл";}
?>