$filearr=file('sub.txt');
if (!file_exists('sub.txt')) echo 'такого файла нет';
foreach($filearr as $line)
{
$elements=explode("|",$line);
$sroks=$elements[0];
$srokdo=$elements[1];
$otsrok=$elements[2];
$dataotsrok=$elements[3];
$email=$elements[4];
$blok=$elements[5];
$tel=$elements[6];
$name=$elements[7];
$company=$elements[8];
$info=$elements[9];
$tarif=$elements[10];
$oplata=$elements[11];
$login=$elements[12];
$pass=$elements[13];
$query=sprintf("INSERT INTO sub(sroks,srokdo,otsrok,dataotsrok,email,blok,tel,name,company,info,tarif,oplata,login,pass)
VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
$sroks,$srokdo,$otsrok,$dataotsrok,$email,$blok,$tel,$name,$company,$info,$tarif,$oplata,$login,$pass);
if(mysql_query($query,$link)) echo(""); else echo("<font color=red><b>Error: </b></font><font color=green><b>".mysql_error($link)."</b></font>");
}
|