<?php

$serverName = "10.10.1.26"; //serverName\instanceName
$connectionInfo = array( "Database"=>"M_local", "UID"=>"ds", "PWD"=>"qwerty1");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
    echo "Connection established.
";
}else{
     echo "Connection could not be established.<br/>";
     die( print_r( sqlsrv_errors(), true));
} 

 $fn=$_SERVER['DOCUMENT_ROOT']."/calc/brand.txt";
    //echo $fn;
	if ( file_exists($fn))
    {

      $fp = fopen($fn, "r");
      $trig=0;
     
	  while (!feof($fp))
      {
        $mytext = trim(fgets($fp, 99));
        $query = "insert into [M_Local].[dbo].[Ru_I] (dark) values ('".$mytext."')";
       
		echo $query."<br>";
      
            if( sqlsrv_query( $conn, $query))
       {
          echo "Statement executed.\n";
       } 
       else
       {
         echo "Error in statement execution.\n";
         die( print_r( sqlsrv_errors(), true));
       }

/* Free connection resources. */
sqlsrv_close( $conn);
		 
        echo "done";
      }

      fclose($fp);
	 } 
?>