prepare("UPDATE artist_subscriptions SET payment_status=?, phonepe_txn_id=?, updated_at=NOW() WHERE txn_id=?"); } else { $status = $success ? 'Paid' : 'Failed'; $stmt = $conn->prepare("UPDATE competition_entries SET payment_status=?, phonepe_txn_id=? WHERE txn_id=?"); } $stmt->bind_param("sss", $status, $phonepe_txn_id, $txn_id); $stmt->execute(); $stmt->close(); } catch (Exception $e) { error_log("PhonePe Webhook DB Error: " . $e->getMessage()); http_response_code(500); // Internal Server Error die("Database update failed."); } // --- 5. SEND EMAIL (ONLY ON SUCCESS) --- if ($success) { try { if ($type === "subscription") { $q = $conn->query("SELECT u.email, u.full_name FROM users u JOIN artist_subscriptions s ON s.user_id=u.id WHERE s.txn_id='$txn_id'"); $user = $q->fetch_assoc(); $subject = "🎨 Subscription Activated - United Cultural Forum"; $body = "

Dear {$user['full_name']},

Your artist subscription payment of ₹$amount has been successfully received.

Thank you for being part of the United Cultural Forum!

"; admin_send_email($user['email'], $subject, $body); } else { $q = $conn->query("SELECT name, email, competition_id FROM competition_entries WHERE txn_id='$txn_id'"); $entry = $q->fetch_assoc(); $subject = "🏆 Competition Entry Confirmed - United Cultural Forum"; $body = "

Dear {$entry['name']},

Your competition entry payment of ₹$amount for competition ID #{$entry['competition_id']} was successful.

Best of luck!

"; admin_send_email($entry['email'], $subject, $body); } } catch (Exception $e) { error_log("PhonePe Webhook Email Error: " . $e->getMessage()); } } // --- 6. RESPOND TO PHONEPE --- // The webhook should just return a 200 OK, not HTML. http_response_code(200); echo json_encode(['status' => 'success']); ?>