123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110 |
- <?php
- class StatsUtils
- {
-
- public static function getOneResult($sql)
- {
- $query = Database::query($sql);
- if ($query !== false) {
- $res = @Database::fetch_array($query, 'NUM');
- } else {
- $res = array();
- }
- return $res[0];
- }
-
- public static function getManyResults1Col($sql)
- {
- $res = Database::query($sql);
- if ($res !== false) {
- $i = 0;
- while ($resA = Database::fetch_array($res, 'NUM')) {
- $resu[$i++] = $resA[0];
- }
- }
- return $resu;
- }
-
- public static function getManyResults2Col($sql)
- {
- $res = Database::query($sql);
- if ($res !== false) {
- $i = 0;
- while ($resA = Database::fetch_array($res, 'NUM')) {
- $resu[$i][0] = $resA[0];
- $resu[$i][1] = $resA[1];
- $i++;
- }
- }
- return $resu;
- }
-
- public static function getManyResults3Col($sql)
- {
- $res = Database::query($sql);
- if ($res !== false) {
- $i = 0;
- while ($resA = Database::fetch_array($res, 'NUM')) {
- $resu[$i][0] = $resA[0];
- $resu[$i][1] = $resA[1];
- $resu[$i][2] = $resA[2];
- $i++;
- }
- }
- return $resu;
- }
-
- public static function getManyResultsXCol($sql, $X)
- {
- $res = Database::query($sql);
- if ($res !== false) {
- $i = 0;
- while ($resA = Database::fetch_array($res, 'NUM')) {
- for ($j = 0; $j < $X; $j++) {
- $resu[$i][$j] = $resA[$j];
- }
- $i++;
- }
- }
- return $resu;
- }
- }
|