"$dbname", "UID"=>"$username", "PWD"=>"$password", "CharacterSet"=>"UTF-8"); $conn = sqlsrv_connect($serverName, $connectionInfo); if($conn === false){ die(print_r(sqlsrv_errors(), true)); } for ($i = 0; $i < count($txtTable); $i++) { $sql = "INSERT INTO [BIMComponents].[dbo].[API_Table] ([APIName] ,[software] ,[detail] ,[revitVersion] ,[operate] ,[type] ,[keyword] ,[source] ,[notes] ,[filePath] ) VALUES ('".$txtTable[$i][0]."' ,'".$txtTable[$i][1]."' ,'".$txtTable[$i][2]."' ,'".$txtTable[$i][3]."' ,'".$txtTable[$i][4]."' ,'".$txtTable[$i][5]."' ,'".$txtTable[$i][6]."' ,'".$txtTable[$i][7]."' ,'".$txtTable[$i][8]."' ,'".$txtTable[$i][9]."' );"; //sqlsrv_query($conn, $sql); echo($sql."
"); } sqlsrv_close($conn);