????

File manager - Edit - /var/www/html/desktop/get_account_details.php

Back
<?php error_reporting(E_ALL); ini_set('display_errors', 1); include 'helper.php'; $requestData = json_decode(file_get_contents('php://input'), true); if (is_null($requestData)) { jsonResponse('error', 'Invalid JSON data', null, 400); } $id = $requestData['id'] ?? null; $token = $requestData['token'] ?? null; $gameNetId = $requestData['game_net_id'] ?? null; if (!$id \|\| !$token \|\| !$gameNetId) { jsonResponse('error', 'Invalid data', $requestData, 400); } $db = connect_to_database(); // Validate user if (!validateUser($id, $token, $db)) { jsonResponse('error', 'Unauthorized', null, 401); } try{ $sql = "SELECT gn.id, gn.admin_id, gn.title, gn.location, gn.description, gn.address, gn.sign_up_step, gp.url AS `profile` FROM game_nets gn LEFT JOIN gn_profile gp ON gp.game_net_id = gn.id WHERE gn.id = ?;"; // Execute statements and fetch results $stmt = $db->prepare($sql); $stmt->bind_param("i", $gameNetId); $stmt->execute(); $gameNetResult = $stmt->get_result(); $gameNet = $gameNetResult->fetch_assoc(); // Combine results into a single response $response = [ 'game_net' => $gameNet, ]; jsonResponse('success','got data',$response); $stmt->close(); $getImagesStmt->close(); }catch (Exception $e) { jsonResponse('error', $e->getMessage(), null, 500); }finally { $db->close(); }

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