How can I save the maximum value obtained in rowCount?

Question

How do I logica so that only update my variable when the Rowcount value is the highest ever obtained?

Example: I performed the sql query and returned 15 record, saved 15 in variable $maximothen I performed another query and returned 12 so I do not update the variable $maximo, performed a third query and returned 17 then i update the variable $maximo to 17.

Current condition:

static function playeronline($pdoG)
{
    try {
        $playeronline = $pdoG->prepare("SELECT login FROM u_hero WHERE login = 1");
        $playeronline->execute();

        $numeroonline = $playeronline->rowCount();
        $numeroonline = $numeroonline * 1.3;
        $numeroonline = round($numeroonline);

        return $numeroonline;



    } catch (PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
}

I don’t know how to start the maximum variable.

Answer 1

There are some things to consider. The multiple accesses to the function playeronline() will be made in the same http request, or in different requests from different users? Let’s see an example for each case.

Multiple accesses in the same request

<?php
$maximo = 0;

//um loop para simular varias chamadas à função `playeronline`
for($i = 0; i < 5; i++){
    $players = playeronline(databaseConnection);
    if($players > $maximo){
        $maximo = $players;
    }
}

//depois faça alguma coisa com a variavel $maximo

static function playeronline($pdoG)
{
    try {
        $playeronline = $pdoG->prepare("SELECT login FROM u_hero WHERE login = 1");
        $playeronline->execute();

        $numeroonline = $playeronline->rowCount();
        $numeroonline = $numeroonline * 1.3;
        $numeroonline = round($numeroonline);

        return $numeroonline;



    } catch (PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
}

Multiple accesses in different requests

Here you can use the global variable $_SESSION to scan data between http (page) requests. Then:

<?php
//inicializa o uso de sessão (retire se você já estiver incluindo isso)
session_start();

//inicializa $_SESSION['maximo'] com 0 no primeiro acesso
if(!isset($_SESSION['maximo'])){
    $_SESSION['maximo'] = 0;
}

$players = playeronline(databaseConnection);

if($players > $_SESSION['maximo']){
    $_SESSION['maximo'] = $players;
}

//depois faça alguma coisa com a variavel $maximo

static function playeronline($pdoG)
{
    try {
        $playeronline = $pdoG->prepare("SELECT login FROM u_hero WHERE login = 1");
        $playeronline->execute();

        $numeroonline = $playeronline->rowCount();
        $numeroonline = $numeroonline * 1.3;
        $numeroonline = round($numeroonline);

        return $numeroonline;



    } catch (PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
}