function getLatestSQLHealthReport()
{
$client_code = $_SESSION['clt_code'];
$con = databaseConnectionOpen();
if ((!isset($_SESSION['shr_key']) || trim($_SESSION['shr_key']) == '') && !($client_code == '')) {
date_default_timezone_set('America/Chicago');
$today = date('Y-m-d H:i:s');
if ($result = mysqli_query($con, "SELECT shr.shr_key,\n shr.clt_client_code,\n shr.shr_date\n FROM tblSQLHealthReport shr\n WHERE shr.clt_client_code = '" . $client_code . "'\n AND shr.shr_date = (SELECT MAX(lastreport.shr_date)\n FROM tblSQLHealthReport lastreport\n WHERE lastreport.clt_client_code = shr.clt_client_code)")) {
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
$_SESSION['shr_key'] = $row['shr_key'];
}
}
}
mysqli_free_result($result);
}
databaseConnectionClose($con);
}
<?php
//used to ajax set/update session variables
session_start();
$_SESSION['clt_code'] = $_POST["session_clt_code"];
$_SESSION['shr_key'] = $_POST["session_shr_key"];
$con = databaseConnectionOpen();
if ($con) {
//get latest SQL Health Report for client
if ((!isset($_SESSION['shr_key']) || trim($_SESSION['shr_key']) == '') && !($client_code == '')) {
$client_code = $_SESSION['clt_code'];
date_default_timezone_set('America/Chicago');
$today = date('Y-m-d H:i:s');
if ($result = mysqli_query($con, "SELECT shr.shr_key,\n shr.clt_client_code,\n shr.shr_date\n FROM tblSQLHealthReport shr\n WHERE shr.clt_client_code = '" . $client_code . "'\n AND shr.shr_date = (SELECT MAX(lastreport.shr_date)\n FROM tblSQLHealthReport lastreport\n WHERE lastreport.clt_client_code = shr.clt_client_code)")) {
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
$_SESSION['shr_key'] = $row['shr_key'];
$shr_key = $row['shr_key'];
}
}
}
mysqli_free_result($result);
}
}
databaseConnectionClose($con);
