//
// Server Name from calling form
$servername = "localhost";
//
// Database Name from calling form
$db_name = "monmon;
//
// username to use
$username   = "readonly";
// password to use
$password   = "readonly";
// Create connection
$conn = new mysqli($servername, $username, $password, $db_name);
// Check connection and play the result
if ( ! $conn ) {
    die("Connection failed: " . $mysqli_error());
}
// build the SQL to perform the select
//$sql = "SELECT Count(DISTINCT `id_evento`) as id_event_count, id_evento ,count(`event_type`) as event_type_count, event_type, `source`, `timestamp` FROM `tevento` GROUP BY `event_type`";
//SELECT * , AVG(p_event_count) as a FROM `p_stats` WHERE `p_event_type` = 'going_unknown'
//SELECT * , AVG(p_event_count) as a FROM `p_stats` GROUP BY `p_event_type`
//SELECT * , AVG(p_event_count) as a FROM `p_stats` GROUP BY `p_source_server`, `p_event_type`
//SELECT * , AVG(p_event_count) AS a, MAX(p_event_count)AS b, MIN(p_event_count) AS c FROM `p_stats` GROUP BY `p_event_type`
//SELECT `p_source_server`,`p_event_timestamp`, MIN(p_event_timestamp) AS a, MAX(p_event_timestamp) AS b FROM `p_stats` GROUP BY `p_source_server`
//SELECT `p_source_server`,`p_event_type`,`p_event_timestamp`, MIN(p_event_timestamp) AS a, MAX(p_event_timestamp) AS b FROM `p_stats` GROUP BY `p_source_server`, `p_event_type`
//SELECT `p_source_server`,`p_event_type`, SUM(p_event_count) AS p_e_count, MIN(p_event_timestamp) AS p_e_first, MAX(p_event_timestamp) AS p_e_last FROM `p_stats` GROUP BY `p_source_server`, `p_event_type`
//SELECT p_event_id, p_event_type, p_event_count FROM p_stats ORDER BY `p_event_id` ASC, p_event_type ASC
//SELECT p_event_type, p_event_count FROM p_stats GROUP BY p_event_type ASC
//SELECT p_event_type, p_event_count,AVG(p_event_count) AS a, MAX(p_event_count)AS b, MIN(p_event_count) AS c FROM p_stats GROUP BY p_event_type ASC
//SELECT COUNT(DISTINCT p_event_type),p_event_type, p_event_count, count(p_event_count) AS occurrence, MIN(p_event_timestamp) AS a, MAX(p_event_timestamp) AS b FROM p_stats GROUP BY p_event_type
sql$ = "SELECT COUNT(DISTINCT p_event_type),p_event_type, p_event_count, count(p_event_count) AS occurrence, MIN(p_event_timestamp) AS a, MAX(p_event_timestamp) AS b FROM p_stats GROUP BY p_event_type";"
//test for result
$result = mysqli_query($conn, $sql);
//
// if you have results do the following
if (mysqli_num_rows($result) > 0) {
    //
    //// do page top
    //
    //
    // this routine displays the Distinct Rows and their counts for a Pandora DB
    //
    // init a counter to top of page
    //
    $pagectr = 0;
    // output data of each row
    while($row = $result->fetch_assoc()) {
       
        // Do the table header if you are starting a page
        if ($pagectr == 0){
            // Recovery description display
            echo '<table style="font-family:Arial, sans-serif;width:100%;border:2px solid #ddd;border-radius:7px;padding:8px;height:25px;background-color:lightgray;text-align:center">'; 
            echo '<tr>';
            echo '<th><p class="p3">Ststistics for Pandora Metadata from: ' . $servername . "  Database Name: " . $db_name . ' Table Name: p_stat</p></th>';
            echo '</tr>';
            echo '</table>';
            // Headers for table
            echo '<table style="font-family:Arial, sans-serif;width:100%;border:2px solid #ddd;border-radius:7px;padding:8px;height:25px;background-color:lightgray;text-align:center">'; 
            echo '<col width="14%">';
            echo '<col width="14%">';
            echo '<col width="14%">';
            echo '<col width="14%">';
            echo '<col width="14%">';
            echo '<col width="14%">';
            echo '<col width="14%">';
            echo "<tr>";
            echo '<th>Event Type</th>';
            echo '<th>Event ID</th>'; 
            echo '<th>Event Type Total Count</th>';
            echo '<th>Event Type Average Count</th>';
            echo '<th>Event Type Highest Count</th>';
            echo '<th>Event Type Lowest Count</th>';
            echo '<th>Event Type Begin Date</th>';
            echo '<th>Event Type End Date</th>';
            echo '</tr>';
            // do the data rows
            echo '<tr>';
            echo '<td><p class="p1">' . $row["id_event_count"] . "</td>";
            echo '<td><p class="p1">' . $row["id_evento"] . "</td>"; 
            echo '<td><p class="p1">' . $row["event_type_count"] . "</td>";
            echo '<td><p class="p1">' . $row["event_type"] . "</td>";
            echo '<td><p class="p1">' . $row["source"] . "</td>";
            echo '<td><p class="p1">' . $row["timestamp"] . "</td>";
            echo "</tr>";
            $pagectr++;

        } else {
        
        // do only the data rows
        echo '<col width="14%">';
        echo '<col width="14%">';
        echo '<col width="14%">';
        echo '<col width="14%">';
        echo '<col width="14%">';
        echo '<col width="14%">';
        echo '<col width="14%">';
        echo '<tr>';
        echo '<td><p class="p1">' . $row["id_event_count"] . "</td>";
        echo '<td><p class="p1">' . $row["id_evento"] . "</td>"; 
        echo '<td><p class="p1">' . $row["event_type_count"] . "</td>";
        echo '<td><p class="p1">' . $row["event_type"] . "</td>";
        echo '<td><p class="p1">' . $row["source"] . "</td>";
        echo '<td><p class="p1">' . $row["timestamp"] . "</td>";
        echo "</tr>";
       
        }  // if ($pagectr == 0)  

    } // end while($row = $result->fetch_assoc())
    
    } else { 
        echo '<table style="font-family:Arial, sans-serif;width:100%;border:2px solid #ddd;border-radius:7px;padding:8px;height:25px;background-color:lightgray;text-align:center">'; 
        echo '<tr>';
        echo '<th><p class="p3">No Records Match For: Server: ' . $servername . "  Database Name: " . $db_name . '</p></th>';
        echo '</tr>';
        echo '</table>';
        
    } // while($row = mysqli_fetch_assoc($result))

// clear the connection
mysqli_close($conn);
?>