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);