<?php
$id = array("2140","1220","1971","3292","3444","3520","2716","3326","3304","3515","2659","2710","3397","2925","3126","2675","1181","0956");
$name = array();

$serverName = "GMGIS\SQLEXPRESS"; //test server 201
   $username = 'BIMuser';
   $password = 'Component3444';
   $dbname = 'BIMComponents';
   
   $connectionInfo = array("Database"=>"$dbname", "UID"=>"$username", "PWD"=>"$password", "CharacterSet"=>"UTF-8");
   $conn = sqlsrv_connect($serverName, $connectionInfo);
   if($conn === false){
	   die(print_r(sqlsrv_errors(), true));
   }
   foreach($id as $value){
    $account = 'maa'.$value;
    $password = md5('maa'.$value.'BIM');
    $sql = "INSERT INTO [BIMComponents].[dbo].[User_Account] ([userID],[account],[userPassword]) VALUES ('".$value."','".$account."','".$password."')";
    //sqlsrv_query($conn, $sql);
    //$fetchResult = sqlsrv_query($conn, $sql);
   }
   
   
      
    sqlsrv_close($conn); 

?>