File manager - Edit - /home/ipsc/api/start_player.php
Back
<?php require_once "../connection.php"; header("Content-Type: application/json"); /* ปิดคนที่กำลังแข่งอยู่ */ $conn->query(" UPDATE players SET status='finished', time = TIMESTAMPDIFF(SECOND, start_time, NOW()) WHERE status='running' "); /* เลือกผู้เล่น waiting คนถัดไป */ $player = $conn->query(" SELECT id FROM players WHERE status='waiting' ORDER BY id ASC LIMIT 1 ")->fetch_assoc(); if (!$player) { echo json_encode([ "status" => "done", "message" => "ไม่มีผู้แข่งขันเหลือแล้ว" ]); exit; } /* เริ่มการแข่งขัน */ $stmt = $conn->prepare(" UPDATE players SET status='running', start_time = NOW(), time = 0 WHERE id=? "); $stmt->bind_param("i", $player['id']); $stmt->execute(); echo json_encode([ "status" => "success", "player_id" => $player['id'] ]);
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.6 |
proxy
|
phpinfo
|
Settings