$username = 'my@email.com';
    $password = 'test';
    $stmt = $odbc->prepare("CALL dbo.uspGetLoginUserInformation(:username, :password)");
    $stmt->bindParam(':username', $username);
    $stmt->bindParam(':password', $password);
    $stmt->execute();

$stmt = $odbc->prepare("Exec uspGetLoginUserInformation @Username=:username, @Password=:password");

$params = array(array($date, SQLSRV_PARAM_IN),array($location, SQLSRV_PARAM_IN),array(3, SQLSRV_PARAM_IN));
$result = sqlsrv_query($sqldb, "{call Some_Stored_Procedure ( @base_date=?,@location=?,@plusdays=? )}", $params);

$q = "{call Some_Stored_Procedure ( @base_date=?,@location=?,@plusdays=? )}";
$params = array(array($date, SQLSRV_PARAM_IN),array($location, SQLSRV_PARAM_IN),array(3, SQLSRV_PARAM_IN));
$stmt = $CONN->prepare($q);
$stmt->execute($params);

$q = "{call Database.dbo.Some_Stored_Procedure ( @base_date=?,@location=?,@plusdays=? )}";
$params = array(array($date, SQLSRV_PARAM_IN),array($location, SQLSRV_PARAM_IN),array(3, SQLSRV_PARAM_IN));
$stmt = $CONN->prepare($q);
$stmt->execute($params);

$stmt = $CONN->prepare("Exec Database.dbo.Some_Stored_Procedure  ?, ?, 3");
$stmt->execute(array($date, $location));

CALL Some_Stored_Procedure(Param1, Param2, ...);

EXEC Some_Stored_Procedure Param1, Param2, ...;