System Manager v8.0

Editing: manage-cities.php

<?php include 'includes/auth.php'; ?>
<?php include 'includes/header.php'; ?>
<?php include 'includes/topbar.php'; ?>
<?php include 'includes/sidebar.php'; ?>

.city-card:hover {
    box-shadow: 0 4px 12px rgba(0,0,0,0.1);
  }

.city-info h4 {
    margin: 0 0 5px 0;
    color: #0052da;
    font-weight: 600;
  }

.city-info p {
    margin: 0;
    color: #666;
    font-size: 0.9rem;
  }

.city-actions {
    display: flex;
    gap: 10px;
  }

.status-badge {
    display: inline-block;
    padding: 4px 8px;
    border-radius: 4px;
    font-size: 0.8rem;
    font-weight: 600;
  }

.status-active {
    background: #d4edda;
    color: #155724;
  }

.status-inactive {
    background: #f8d7da;
    color: #721c24;
  }

.modal-body input,
  .modal-body textarea {
    margin-bottom: 15px;
  }
</style>

<div class="content">
  <div class="d-flex justify-content-between align-items-center mb-4">
    <h2>Manage Cities</h2>
    <button class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#addCityModal">
      <i class="fas fa-plus"></i> Add New City
    </button>
  </div>

<?php
  include 'includes/db.php';

// Handle Add City
  if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] == 'add') {
      $name = mysqli_real_escape_string($conn, $_POST['city_name']);
      $slug = strtolower(str_replace(' ', '-', $name));
      $description = mysqli_real_escape_string($conn, $_POST['city_description']);
      $status = $_POST['city_status'];

$check = mysqli_query($conn, "SELECT id FROM cities WHERE slug='$slug'");
      if (mysqli_num_rows($check) > 0) {
        $error = "City already exists!";
      } else {
        $query = "INSERT INTO cities (name, slug, description, status) VALUES ('$name', '$slug', '$description', '$status')";
        if (mysqli_query($conn, $query)) {
          $success = "City added successfully!";
        } else {
          $error = "Error adding city: " . mysqli_error($conn);
        }
      }
    } elseif ($_POST['action'] == 'edit') {
      $city_id = (int)$_POST['city_id'];
      $name = mysqli_real_escape_string($conn, $_POST['city_name']);
      $description = mysqli_real_escape_string($conn, $_POST['city_description']);
      $status = $_POST['city_status'];

$query = "UPDATE cities SET name='$name', description='$description', status='$status' WHERE id=$city_id";
      if (mysqli_query($conn, $query)) {
        $success = "City updated successfully!";
      } else {
        $error = "Error updating city: " . mysqli_error($conn);
      }
    } elseif ($_POST['action'] == 'delete') {
      $city_id = (int)$_POST['city_id'];
      $query = "DELETE FROM cities WHERE id=$city_id";
      if (mysqli_query($conn, $query)) {
        $success = "City deleted successfully!";
      } else {
        $error = "Error deleting city: " . mysqli_error($conn);
      }
    }
  }

if (isset($success)) {
    echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
      ' . $success . '
      <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>';
  }
  if (isset($error)) {
    echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
      ' . $error . '
      <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
    </div>';
  }

$result = mysqli_query($conn, "SELECT * FROM cities ORDER BY name ASC");
  $cities = mysqli_fetch_all($result, MYSQLI_ASSOC);

if (empty($cities)) {
    echo '<div class="alert alert-info">No cities added yet. <button class="btn btn-sm btn-primary" data-bs-toggle="modal" data-bs-target="#addCityModal">Add your first city</button></div>';
  } else {
    foreach ($cities as $city) {
  ?>
  <div class="city-card">
    <div class="city-info">
      <h4><?php echo htmlspecialchars($city['name']); ?></h4>
      <p><?php echo htmlspecialchars(substr($city['description'], 0, 100)); ?></p>
      <p style="margin-top: 8px;">
        <span class="status-badge status-<?php echo $city['status']; ?>">
          <?php echo ucfirst($city['status']); ?>
        </span>
      </p>
    </div>
    <div class="city-actions">
      <button class="btn btn-sm btn-warning" data-bs-toggle="modal" data-bs-target="#editCityModal"
        onclick="editCity(<?php echo $city['id']; ?>, '<?php echo htmlspecialchars($city['name']); ?>', '<?php echo htmlspecialchars($city['description']); ?>', '<?php echo $city['status']; ?>')">
        <i class="fas fa-edit"></i> Edit
      </button>
      <form method="POST" style="display:inline;">
        <input type="hidden" name="action" value="delete">
        <input type="hidden" name="city_id" value="<?php echo $city['id']; ?>">
        <button type="submit" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure?')">
          <i class="fas fa-trash"></i> Delete
        </button>
      </form>
    </div>
  </div>
  <?php
    }
  }
  ?>
</div>

<div class="modal fade" id="addCityModal" tabindex="-1">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title">Add New City</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
      </div>
      <form method="POST">
        <div class="modal-body">
          <input type="hidden" name="action" value="add">
          
          <div class="mb-3">
            <label class="form-label">City Name *</label>
            <input type="text" name="city_name" class="form-control" placeholder="e.g., Dehradun" required>
          </div>

<div class="mb-3">
            <label class="form-label">Description</label>
            <textarea name="city_description" class="form-control" rows="3" placeholder="Describe this city..."></textarea>
          </div>

<div class="mb-3">
            <label class="form-label">Status</label>
            <select name="city_status" class="form-control">
              <option value="active">Active</option>
              <option value="inactive">Inactive</option>
            </select>
          </div>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
          <button type="submit" class="btn btn-primary">Add City</button>
        </div>
      </form>
    </div>
  </div>
</div>

<div class="modal fade" id="editCityModal" tabindex="-1">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title">Edit City</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
      </div>
      <form method="POST">
        <div class="modal-body">
          <input type="hidden" name="action" value="edit">
          <input type="hidden" name="city_id" id="editCityId">
          
          <div class="mb-3">
            <label class="form-label">City Name *</label>
            <input type="text" name="city_name" id="editCityName" class="form-control" required>
          </div>

<div class="mb-3">
            <label class="form-label">Description</label>
            <textarea name="city_description" id="editCityDescription" class="form-control" rows="3"></textarea>
          </div>

<div class="mb-3">
            <label class="form-label">Status</label>
            <select name="city_status" id="editCityStatus" class="form-control">
              <option value="active">Active</option>
              <option value="inactive">Inactive</option>
            </select>
          </div>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
          <button type="submit" class="btn btn-primary">Update City</button>
        </div>
      </form>
    </div>
  </div>
</div>

</body>
</html>

Cancel