Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
wobblies
/
admin
:
fetch_user_products.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php session_start(); require_once '../_db.php'; // adjust path if needed header('Content-Type: application/json'); if (!isset($_GET['userid']) || empty($_GET['userid'])) { echo json_encode([]); exit; } $userid = $_GET['userid']; // Fetch only promoted products belonging to the user $stmt = $conn->prepare(" SELECT p.product_id, p.product_name FROM product_promotions pr INNER JOIN products p ON pr.product_id = p.product_id WHERE pr.userid = ? ORDER BY p.product_name ASC "); $stmt->bind_param("s", $userid); $stmt->execute(); $result = $stmt->get_result(); $products = []; while ($row = $result->fetch_assoc()) { $products[] = [ 'product_id' => $row['product_id'], 'product_name' => $row['product_name'] ]; } echo json_encode($products);