Leaderboard controller

gistfile1.txt

$userinfos = query("SELECT * FROM users ORDER BY cash DESC");
    
    if ($userinfos === false)
    {
        apologize("Couldn't load your data.");
    }
    
    $positions = [];
    $rank = 1;
    //Cycle through each user
    foreach ($userinfos as $userinfo)
    {
        $stocktotal = 0;
        dump($userinfos);
        $portfolios = query("SELECT * FROM portfolio WHERE ?", $userinfo["id"]);
        //Cycle through each stock
        foreach ($portfolios as $portfolio)
        {
            $thisstock = 0;
            $stock = lookup($portfolio["symbol"]);
            $thisstock = $stock["price"] * $portfolio["shares"];
            $stocktotal += $thisstock;
        }
        
        $positions[] = [
            "rank" => $rank,
            "name" => $userinfo["username"],
            "cash" => $userinfo["cash"],
            "stocktotal" => $stocktotal
        ];
        $rank++;
    }