connect_error) { die("Connection failed: " . $conn->connect_error); } $data = []; $today = date('Y-m-d'); $yesterday = date('Y-m-d', strtotime("-1 day", strtotime($today))); $tabs_query = "SELECT (SELECT MAX(raste_kumulative) FROM `stats`) as raste_gjithesej, (SELECT raste_kumulative FROM `stats` ORDER BY ID DESC LIMIT 1 OFFSET 1) as raste_gjithesej_dje, (SELECT MAX(raste_kumulative) - MAX(sheruar) - MAX(vdekje_kumulative) FROM `stats`) as raste_aktive, (SELECT raste_kumulative - sheruar - vdekje_kumulative FROM `stats` ORDER BY ID DESC LIMIT 1 OFFSET 1) as raste_aktive_dje, (SELECT MAX(sheruar) FROM `stats`) as te_sheruar, (SELECT sheruar FROM `stats` ORDER BY ID DESC LIMIT 1 OFFSET 1) as te_sheruar_dje, (SELECT MAX(vdekje_kumulative) FROM `stats`) as te_vdekur, (SELECT vdekje_kumulative FROM `stats` ORDER BY ID DESC LIMIT 1 OFFSET 1) as te_vdekur_dje, (SELECT MAX(teste_gjithesej) FROM `stats`) as teste_gjithesej, (SELECT teste_gjithesej FROM `stats` ORDER BY ID DESC LIMIT 1 OFFSET 1) as teste_gjithesej_dje FROM `stats` LIMIT 1"; $result = $conn->query($tabs_query); while($row = $result->fetch_assoc()) { $data['tabs'] = $row; } $result = $conn->query("SELECT `data` FROM stats"); while($row = $result->fetch_assoc()) { $data['kategorite'][] = $row['data']; } $result = $conn->query("SELECT raste_kumulative, vdekje_kumulative, sheruar FROM stats"); while($row = $result->fetch_assoc()) { $data['raste_aktive'][] = (int)$row['raste_kumulative'] - (int)$row['vdekje_kumulative'] - (int)$row['sheruar']; } $result = $conn->query("SELECT raste_te_reja FROM stats"); while($row = $result->fetch_assoc()) { $data['raste_te_reja'][] = (int)$row['raste_te_reja']; } $result = $conn->query("SELECT raste_kumulative FROM stats"); while($row = $result->fetch_assoc()) { $data['raste_kumulative'][] = (int)$row['raste_kumulative']; } $result = $conn->query("SELECT vdekje_kumulative FROM stats"); while($row = $result->fetch_assoc()) { $data['vdekje_kumulative'][] = (int)$row['vdekje_kumulative']; } $result = $conn->query("SELECT sheruar FROM stats"); while($row = $result->fetch_assoc()) { $data['sheruar'][] = (int)$row['sheruar']; } header('Content-Type: application/json'); echo json_encode($data); // echo '

';
// var_dump($data);
// echo '

'; // die(); $conn->close(); ?>