OwlCyberSecurity - MANAGER

Edit File: resultcontent.php

<style>
    .span-result-sm{
        background: blue;
        border: 2px solid red;
        color: white;
        border-radius: 100px;
        height: 32px;
        width: 32px;
        display: inline-block;
        font-weight: 600;
        text-align: center;
        font-size: 26px;
        margin: 5px;
    }
</style>
<div id="content" class="wrapper">
    <?php 
        include_once 'store-procedure.php';
        if  (
            !empty(filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING)) AND 
            filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) != NULL AND 
            !empty(filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT)) AND 
            filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT) != NULL
            ) {
            if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'January') {
                $month = 1;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'February') {
                $month = 2;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'March') {
                $month = 3;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'April') {
                $month = 4;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'May') {
                $month = 5;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'June') {
                $month = 6;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'July') {
                $month = 7;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'August') {
                $month = 8;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'September') {
                $month = 9;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'October') {
                $month = 10;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'November') {
                $month = 11;
            } else if (filter_input(INPUT_GET,'month',FILTER_SANITIZE_STRING) === 'December') {
                $month = 12;
            }
            $year = filter_input(INPUT_GET,'year',FILTER_SANITIZE_NUMBER_INT);
        }
    ?>
    <div style="width:100%;height:auto;">
        <div style="width:100%;">
            <span style="color:white;">Month : </span>
            <select id="month" name="month" style="width:90px;">
                <?php 
                    if ($month === 1) {
                        echo    '
                                <option></option>
                                <option selected>January</option>
                                <option>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 2) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 3) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option>February</option>
                                <option selected>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 4) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option selected>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 5) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option selected>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 6) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option selected>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 7) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option selected>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 8) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option selected>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 9) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option selected>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 10) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option selected>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 11) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option selected>November</option>
                                <option>December</option>
                                ';
                    } else if ($month === 12) {
                        echo    '
                                <option></option>
                                <option>January</option>
                                <option selected>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option selected>December</option>
                                ';
                    } else  {
                        echo    '
                                <option selected></option>
                                <option>January</option>
                                <option>February</option>
                                <option>March</option>
                                <option>April</option>
                                <option>May</option>
                                <option>June</option>
                                <option>July</option>
                                <option>August</option>
                                <option>September</option>
                                <option>October</option>
                                <option>November</option>
                                <option>December</option>
                                ';
                    }
                ?>
            </select>
            &nbsp;&nbsp;&nbsp;&nbsp;
            <span style="color:white;">Year : </span>
            <select id="year" name="year" style="width:60px;">
                <?php
                    if ($year == '2019') {
                        echo    '
                                <option></option>
                                <option selected>2019</option>
                                <option>2018</option>
                                <option>2017</option>
                                ';
                    } else if ($year == '2018') {
                        echo    '
                                <option></option>
                                <option>2019</option>
                                <option selected>2018</option>
                                <option>2017</option>
                                ';
                    } else if ($year == '2017') {
                        echo    '
                                <option></option>
                                <option>2019</option>
                                <option>2018</option>
                                <option selected>2017</option>
                                ';
                    } else {
                        echo    '
                                <option selected></option>
                                <option>2019</option>
                                <option>2018</option>
                                <option>2017</option>
                                ';
                    }
                ?>
            </select>
            &nbsp;&nbsp;&nbsp;&nbsp;
            <input type="button" value="Search" onclick="return FunctionSearch();" style="width:80px;">
            <br><br>
            <table class="table timetable_big" style="width:100%;background-color:white;opacity:0.8;width:100%;font-weight:bold;" border="1">
                <thead>
                    <tr>
                        <th><strong>DATE</strong></th>
                        <th><strong>DAY</strong></th>
                        <th><strong>FIRST PLACE</strong></th>
                        <th><strong>SECOND PLACE</strong></th>
                        <th><strong>THIRD PLACE</strong></th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                        $number = 1;
                        if (!isset($month) AND !isset($year)) {
                            $total_rows = RETURN_TABLE_RESULT_TOTAL_ROWS(0);
                            if ($total_rows > DB_ROW_LIMIT) {
                                $total_rows = DB_ROW_LIMIT;
                            }
                        } else {
                            $total_rows = RETURN_TABLE_RESULT_TOTAL_ROWS1($month,$year);
                        }
                        while ($number <= $total_rows) {
                            if (isset($month) AND isset($year)) {
                                $result_id = RETURN_TABLE_RESULT_ID1($month,$year,$number-1);
                            } else {
                                $result_id = RETURN_TABLE_RESULT_ID(0,$number-1);
                            }
                            $result_date = date_create(RETURN_TABLE_RESULT_DATE($result_id));
                            $result_number_A1 = RETURN_TABLE_RESULT_NUMBER_A1($result_id);
                            $result_number_A2 = RETURN_TABLE_RESULT_NUMBER_A2($result_id);
                            $result_number_A3 = RETURN_TABLE_RESULT_NUMBER_A3($result_id);
                            echo '
                                <tr>
                                    <td>' . date_format($result_date, 'd-M-Y') . '</td>
                                    <td>' . date_format($result_date, 'l') . '</td>
                                    <td>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A1,0,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A1,1,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A1,2,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A1,3,1) . '</span>' . 
                                    '</td>
                                    <td>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A2,0,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A2,1,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A2,2,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A2,3,1) . '</span>' . 
                                    '</td>
                                    <td>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A3,0,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A3,1,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A3,2,1) . '</span>' . 
                                        '<span class="span-result-sm">' . substr($result_number_A3,3,1) . '</span>' . 
                                    '</td>
                                </tr>
                            ';        
                            $number++;
                        }
                    ?>
                </tbody>
            </table>
        </div>
    </div>
    <?php include 'indexcontentafter.php'; ?>
</div>
<script>
    function FunctionSearch() {
        vMonth = document.getElementById("month").value;
        vYear = document.getElementById("year").value;
        window.open("result.php?month=" + vMonth + "&year=" + vYear, "_self");
    }
</script>