static-variables / jweb /ac1 /src /api /fetch_tokens.php
fellybikush's picture
Upload 99 files
0dff816 verified
raw
history blame
621 Bytes
<?php
session_start();
require_once '../../db.php';
if (!isset($_SESSION['user_id'])) {
echo json_encode(['success' => false, 'message' => 'Not logged in']);
exit;
}
$user_id = $_SESSION['user_id'];
$sql = "SELECT id, name, token, permissions, expires_at, status, created_at
FROM access_tokens
WHERE user_id = ? ORDER BY created_at DESC";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$tokens = [];
while ($row = $result->fetch_assoc()) {
$tokens[] = $row;
}
echo json_encode(['success' => true, 'tokens' => $tokens]);