Untitled


<?php
///DB
$Dserv = "localhost";
$Duser = "root";
$Dpass = "cgc_admin";
try {
    $conn = new PDO("mysql:host=$Dserv;dbname=planet", $Duser, $Dpass);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    //echo "DB Connected successfully <br>";
}
catch(PDOException $e)
{
    //echo "Connection failed: " . $e->getMessage();
}
$sql = "SELECT * FROM planet";
$stmt = $conn->prepare($sql);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

?>
<!DOCTYPE HTML>
<html>
<head>
    <title>Planet Errors</title>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap4.min.css">
    <script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.16/js/dataTables.bootstrap4.min.js"></script>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    <meta charset="UTF-8">
    <style>
.error {
    background: red;
    color: white;
}
</style>

</head>
<body>


<div style="padding: 20px" align="right">
    <form action="parser2.php" method="GET">მონაცემთა ბაზის:
    <input type="submit" name="act" value="UPDATE" style="margin-right: 10px;">
    <input type="submit" name="act" value="CLEAR">
    </form>
</div>


<table border="1" id="myTable" class="table">
    <thead>
    <tr>
        <th>IP</th><th>NUM</th><th>Rx E 1</th><th>Rx D 1</th><th>Tx E 1</th><th>Tx D 1</th>
        <th>Rx E 2</th><th>Rx D 2</th><th>Tx E 2</th><th>Tx D 2</th>
        <th>Rx E 3</th><th>Rx D 3</th><th>Tx E 3</th><th>Tx D 3</th>
        <th>Rx E 4</th><th>Rx D 4</th><th>Tx E 4</th><th>Tx D 4</th>
        <th>Rx E W0</th><th>Rx D W0</th><th>Tx E W0</th><th>Tx D W0</th>
        <th>Rx E W1</th><th>Rx D W1</th><th>Tx E W1</th><th>Tx D W1</th>
    </tr>
    </thead>
    <tbody>
            <?php
            foreach($result as $row){

$sql7 = "SELECT * FROM planet_log WHERE user=".$row['user'];
$stmt7 = $conn->prepare($sql7);
$stmt7->execute();
$result7 = $stmt7->fetch(PDO::FETCH_ASSOC);


                echo "<tr>
<td><a href='http://".$row['ip']."' target='_BLANK'> ".$row['ip']."</a></td>
<td><a href='http://portal.cgc.ge:8080/cgc/maininfo?phone=".$row['user']."' target='_BLANK'> ".$row['user']."</a></td>


if($row['lan1_rx_err'] != $result7['lan1_rx_err']) {


<td>".$row['lan1_rx_err']."-".$result7['lan1_rx_err']."</td>

<td>".$row['lan1_rx_drop']."</td>
<td>".$row['lan1_tx_drop']."</td>
<td>".$row['lan1_tx_drop']."</td>
<td class='error'>".$row['lan2_rx_err']."</td>
<td>".$row['lan2_rx_drop']."</td>
<td>".$row['lan2_tx_drop']."</td>
<td>".$row['lan2_tx_drop']."</td>
<td>".$row['lan3_rx_err']."</td>
<td>".$row['lan3_rx_drop']."</td>
<td>".$row['lan3_tx_drop']."</td>
<td>".$row['lan3_tx_drop']."</td>
<td>".$row['lan4_rx_err']."</td>
<td>".$row['lan4_rx_drop']."</td>
<td>".$row['lan4_tx_drop']."</td>
<td>".$row['lan4_tx_drop']."</td>
<td>".$row['WAN0_rx_err']."</td>
<td>".$row['WAN0_rx_drop']."</td>
<td>".$row['WAN0_tx_drop']."</td>
<td>".$row['WAN0_tx_drop']."</td>
<td>".$row['WAN1_rx_err']."</td>
<td>".$row['WAN1_rx_drop']."</td>
<td>".$row['WAN1_tx_drop']."</td>
<td>".$row['WAN1_tx_drop']."</td>

</tr>";
            }
            ?>
    </tbody>
</table>

<script>
    $(document).ready(function(){
       var table =  $('#myTable').DataTable({
            "pageLength": 100
        });
var rows = table
    .rows( function ( idx, data, node ) {
        return data.highlight ? true : false;
    } )
    .nodes();

$(rows).addClass('highlight');

    });


</script>

</body>
</html>