Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once("Connector.php");
- $Count = 0;
- $Retrieval_WinLotto_Query = "SELECT * FROM Win_658";
- $Retrieval_WinLotto_SQL = mysqli_query($Connection, $Retrieval_WinLotto_Query) or die ("Could not retrieve data from database because: ".mysqli_error($Connection));
- ?>
- <html>
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <style>
- th {
- background-color: #4286f4;
- color: black;
- }
- </style>
- <head>
- <title>Results</title>
- </head>
- <body>
- <center>
- <table border = "1">
- <tr>
- <center>
- <th colspan = "6">CORRESPONDING WINNING COMBINATIONS</th>
- <th colspan = "6">RECORDED LOTTO PICKS</th>
- </center>
- </tr>
- <tr>
- <th>COMBINATION 1</th>
- <th>COMBINATION 2</th>
- <th>COMBINATION 3</th>
- <th>COMBINATION 4</th>
- <th>COMBINATION 5</th>
- <th>COMBINATION 6</th>
- <th>COMBINATION 1</th>
- <th>COMBINATION 2</th>
- <th>COMBINATION 3</th>
- <th>COMBINATION 4</th>
- <th>COMBINATION 5</th>
- <th>COMBINATION 6</th>
- </tr>
- <?php
- while ($Row = mysqli_fetch_array($Retrieval_WinLotto_SQL, MYSQLI_ASSOC)){
- $Win1 = $Row['First_Combination'];
- $Win2 = $Row['Second_Combination'];
- $Win3 = $Row['Third_Combination'];
- $Win4 = $Row['Fourth_Combination'];
- $Win5 = $Row['Fifth_Combination'];
- $Win6 = $Row['Sixth_Combination'];
- $LottoID = $Row['Lotto_ID'];
- $Picked_Lotto = "SELECT * FROM Lotto_658 WHERE Lotto_ID = $LottoID";
- $Picked_Lotto_Query = mysqli_query($Connection, $Picked_Lotto) or die ("Could not retrieve data from database because: ".mysqli_error($Connection));
- while ($Row2 = mysqli_fetch_array($Picked_Lotto_Query, MYSQLI_ASSOC)){
- $Picked1 = $Row2['First_Combination'];
- $Picked2 = $Row2['Second_Combination'];
- $Picked3 = $Row2['Third_Combination'];
- $Picked4 = $Row2['Fourth_Combination'];
- $Picked5 = $Row2['Fifth_Combination'];
- $Picked6 = $Row2['Sixth_Combination'];
- }
- if($Picked1 == $Win1 || $Picked1 == $Win2 || $Picked1 == $Win3 || $Picked1 == $Win4 ||$Picked1 == $Win5 || $Picked1 == $Win6){
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td bgcolor = '#008000'>$Picked1</td>
- <td>$Picked2</td>
- <td>$Picked3</td>
- <td>$Picked4</td>
- <td>$Picked5</td>
- <td>$Picked6</td></tr>";
- }
- if($Picked2 == $Win1 || $Picked2 == $Win2 || $Picked2 == $Win3 || $Picked2 == $Win4 ||$Picked2 == $Win5 || $Picked2 == $Win6){
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td bgcolor = '#008000'>$Picked2</td>
- <td>$Picked3</td>
- <td>$Picked4</td>
- <td>$Picked5</td>
- <td>$Picked6</td></tr>";
- }
- if($Picked3 == $Win1 || $Picked3 == $Win2 || $Picked3 == $Win3 || $Picked3 == $Win4 || $Picked3 == $Win5 || $Picked3 == $Win6){
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td>$Picked2</td>
- <td bgcolor = '#008000'>$Picked3</td>
- <td>$Picked4</td>
- <td>$Picked5</td>
- <td>$Picked6</td></tr>";
- }
- if($Picked4 == $Win1 || $Picked4 == $Win2 || $Picked4 == $Win3 || $Picked4 == $Win4 || $Picked4 == $Win5 || $Picked4 == $Win6){
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td>$Picked2</td>
- <td>$Picked3</td>
- <td bgcolor = '#008000'>$Picked4</td>
- <td>$Picked5</td>
- <td>$Picked6</td></tr>";
- }
- if($Picked5 == $Win1 || $Picked5 == $Win2 || $Picked5 == $Win3 || $Picked5 == $Win4 || $Picked5 == $Win5 || $Picked5 == $Win6){
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td>$Picked2</td>
- <td>$Picked3</td>
- <td>$Picked4</td>
- <td bgcolor = '#008000'>$Picked5</td>
- <td>$Picked6</td></tr>";
- }
- if($Picked6 == $Win1 || $Picked6 == $Win2 || $Picked6 == $Win3 || $Picked6 == $Win4 || $Picked6 == $Win5 || $Picked6 == $Win6){
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td>$Picked2</td>
- <td>$Picked3</td>
- <td>$Picked4</td>
- <td>$Picked5</td>
- <td bgcolor = '#008000'>$Picked6</td></tr>";
- }
- else{
- echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td>$Picked2</td>
- <td>$Picked3</td>
- <td>$Picked4</td>
- <td>$Picked5</td>
- <td>$Picked6</td></tr>";
- }
- /*echo "<tr><td>$Win1</td>
- <td>$Win2</td>
- <td>$Win3</td>
- <td>$Win4</td>
- <td>$Win5</td>
- <td>$Win6</td>
- <td>$Picked1</td>
- <td>$Picked2</td>
- <td>$Picked3</td>
- <td>$Picked4</td>
- <td>$Picked5</td>
- <td>$Picked6</td></tr>";*/
- }
- ?>
- </table>
- </center>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement