<?php
require('routeros_api.class.php');
require('config.php');


$conn = new mysqli($db_host, $db_user, $db_pass, $db_name);
$nome = 'router1';
$interface_monitorada = "sfp-sfpplus1 - ALGAR";

#foreach ($roteadores as $r) {

    $API = new RouterosAPI();

    if ($API->connect('192.168.0.212', 'monitor', 'vo1234@')) {

        $res = $API->comm('/interface/print', [
            '?name' => $interface_monitorada
        ]);

        if (isset($res[0])) {
            $rx = $res[0]['rx-byte'];
            $tx = $res[0]['tx-byte'];

            $stmt = $conn->prepare("INSERT INTO trafego_interface (roteador, interface, rx, tx) VALUES (?, ?, ?, ?)");
            $stmt->bind_param("ssii", $nome, $interface_monitorada, $rx, $tx);
            $stmt->execute();
        }

        $API->disconnect();
    }
#}