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'].'
';
echo $row['account'].'
';
}