forward_station_server_fss/api/v1/ShiftTankReport/shiftTankReport3.php

<?php 
require "connectionDb.php";

$date = $_GET['selectDateToFind'];
$date = str_replace('-', '_', $date);
$shiftnum = 3;
$shiftTankReport3 = $db->query("SELECT * FROM shift_tank_vw WHERE date='$date'");

while ($row = $shiftTankReport3->fetchArray()) {
if ($row['number']==$shiftnum) {
    echo "<div style='display: none;'>".
    print_r("<tr>
        <th>Tank Number</th>
        <th>Product Text</th>
        <th>Open Volume</th>
        <th>Close Volume</th>
        <th>Open Water Volume</th>
        <th>Close  Water Volume</th>
        <th>Open Level</th>
        <th>Close Level</th>
        </tr>")
  ."</div>";
}
if ($row['number']==$shiftnum) {
  print_r(
  "<tr>"
  ."<td>".$row['tank_id']."</td>"
  ."<td>".$row['product_text']."</td>"
  ."<td>".decimalAndNumberFormat1($row['open_vol'])."</td>"
  ."<td>".decimalAndNumberFormat1($row['close_vol'])."</td>"
  ."<td>".decimalAndNumberFormat1($row['open_water_vol'])."</td>"
  ."<td>".decimalAndNumberFormat1($row['close_water_vol'])."</td>"
  ."<td>".decimalAndNumberFormat2($row['open_level'])."</td>"
  ."<td>".decimalAndNumberFormat2($row['close_level'])."</td>"
  ."</tr>"
);
}
}
 ?>