BIM-Monitor/script/php/importData.php

<?php
    $curObjectName = "";
    $curWellName = "nothing";

    if (isset($_POST["objectName"])) {
      $curObjectName = (string) $_POST["objectName"];
      
      $serverName = "engdig\AUTODESKVAULT";
      $username = 'BIMuser';
      $password = 'Component3444';
      $dbname = 'C3';
      
      $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));
      }
      $sql = "INSERT INTO well(wellName) VALUES ('$curObjectName')";
      sqlsrv_query($conn, $sql);

      sqlsrv_close($conn);
    }

  ?>