prepare("UPDATE product_requests SET status = ? WHERE id = ?")->execute([$status, $id]); // IF MARKED AS "ADDED" -> SEND EMAIL if ($status == 'added') { // Fetch request details to get email & product name $req = $pdo->query("SELECT * FROM product_requests WHERE id = $id")->fetch(); if ($req && !empty($req['user_email'])) { $to = $req['user_email']; $prod_name = htmlspecialchars($req['product_name']); $subject = "Good News! $prod_name is now available - Pro Subscription Offers"; $emailContent = "

Request Fulfilled!

Hi there,

Great news! You recently requested $prod_name on Pro Subscription Offers.

It is now in stock and available for purchase!

Click the button below to check it out:

Buy Now

Thank you for helping us improve our inventory.

"; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= "From: Pro Subscription Offers " . "\r\n"; @mail($to, $subject, $emailContent, $headers); } } header("Location: requests.php?msg=updated"); exit(); } // 2. DELETE REQUEST if (isset($_GET['delete'])) { $pdo->prepare("DELETE FROM product_requests WHERE id = ?")->execute([$_GET['delete']]); header("Location: requests.php?msg=deleted"); exit(); } // 3. FETCH REQUESTS $requests = $pdo->query("SELECT * FROM product_requests ORDER BY created_at DESC")->fetchAll(); ?> Product Requests

Customer Requests

0): ?>

Date	Product Name	Requested By	Status	Action
		0) echo " "; ?>		Mark Added Reject Completed
No requests yet.