<?php
    $servername = "localhost";
    $username = "root";
    $password = "tiskepap";
    $dbname = "sport_prijave";

    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }

    $pol = $_GET['pol'];
    $sport = $_GET['sport'];
    $brojac=0;

    $sql = "SELECT COUNT(*) as `broj_prijavljenih` FROM `clanovi` WHERE `pol` = '".$pol."' AND `sport` = '".$sport."'";
    $result = mysqli_query($conn, $sql);

    if ($result){
        while ($row = mysqli_fetch_assoc($result)){
            $brojac = $row['broj_prijavljenih'];
        }
    }

    echo $brojac;

mysqli_close($conn);
?>