BIM-Monitor/script/php/testSQL.php

<?php

$hostname = 'GMGIS\SQLEXPRESS';
$username = 'BIMuser';
$password = 'Component3444';
$db_name="BIMComponents";
$account = "maabim";
if(isset($_GET["username"]))
    $account = $_GET["username"];
try {
    $pdo = new PDO('sqlsrv:Server='.$hostname.';Database='.$db_name,$username,$password);
    $pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo $e;
    echo json_encode('Error connecting to the server.');
    die ();
}
$sth = $pdo->prepare('SELECT *
    FROM [BIMComponents].[dbo].[User_Account]
    WHERE [account] = ?');
$sth->execute(array($account));
$query = $sth->fetchAll();

/*$sql = "SELECT * FROM [BIMComponents].[dbo].[User_Account] WHERE [account] = '".$account."';";
        $query = $pdo->query($sql);
        $query->setFetchMode(PDO::FETCH_ASSOC);*/
        foreach ($query as $row){
            echo $row['userID'].'<br>';
            echo $row['account'].'<br>';
        }