Untitled

<html>

<head>
    <title>Football statistics live</title>
</head>
<link rel="stylesheet" type="text/css" href="style.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link media="all" type="text/css" rel="stylesheet" href="http://bootswatch.com/simplex/bootstrap.min.css">
<link media="all" type="text/css" rel="stylesheet" href="style.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script>
    $(document).ready(function() {
        $('[data-toggle="tooltip"]').tooltip();
    });
      setInterval(updateStats, 1000 * 60);
              function updateStats() {
            location.reload();        }
</script>
<script>
function myFunction() {
  // Declare variables
  var input, filter, table, tr, td, i;
  input = document.getElementById("myInput");
  filter = input.value.toUpperCase();
  table = document.getElementById("list");
  tr = table.getElementsByTagName("div");

  // Loop through all table rows, and hide those who don't match the search query
  for (i = 0; i < tr.length; i++) {
    td = tr[i].getElementsByTagName("p")[0];
    if (td) {
      if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
        tr[i].style.display = "";
      } else {
        tr[i].style.display = "none";
      }
    }
  }
}
</script>
<div class="alert alert-info" role="alert" align="left"><b>Football statistics live</b></div>
<input type="text" name="search_text" id="myInput" onkeyup="myFunction()" placeholder="Wpisz nazwę drużyny/kraj/rozgrywki" class="form-control" />
    </div>
<div id="list" />
<?php

function minutes( $seconds )
{
    return sprintf( "%02.2d:%02.2d", floor( $seconds / 60 ), $seconds % 60 );
}
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "stats";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
    $sql_select = "SELECT I, L, O1, O2, TS, LI, Sc1, Sc2, lCorner1, lCorner2, ShotsOn1, ShotsOff1, ShotsOn2, ShotsOff2, DanAttacks1, Attacks1, DanAttacks2, Attacks2, IRedCard1, IRedCard2,IF(100 * DanAttacks1/(DanAttacks1+DanAttacks2)>50,100 * DanAttacks1/(DanAttacks1+DanAttacks2),100-(100*DanAttacks1/(DanAttacks1+DanAttacks2))) as diff FROM livenow where TS>600 order by diff DESC";
    $result = $conn->query($sql_select);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
    $input = array("progress-bar-success", "progress-bar-info", "progress-bar-warning", "progress-bar-danger");
    $random = rand(0, 3);
    //if($row["diff"]>90) $h = "highlight4"; else $h="";
    $h ="";
    if($row["diff"]>76){
        $h = "highlight3";
        if($row["diff"]>77){
            $h = "highlight4";
        }
    }
    else{
        $h ="";
    }
    if($h=="" && $row["diff"]>66 ){$h = "highlight2";}

?>

    <div class="col-md-6 <?php echo $h;?>" >

        <p class="opponents center">
                <span class="glyphicon glyphicon-globe" data-toggle="tooltip" data-placement="right" title="" data-original-title="<?php echo $row["L"]; ?>"></span>
                <span class="opp1"><?php if($row["IRedCard1"]>0)echo "<span class=\"redCard\"></span>";  echo $row["O1"]; ?> </span>
                <span class="center score"><?php echo $row["Sc1"]; ?> - <?php echo $row["Sc2"]; ?></span>
                <span class="opp2"><?php if($row["IRedCard2"]>0)echo "<span class=\"redCard\"></span>";  echo $row["O2"]; ?></span>
        </p>
        <p class="center">

                <span class="center"><img src="corner.png" alt="corner" class="rounded float-left"><span class="corner"><?php echo $row["lCorner1"]; ?></span> <span class="time"><?php echo minutes($row["TS"]); ?></span><img src="corner.png" alt="corner" class="rounded float-left"><span class="corner"><?php echo $row["lCorner2"]; ?></span></span>

            </p>
        <p class="center">

                <span class="statLeftNr"> <?php echo $row["ShotsOn1"]; ?></span>
                <span>CELNE STRZAŁY</span>
                <span class="statRightNr"> <?php echo $row["ShotsOn2"]; ?></span>
            </p>
            <div class="progress">
                <div class="progress-bar <?php echo $input[$random] ; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $row["ShotsOn1"]/($row["ShotsOn1"]+$row["ShotsOn2"])*100; ?>%">
                </div>
            </div>
        <p class="center">
                <span class="statLeftNr"> <?php echo $row["ShotsOff1"]; ?></span>
                <span>NIECELNE STRZAŁY</span>
                <span class="statRightNr"> <?php echo $row["ShotsOff2"]; ?></span>
            </p>
            <div class="progress">
                <div class="progress-bar <?php echo $input[$random] ; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $row["ShotsOff1"]/($row["ShotsOff1"]+$row["ShotsOff2"])*100; ?>%">
                </div>
            </div>
            <p class="center">
                <span class="statLeftNr"> <?php echo $row["Attacks1"]; ?></span>
                <span>ATAKI</span>
                <span class="statRightNr"> <?php echo $row["Attacks2"]; ?></span>
            </p>
            <div class="progress">
                <div class="progress-bar <?php echo $input[$random] ; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $row["Attacks1"]/($row["Attacks1"]+$row["Attacks2"])*100; ?>%">
                </div>
            </div>
            <p class="center">
                <span class="statLeftNr"> <?php echo $row["DanAttacks1"]; ?></span>
                <span>NIEBEZPIECZNE ATAKI</span>
                <span class="statRightNr"> <?php echo $row["DanAttacks2"]; ?></span>
            </p>
            <div class="progress">
                <div class="progress-bar <?php echo $input[$random] ; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $row["DanAttacks1"]/($row["DanAttacks1"]+$row["DanAttacks2"])*100; ?>%">
                </div>
            </div>
 </div>
<?php
    }
}

$conn->close();
?>
</div>
</html>