Файловый менеджер - Редактировать - /home/gqdcvggs/.trash/get_stats.php
Назад
<?php header('Content-Type: application/json'); header('Access-Control-Allow-Origin: *'); require_once 'config.php'; $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); if ($conn->connect_error) { echo json_encode(['success' => false, 'error' => 'Database connection failed']); exit; } $userId = intval($_GET['userId']); $totalSql = "SELECT COUNT(*) as total FROM sessions WHERE user_id = $userId"; $totalResult = $conn->query($totalSql); $totalSessions = $totalResult->fetch_assoc()['total']; $winsSql = "SELECT COUNT(*) as wins FROM sessions WHERE user_id = $userId AND winner = 'left'"; $winsResult = $conn->query($winsSql); $wins = $winsResult->fetch_assoc()['wins']; $lossesSql = "SELECT COUNT(*) as losses FROM sessions WHERE user_id = $userId AND winner = 'right'"; $lossesResult = $conn->query($lossesSql); $losses = $lossesResult->fetch_assoc()['losses']; echo json_encode([ 'totalSessions' => intval($totalSessions), 'wins' => intval($wins), 'losses' => intval($losses) ]); $conn->close(); ?>
| ver. 1.6 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0.01 |
proxy
|
phpinfo
|
Настройка