File manager - Edit - /home/webapp69.cm.in.th/u69319090033/Shop/api/get_initial_data.php
Back
<?php header('Content-Type: application/json; charset=utf-8'); require_once '../db.php'; try { $response = [ 'categories' => [], 'products' => [], 'user' => null ]; // Check if user is logged in if (isset($_SESSION['user_id'])) { $stmt = $conn->prepare("SELECT user_id as id, full_name as name, email, role, seller_status FROM users WHERE user_id = ?"); $stmt->bind_param("i", $_SESSION['user_id']); $stmt->execute(); $result = $stmt->get_result(); if ($user = $result->fetch_assoc()) { $response['user'] = $user; } $stmt->close(); } // Get categories $stmt = $conn->prepare("SELECT category_id as id, category_name as name, icon FROM categories"); $stmt->execute(); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { $response['categories'][] = $row; } $stmt->close(); // Get products (active and approved) $stmt = $conn->prepare(" SELECT product_id as id, category_id as category, product_name as name, description, price, original_price as originalPrice, rating_avg as rating, sold_count as sold, badge, badge_text as badgeText, image_url as image FROM products WHERE is_active = 1 AND approval_status = 'approved' ORDER BY created_at DESC "); $stmt->execute(); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { $row['id'] = (int)$row['id']; $row['price'] = (float)$row['price']; $row['originalPrice'] = $row['originalPrice'] ? (float)$row['originalPrice'] : null; $row['rating'] = (float)$row['rating']; $row['sold'] = (int)$row['sold']; $row['reviewsCount'] = rand(10, 500); $response['products'][] = $row; } $stmt->close(); echo json_encode($response); } catch (Exception $e) { http_response_code(500); echo json_encode(['error' => 'Internal Server Error']); } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.24 |
proxy
|
phpinfo
|
Settings