all_time_leaderboard.php

<?php
    header('Content-Type: text/plain; charset=UTF-8');
    $servername = "localhost";
    $username = "tekntehf_trivias_user";
    $password = "Fo3A4QZ)*s+d";
    $dbname = "tekntehf_trivias";
    $list = array();
    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $dbname);
    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    $lang_change = "SET NAMES utf8mb4";
    if (mysqli_query($conn, $lang_change)) {
        //echo "Successful: Language change. ";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
    $sql = "SELECT winners, total FROM trivia_data";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        // output data of each row
        while($row = $result->fetch_assoc()) {
            $winnersArray = explode("," ,$row['winners']);
            $prizePerUser = intval($row['total']) / sizeof($winnersArray);
            foreach($winnersArray as $winner) {
                if($list[$winner]) {
                    $list[$winner] = $list[$winner] + $prizePerUser;
                } else {
                    $list[$winner] = $prizePerUser;
                }
            }
        }
    } else {
        echo "0 results";
    }
    $conn->close();
    echo json_encode($list);
?>