<?php 
include 'classes/db.class.php'; 
?>
<!DOCTYPE html>
<html>

<head>
    <title>Log</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 0;
        }

        table {
            width: 100%;
            border-collapse: collapse;
            margin: 0 auto;
        }

        th,
        td {
            padding: 8px;
            border: 1px solid #ddd;
        }

        th {
            background-color: #f2f2f2;
        }
    </style>
</head>

<body>
    <?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "log";

    $db = new db();
    $result = $db->exec_query('operations',['*'],'','','','',"1","ORDER BY record_id DESC LIMIT 500");

    if ($result->num_rows > 0) {
        echo "<table><tr><th>ID</th><th>operation</th><th>datetime_ini</th><th>datetime_done</th><th>Status</th></tr>";
        while ($row = $result->fetch_assoc()) {
            echo "<tr><td>" . $row["record_id"] . "</td><td>" . $row["operations"] . "</td><td>" . $row["datetime_ini"] . "</td><td>" . $row["datetime_done"] . "</td><td>" . $row["status"] . "</td></tr>";
        }
        echo "</table>";
    } else {
        echo "0 results";
    }

    ?>
</body>

</html>