<?

include "db.class.php";

$db = new db();

$res = $db->exec_query('device_log', ['*'], '', '', '', '', "device_id = 'F01' AND text = 'AUTH CHECK'", "ORDER BY record_id DESC");
$row = $res->fetch_assoc();
echo $row['date_time'] . " | " . $row['text'] . " | " . $row['record_id'] . "<br>";
$res = $db->exec_query('device_log', ['*'], '', '', '', '', "device_id = 'F01' AND text = 'TANK LEVEL UPDATE'", "ORDER BY record_id DESC");
$row = $res->fetch_assoc();
echo $row['date_time'] . " | " . $row['text'] . " | " . $row['record_id'] . "<br>";
$res = $db->exec_query('device_log', ['*'], '', '', '', '', "device_id = 'F01' AND text = 'REQUEST SETTINGS'", "ORDER BY record_id DESC");
$row = $res->fetch_assoc();
echo $row['date_time'] . " | " . $row['text'] . " | " . $row['record_id'] . "<br>";