Skip to content
Snippets Groups Projects
Select Git revision
  • 5bc30d2fa495cfaaf62b3f2e07ec6fa5a5b27d2f
  • master default protected
2 results

index.php

Blame
  • user avatar
    Philip authored
    5bc30d2f
    History
    Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    index.php 2.26 KiB
    <?php
    require_once("classes/SQL.php");
    include("include/_head.php");
    ?>
    
    <!-- Page Header -->
            <div class="row">
                <div class="col-lg-12">
                    <h1 class="page-header">Dashboard
                    </h1>
                </div>
            </div>
    
    <?php
    $sql = new SQL();
    $link = $sql->getLink();
    
    $query = "SELECT * FROM (tbl_register INNER JOIN tbl_parameter ON tbl_register.id = tbl_parameter.fid_register) INNER JOIN tbl_data ON tbl_parameter.id = tbl_data.fid_parameter WHERE tbl_register.id IN (SELECT max(id) FROM tbl_register group by clientAddress) AND tbl_data.id IN (SELECT max(id) FROM tbl_data group by fid_parameter) GROUP BY name";
    
    
    
    
    $result = $link->query($query);
    while($row = $result->fetch_assoc()) {
    
        echo '<!-- Projects Row -->
            <div class="row">
                <div class="col-lg-12">
                    <h3 class="page-header">'.$row["name"].'
                        <small>Secondary Text</small>
                    </h3>
                </div>
            </div>
            <div class="row">';
    
        
        $query2 = "SELECT * FROM (tbl_register INNER JOIN tbl_parameter ON tbl_register.id = tbl_parameter.fid_register) INNER JOIN tbl_data ON tbl_parameter.id = tbl_data.fid_parameter WHERE tbl_register.id = ".$row["fid_register"]." AND tbl_data.id IN (SELECT max(id) FROM tbl_data group by fid_parameter)";
        $result2 = $link->query($query2);
    
        while($row2 = $result2->fetch_assoc()) {
    
    
            echo '
                <div class="col-md-4 portfolio-item">';
    
                if ($row2["type"] == "string"){
                    echo '
                    <a href="details.php?param='.$row2["fid_parameter"].'">
                        <img class="img-responsive" src="img/table.png" alt="">
                    </a>';
                }else{
                    echo '
                    <a href="details.php?param='.$row2["fid_parameter"].'">
                        <img class="img-responsive" src="graph.php?param='.$row2["fid_parameter"].'" alt="">
                    </a>';
                }
                    echo '
                    <h3>
                        <a href="details.php?param='.$row2["fid_parameter"].'">'.$row2["param"].'</a>
                    </h3>
                    <p>'.$row2["value"].'</p>
                </div>';
        }
    
        echo '</div>
            <!-- /.row -->';
    }
    
    ?>
            
    
    
    
    <?php
    include("include/_foot.php");
    ?>