prepare("SELECT * FROM orders WHERE id = ?"); $stmt->execute([$id]); $order = $stmt->fetch(); if (!$order) { header("Location: orders.php"); exit; } // Generate WhatsApp Message & Links $whatsapp_message = generate_whatsapp_message($order); // Links to send the structured message $whatsapp_send_link = get_whatsapp_link($order['whatsapp'], $whatsapp_message); $whatsapp_web_send_link = get_whatsapp_web_link($order['whatsapp'], $whatsapp_message); // General links (chat only, no prefilled message) $whatsapp_general_link = get_whatsapp_link($order['whatsapp']); $whatsapp_web_general_link = get_whatsapp_web_link($order['whatsapp']); } catch (PDOException $e) { die("Database query error: " . $e->getMessage()); } include '../includes/admin_header.php'; ?>