????

File manager - Edit - /var/www/html/desktop/shifts/get_shifts.php

Back
<?php // Enable error reporting error_reporting(E_ALL); ini_set('display_errors', 1); require '../helper.php'; require_once '../cors_config.php'; $request_data = json_decode(file_get_contents("php://input"), true); if ($request_data) { // Create connection $conn = connect_to_database(); if ($conn->connect_error) { die(json_encode(["status" => "error", "message" => "Connection failed: " . $conn->connect_error])); } $id = isset($request_data['id']) ? $request_data['id'] : null; $token = isset($request_data['token']) ? $request_data['token'] : null; $gameNetId = isset($request_data['game_net_id']) ? $request_data['game_net_id'] : null; if ($id && $token && $gameNetId && validateUser($id, $token, $conn)) { // Prepare and execute SQL statement $stmt = $conn->prepare("SELECT * FROM gn_shifts WHERE game_net_id = ?"); $stmt->bind_param("i", $gameNetId); $stmt->execute(); // Fetch results $result = $stmt->get_result(); $data = []; while ($row = $result->fetch_assoc()) { $data[] = $row; } // Return data as JSON response header('Content-Type: application/json'); jsonResponse('success', 'all shifts recieved successfully', $data); $stmt->close(); } else { $message = !$gameNetId ? "Missing game_net_id" : "Invalid user credentials"; jsonResponse('error', $message); } $conn->close(); }

| ver. 1.4 | Github | . | PHP 8.3.6 | Generation time: 0.42 | proxy | phpinfo | Settings