File manager - Edit - /home/ipsc/api/next_player.php
Back
<?php // next_player.php header("Content-Type: application/json"); require_once "../connection.php"; // เชื่อมต่อ database /* ===================== STEP 1: หา player ถัดไป ===================== */ // ดึงคนที่ status = 'ready' หรือ 'waiting' คนแรก (id น้อยที่สุด) $player = $conn->query(" SELECT id, code, name FROM players WHERE status IN ('ready','waiting') ORDER BY id ASC LIMIT 1 ")->fetch_assoc(); /* ===================== STEP 2: ถ้ามี player ===================== */ if ($player) { // ตั้ง status เป็น running $stmt = $conn->prepare(" UPDATE players SET status='running', start_time=NOW() WHERE id=? "); $stmt->bind_param("i", $player['id']); $stmt->execute(); // ส่งข้อมูลกลับ ESP32 echo json_encode([ "success" => true, "player" => [ "id" => $player['id'], "code" => $player['code'], "name" => $player['name'] ] ]); exit; } /* ===================== STEP 3: ถ้าไม่มี player ===================== */ echo json_encode([ "success" => false, "message" => "No player ready" ]); exit; ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.4 |
proxy
|
phpinfo
|
Settings