📁 File Manager
Editing:
/home/wvl7mof7402e/www/wingstourandtravels.com/admin/settings.php
<?php require_once 'auth_check.php'; include 'sidebar.php'; require_once __DIR__ . '/db.php'; $message = '';$error = ''; if (!isset($conn) || !$conn) { $error = 'Database connection is not available.'; $conn = null; } // Table create query if not exists if ($conn) { mysqli_query($conn, "CREATE TABLE IF NOT EXISTS `settings` ( `id` INT PRIMARY KEY AUTO_INCREMENT, `phone` VARCHAR(50), `email` VARCHAR(100), `whatsapp` VARCHAR(50), `address` TEXT )"); } // Settings Update Logic if ($conn && $_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_settings'])) { $phone = trim($_POST['phone']); $email = trim($_POST['email']); $whatsapp = trim($_POST['whatsapp']); $address = trim($_POST['address']); $check = mysqli_query($conn, "SELECT * FROM settings WHERE id = 1"); if (mysqli_num_rows($check) > 0) { $stmt = mysqli_prepare($conn, "UPDATE settings SET phone=?, email=?, whatsapp=?, address=? WHERE id=1"); mysqli_stmt_bind_param($stmt, "ssss", $phone,$email, $whatsapp,$address); } else { $stmt = mysqli_prepare($conn, "INSERT INTO settings (id, phone, email, whatsapp, address) VALUES (1, ?, ?, ?, ?)"); mysqli_stmt_bind_param($stmt, "ssss", $phone,$email, $whatsapp,$address); } if (mysqli_stmt_execute($stmt)) {$message = "Settings updated successfully!"; } else { $error = "Update failed: " . mysqli_error($conn); } } // Fetch Current Settings $settings = []; if ($conn) { $settings_res = mysqli_query($conn, "SELECT * FROM settings WHERE id = 1"); $settings = mysqli_fetch_assoc($settings_res) ?: []; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Site Settings | Wings Tour & Travels Admin</title> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.2/css/all.min.css"> <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;500;600;700&display=swap" rel="stylesheet"> <style> :root { --brand-green: #12521f; --brand-saffron: #D4A359; --dark-navy: #0F172A; --sidebar-width: 250px; --bg-light: #F8FAFC; } * { margin: 0; padding: 0; box-sizing: border-box; font-family: 'Poppins', sans-serif; } body { background-color: var(--bg-light); display: flex; min-height: 100vh; } .admin-sidebar { width: var(--sidebar-width); background-color: var(--dark-navy); color: #fff; position: fixed; top: 0; bottom: 0; left: 0; display: flex; flex-direction: column; z-index: 100; } .sidebar-brand { padding: 22px 20px; background: rgba(0,0,0,0.2); text-align: center; } .sidebar-brand h2 { font-size: 20px; color: var(--brand-saffron); } .sidebar-menu { list-style: none; padding: 20px 0; flex: 1; } .sidebar-menu li a { display: flex; align-items: center; gap: 12px; padding: 12px 22px; color: #CBD5E1; text-decoration: none; font-size: 14px; font-weight: 500; } .sidebar-menu li a:hover, .sidebar-menu li.active a { background: rgba(255, 255, 255, 0.08); color: #fff; border-left: 4px solid var(--brand-saffron); } .admin-main { margin-left: var(--sidebar-width); flex: 1; display: flex; flex-direction: column; } .admin-topbar { background: #fff; height: 65px; padding: 0 30px; display: flex; align-items: center; justify-content: space-between; box-shadow: 0 2px 10px rgba(0,0,0,0.04); position: sticky; top: 0; z-index: 99; } .admin-content { padding: 30px; } .page-title { font-size: 22px; color: var(--dark-navy); margin-bottom: 20px; font-weight: 700; } .card { background: #fff; padding: 25px; border-radius: 12px; border: 1px solid #E2E8F0; max-width: 600px; } .form-group { margin-bottom: 18px; } .form-group label { display: block; font-size: 13px; font-weight: 600; color: var(--dark-navy); margin-bottom: 6px; } .form-group input, .form-group textarea { width: 100%; padding: 10px 12px; border: 1px solid #CBD5E1; border-radius: 8px; font-size: 13.5px; outline: none; } .btn-submit { background: var(--brand-green); color: #fff; padding: 10px 22px; border: none; border-radius: 8px; font-weight: 600; cursor: pointer; } .alert-success { padding: 12px; background: #DCFCE7; color: #166534; border-radius: 8px; font-size: 13px; margin-bottom: 15px; } </style> </head> <body> <div class="admin-main"> <header class="admin-topbar"> <strong>Website Configuration</strong> <a href="login.php?action=logout" style="color: #EF4444; text-decoration: none; font-weight: 600; font-size: 13px;">Logout</a> </header> <main class="admin-content"> <h1 class="page-title">General Site Settings</h1> <?php if (!empty($message)): ?> <div class="alert-success"><?php echo $message; ?></div> <?php endif; ?> <div class="card"> <form action="" method="POST"> <div class="form-group"> <label>Contact Phone Number</label> <input type="text" name="phone" value="<?php echo htmlspecialchars($settings['phone'] ?? ''); ?>" placeholder="+91 9794235945"> </div> <div class="form-group"> <label>Support Email Address</label> <input type="email" name="email" value="<?php echo htmlspecialchars($settings['email'] ?? ''); ?>" placeholder="info@wingstravels.com"> </div> <div class="form-group"> <label>WhatsApp Number (for direct chat)</label> <input type="text" name="whatsapp" value="<?php echo htmlspecialchars($settings['whatsapp'] ?? ''); ?>" placeholder="919794235945"> </div> <div class="form-group"> <label>Office Address</label> <textarea name="address" rows="3"><?php echo htmlspecialchars($settings['address'] ?? ''); ?></textarea> </div> <button type="submit" name="update_settings" class="btn-submit"><i class="fas fa-save"></i> Save Settings</button> </form> </div> </main> </div> </body> </html>
Save
Cancel