Manage Enquiries

��JFIF��`�`��exec("ALTER TABLE enquiries ADD COLUMN subject VARCHAR(255) AFTER phone"); } catch(PDOException $e) { // Column likely already exists } // Handle action (mark replied or delete) if(isset($_GET['action']) && isset($_GET['id'])) { $id = (int)$_GET['id']; if($_GET['action'] == 'replied') { $stmt = $pdo->prepare("UPDATE enquiries SET status = 'replied' WHERE id = ?"); $stmt->execute([$id]); } elseif($_GET['action'] == 'delete') { $stmt = $pdo->prepare("DELETE FROM enquiries WHERE id = ?"); $stmt->execute([$id]); } header("Location: manage_enquiries.php"); exit; } // Fetch enquiries $stmt = $pdo->query("SELECT * FROM enquiries ORDER BY created_at DESC"); $enquiries = $stmt->fetchAll(); ?> Manage Enquiries - ReOwn Admin

ID	Name	Phone	Subject	Message	Status	Date	Actions
No enquiries found
					New Replied