OwlCyberSecurity - MANAGER

Edit File: resultcontent1.php

<?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 class="container">
  <div class="row">
		<div class="col-md-6">
			<h2 class="title-4"><strong>PAST RESULT DAY</strong></h2>
		</div>
		
  </div>

<div align="center" style="width:100%;height:auto;">
        <div style="width:100%;">
            <span style="color:black;">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:black;">Year : </span>
            <select id="year" name="year" style="width:60px;">
                <?php
                    if ($year == '2021') {
                        echo    '
                                <option></option>
                                <option selected>2021</option>
                                <option>2022</option>
                                <option>2023</option>
                                ';
                    } else if ($year == '2022') {
                        echo    '
                                <option></option>
                                <option>2021</option>
                                <option selected>2022</option>
                                <option>2023</option>
                                ';
                    } else if ($year == '2023') {
                        echo    '
                                <option></option>
                                <option>2021</option>
                                <option>2022</option>
                                <option selected>2023</option>
                                ';
                    } else {
                        echo    '
                                <option selected></option>
                                <option>2021</option>
                                <option>2022</option>
                                <option>2023</option>
                                ';
                    }
                ?>
            </select>
            &nbsp;&nbsp;&nbsp;&nbsp;
            <input type="button" value="Search" onclick="return FunctionSearch();" style="width:80px;">
            <br><br>
            </div>

<br>

<div class="row">
    <div class="col-md-12">
		<table width="100%" border="0" cellspacing="0" cellpadding="0" class="table">
		    
		  <tr>
			
			<td class="headrow"  align="center"><b>DAY</b></td>
			<td class="headrow"  align="center"><b>DATE</b></td>
			<td class="headrow"  align="center"><b>RESULT</b></td>
			<td class="headrow"  align="center"><b>PRIZE</b></td>
		  </tr>
		  <?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 align="center"><b>' . date_format($result_date, 'l') . '</b></td>
			<td align="center"><b>' . date_format($result_date, 'd-m-Y') . '</b></td>
			<td align="center">
				<span class="ball-4">' . substr($result_number_A1,0,1) . '</span>
				<span class="ball-4">' . substr($result_number_A1,1,1) . '</span>
				<span class="ball-4">' . substr($result_number_A1,2,1) . '</span>
				<span class="ball-4">' . substr($result_number_A1,3,1) . '</span>
				      
			</td>
			<td align="center"><b>1</b></td>
				</tr>
				
				
				';
                $number++;
            }
        ?>		
				
					  		</table>
	</div>
  </div>
  </div>

</div>

<footer class="footer">
  <div class="container">
	<center><p class="text-muted"><br>© 2016-2021 Copyright by MimoPools.com<br></p></center>
  </div>
</footer>	
<script>
    function FunctionSearch() {
        vMonth = document.getElementById("month").value;
        vYear = document.getElementById("year").value;
        window.open("result.php?month=" + vMonth + "&year=" + vYear, "_self");
    }
</script>