<?php

$accountNumber = isset($_GET["id"]) ? (int)$_GET['id'] : null;

if (!$accountNumber) {
    die("Specify account number");
}
$dbHost = 'localhost';
$dbName = 'testdb';
$dbUser = 'testUser';
$dbPassword = 'testPassword';

$dsn = sprintf('host=%s;dbname=%s;charset=utf-8', $dbHost, $dbName);

try {
    $db = new PDO($dsn, $dbUser, $dbPassword);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
} catch (PDOException $e) {
    die("Could not connect: " . $e->getMessage());
}

$currentDate = new DateTime();
$requiredStatus = 1;

$query = "SELECT status, date FROM account WHERE accountnumber = " . $accountNumber." AND date > ".$currentDate->format('Y-m-d')." AND status = ".$requiredStatus;
try {
    $statement = $db->query($query);
} catch (PDOException $e) {
    die("Could not successfully run query ($query) from DB ");
}

if (!(bool)$statement->rowCount()) {
    die("No rows found, nothing to print so am exiting");
}



$accounts = $statement->fetchAll();

foreach($accounts as $account){
echo $account->status;
}