Editing: /home/goacom/public_html/scratch_extract/get_balance.php
<?php session_start(); header('Content-Type: application/json'); if (!isset($_SESSION['user_id'])) { echo json_encode(['error' => 'not_logged_in']); exit; } require_once 'db.php'; // adjust path if needed $user_id = (int) $_SESSION['user_id']; $stmt = $pdo->prepare("SELECT balance FROM users WHERE id = ? LIMIT 1"); $stmt->execute([$user_id]); $row = $stmt->fetch(PDO::FETCH_ASSOC); if ($row) { echo json_encode(['balance' => (float) $row['balance']]); } else { echo json_encode(['error' => 'user_not_found']); }
💾 Save