Thong ke 00-99

<?php

$vung  = $_GET["vung"]; // noi lay ket qua xo so
$limit = $_GET["limit"]; // so ngay cach day
// $thongke la luot xuat hien
for ($i = 0; $i < 100; $i++) {
    $thongke[$i] = 0;
}

require_once __DIR__ . '/db_config.php';

// Ket noi database de lay du lieu
$conn = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die("Can't connect this database");
mysql_select_db("appxoso", $conn);
$vung   = str_replace("-", "", $vung);
$sql    = "SELECT * FROM $vung ORDER BY pid DESC LIMIT $limit";
$result = mysql_query($sql);

// Lay truong ket qua ra de xu ly
while ($row = mysql_fetch_array($result)) {
    $ketqua   = $row["ketqua"];
    $ketqua   = str_replace("-", ",", $ketqua);
    $xlKetqua = explode(",", $ketqua);

    // for ($i = 0; $i < count($xlKetqua); $i++) {
    //     echo substr($xlKetqua[$i], -2) . "-";
    //     // if ($i % 10 == 0) echo "<br>";
    // }
    // echo "<br><br><br>";

    for ($i = 0; $i < count($xlKetqua); $i++) {
        if (substr($xlKetqua[$i], -2, 1) == 0) {
            $hai2so = substr($xlKetqua[$i], -1);
        } else {
            $hai2so = substr($xlKetqua[$i], -2);
        }
        $thongke[$hai2so]++;
    }
}

// Dua ra day so
$dayso = "";
for ($i = 0; $i <= 9; $i++) {
    $dayso = $dayso . "0" . $i . ",";
}
for ($i = 10; $i <= 98; $i++) {
    $dayso = $dayso . $i . ",";
}
$dayso = $dayso . "99";

// Tinh luot xuat hien
$dayxuathien = "";
for ($i = 0; $i <= 98; $i++) {
    $dayxuathien = $dayxuathien . $thongke[$i] . ",";
}
$dayxuathien = $dayxuathien . $thongke[99];

// Tinh phan tram xuat hien
$tong = 0;
for ($i = 0; $i <= 99; $i++) {
    $tong = $tong + $thongke[$i];
}
for ($i = 0; $i <= 99; $i++) {
    $phantram[$i] = $thongke[$i] / $tong * 100;
    $phantram[$i] = round($phantram[$i], 2);
}
$dayphantram = "";
for ($i = 0; $i <= 98; $i++) {
    $dayphantram = $dayphantram . $phantram[$i] . ",";
}
$dayphantram = $dayphantram . "99";

echo $dayso . "<br>";
echo $dayxuathien . "<br>";
echo $dayphantram . "<br>";

?>