File Manager

Editing:settings.php

<?php define('PAGE_TITLE', 'Settings'); require_once 'includes/header.php';
$msg = '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    foreach ($_POST as $key => $value) {
        if (in_array($key, ['save_settings'])) continue;
        $value = cleanInput($value);
        $stmt = $conn->prepare("INSERT INTO settings (setting_key, setting_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE setting_value=?");
        $stmt->bind_param("sss", $key, $value, $value);
        $stmt->execute();
    }
    $msg = '<div class="alert alert-success">Settings saved!</div>';
}
$settings = $conn->query("SELECT * FROM settings")->fetch_all(MYSQLI_ASSOC);
$settingsData = []; foreach ($settings as $s) $settingsData[$s['setting_key']] = $s['setting_value'];
?>
<div class="d-flex justify-content-between align-items-center mb-4">
  <h4 class="fw-bold text-navy mb-0"><i class="bi bi-gear text-warning me-2"></i>Settings</h4>
</div>
<?= $msg ?>
<div class="premium-card p-4">
  <form method="post">
    <ul class="nav nav-tabs mb-4">
      <li class="nav-item"><a class="nav-link active" data-bs-toggle="tab" href="#general">General</a></li>
      <li class="nav-item"><a class="nav-link" data-bs-toggle="tab" href="#contact">Contact</a></li>
      <li class="nav-item"><a class="nav-link" data-bs-toggle="tab" href="#payment">Payment</a></li>
      <li class="nav-item"><a class="nav-link" data-bs-toggle="tab" href="#social">Social</a></li>
      <li class="nav-item"><a class="nav-link" data-bs-toggle="tab" href="#transport">Transport</a></li>
    </ul>
    <div class="tab-content">
      <div class="tab-pane fade show active" id="general">
        <div class="row g-3">
          <div class="col-md-6"><label class="form-label">Site Name</label><input type="text" name="site_name" class="form-control" value="<?= htmlspecialchars($settingsData['site_name'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Currency</label><input type="text" name="currency" class="form-control" value="<?= htmlspecialchars($settingsData['currency'] ?? 'LKR') ?>"></div>
          <div class="col-12"><label class="form-label">Site Description</label><textarea name="site_description" class="form-control" rows="2"><?= htmlspecialchars($settingsData['site_description'] ?? '') ?></textarea></div>
          <div class="col-md-6"><label class="form-label">Advance Payment %</label><input type="number" name="advance_percentage" class="form-control" value="<?= $settingsData['advance_percentage'] ?? 50 ?>"></div>
          <div class="col-12"><label class="form-label">Footer Text</label><textarea name="footer_text" class="form-control" rows="2"><?= htmlspecialchars($settingsData['footer_text'] ?? '') ?></textarea></div>
        </div>
      </div>
      <div class="tab-pane fade" id="contact">
        <div class="row g-3">
          <div class="col-md-6"><label class="form-label">Contact Email</label><input type="email" name="contact_email" class="form-control" value="<?= htmlspecialchars($settingsData['contact_email'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Contact Phone</label><input type="text" name="contact_phone" class="form-control" value="<?= htmlspecialchars($settingsData['contact_phone'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">WhatsApp Number</label><input type="text" name="whatsapp_number" class="form-control" value="<?= htmlspecialchars($settingsData['whatsapp_number'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Business Hours</label><input type="text" name="business_hours" class="form-control" value="<?= htmlspecialchars($settingsData['business_hours'] ?? '') ?>"></div>
          <div class="col-12"><label class="form-label">Address</label><textarea name="address" class="form-control" rows="2"><?= htmlspecialchars($settingsData['address'] ?? '') ?></textarea></div>
        </div>
      </div>
      <div class="tab-pane fade" id="payment">
        <div class="row g-3">
          <div class="col-md-6"><label class="form-label">Bank Name</label><input type="text" name="bank_name" class="form-control" value="<?= htmlspecialchars($settingsData['bank_name'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Account Name</label><input type="text" name="bank_account_name" class="form-control" value="<?= htmlspecialchars($settingsData['bank_account_name'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Account Number</label><input type="text" name="bank_account_no" class="form-control" value="<?= htmlspecialchars($settingsData['bank_account_no'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Branch</label><input type="text" name="bank_branch" class="form-control" value="<?= htmlspecialchars($settingsData['bank_branch'] ?? '') ?>"></div>
        </div>
      </div>
      <div class="tab-pane fade" id="social">
        <div class="row g-3">
          <div class="col-md-6"><label class="form-label">Facebook URL</label><input type="url" name="facebook_url" class="form-control" value="<?= htmlspecialchars($settingsData['facebook_url'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">Instagram URL</label><input type="url" name="instagram_url" class="form-control" value="<?= htmlspecialchars($settingsData['instagram_url'] ?? '') ?>"></div>
          <div class="col-md-6"><label class="form-label">TikTok URL</label><input type="url" name="tiktok_url" class="form-control" value="<?= htmlspecialchars($settingsData['tiktok_url'] ?? '') ?>"></div>
        </div>
      </div>
      <div class="tab-pane fade" id="transport">
        <div class="row g-3">
          <div class="col-md-4"><label class="form-label">Office Latitude</label><input type="text" name="office_latitude" class="form-control" value="<?= htmlspecialchars($settingsData['office_latitude'] ?? '6.9271') ?>"></div>
          <div class="col-md-4"><label class="form-label">Office Longitude</label><input type="text" name="office_longitude" class="form-control" value="<?= htmlspecialchars($settingsData['office_longitude'] ?? '79.8612') ?>"></div>
          <div class="col-md-4"><label class="form-label">Cost Per KM (<?= htmlspecialchars($settingsData['currency'] ?? 'LKR') ?>)</label><input type="number" step="0.01" name="transport_cost_per_km" class="form-control" value="<?= htmlspecialchars($settingsData['transport_cost_per_km'] ?? '100.00') ?>"></div>
        </div>
      </div>
    </div>
    <hr>
    <button type="submit" name="save_settings" class="btn btn-premium"><i class="bi bi-save me-2"></i>Save All Settings</button>
  </form>
</div>
<?php require_once 'includes/footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:settings.php