function getWarrantyTableActive() {
$mysqli = new mysqli(DATABASE_URL,DATABASE_LOGIN, DATABASE_PASSWORD, DATABASE_NAME);
    if($mysqli->connect_errno) {
        printf("Connect failed: %s\n", $mysqli->connect_error);
        exit();
    }
    if (isUserAdmin()) {
$query = "SELECT * FROM tblwarranty WHERE Active = TRUE ORDER BY DateAdded";
        $stmt = $mysqli ->prepare($query);
    }
    else {
$query = "SELECT * FROM tblwarranty WHERE u_id = ? AND Active = TRUE ORDER BY DateAdded";
        $stmt = $mysqli ->prepare($query);
        $stmt->bind_param("i", $_SESSION['id']);
    }
    $stmt->execute();
$stmt->bind_result($wId, $name, $startTime,$warrantyPeroid, $endTime, $dateAdded, $descrption, $uId, $active);
    while ($stmt->fetch())  {
            $diff = strtotime($endTime) - strtotime('today');
            $days = ($diff/(3600*24));
            if (DATE_DIFFERENCE >= $days && $days >= 0) {
                echo "<tr class='warning selection'>";
            } else if (0 > $days) {
                echo "<tr class ='danger selection'>";
            }
            else {
                echo "<tr class ='selection'>";
            }
             echo "<td>" . htmlspecialchars($name)."</td>";
             echo "<td>" . htmlspecialchars($startTime)."</td>";
             echo "<td>" .  htmlspecialchars($endTime)."</td>";
             echo"<td>" .  htmlspecialchars($dateAdded)."</td>";
echo "<td> <form method='post' action='delete_warranty.php' class='delete-form'>
                <input type='hidden' value='$wId' name='id'/>
<span class='glyphicon glyphicon-search' style='cursor:pointer;' aria-hidden='true' data-toggle='tooltip' data-placement='left' title='Szczegóły'></span>
<span class='glyphicon glyphicon-remove' style='cursor:pointer;' aria-hidden='true' data-toggle='tooltip' data-placement='right' title='Usun'></span>
                    </form></td>";
            echo "</tr>";
    }
    echo "</tbody>";
    echo "</table>";
}