1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / onepluscosmetics / admin /
Filename : edit_product.php
back
<?php
session_start();
if (!isset($_SESSION['admin_user'])) {
    header("Location: admin_login.php");
    exit;
}

$host = "localhost";
$db_user = "root";
$db_pass = "u9-t6VA~>%@{!mX";
$db_name = "onepluscosmetics";

$conn = new mysqli($host, $db_user, $db_pass, $db_name);
if ($conn->connect_error) {
    die("DB connection failed: " . $conn->connect_error);
}

$msg = "";
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

// Fetch existing product
$product = [];
$stmt = $conn->prepare("SELECT * FROM products WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows === 1) {
    $product = $result->fetch_assoc();
} else {
    die("Product not found.");
}
$stmt->close();

// Update on POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = trim($_POST['product_name']);
    $desc = trim($_POST['product_description']);
    $admin_id = $_SESSION['admin_user']['id'];
$admin_username = $_SESSION['admin_user']['username'];
$modified_by = $admin_id . ' - ' . $admin_username;
    $modified_at = date('Y-m-d H:i:s');

    $image_name = $product['product_image']; // default to existing image

    // New image upload (if provided)
    if (isset($_FILES['product_image']) && $_FILES['product_image']['error'] === UPLOAD_ERR_OK) {
        $target_dir = "image/";
        $original = basename($_FILES["product_image"]["name"]);
        $ext = pathinfo($original, PATHINFO_EXTENSION);
        $image_name = uniqid("prod_") . "." . $ext;
        $target_path = $target_dir . $image_name;

        if (!move_uploaded_file($_FILES["product_image"]["tmp_name"], $target_path)) {
            $msg = "❌ Failed to upload new image.";
        }
    }

    $stmt = $conn->prepare("UPDATE products SET product_name = ?, product_image = ?, product_description = ?, modified_by = ?, modified_at = ? WHERE id = ?");
    $stmt->bind_param("sssssi", $name, $image_name, $desc, $modified_by, $modified_at, $id);

    if ($stmt->execute()) {
        $msg = "✅ Product updated successfully!";
        // Refresh data
        $product['product_name'] = $name;
        $product['product_image'] = $image_name;
        $product['product_description'] = $desc;
    } else {
        $msg = "❌ Update failed.";
    }
    $stmt->close();
}

$conn->close();
?>

<!DOCTYPE html>
<html>
<head>
  <title>Edit Product</title>
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">

  <!-- Inside your <head> tag -->
<script src="https://cdn.ckeditor.com/ckeditor5/39.0.1/classic/ckeditor.js"></script>

  <style>
    body { margin: 0; padding: 0; overflow-x: hidden; }
    .sidebar {
      background: #343a40; position: fixed; top: 0; left: 0;
      height: 100vh; width: 240px; padding-top: 20px; z-index: 1000;
    }
    .sidebar a {
      color: #fff; display: block; padding: 15px 20px; text-decoration: none;
    }
    .sidebar a:hover, .sidebar a.active {
      background-color: #007bff; color: #fff;
    }
    .content {
      margin-left: 240px; padding: 30px; background: #f4f6f9; min-height: 100vh;
    }
    .card {
      border: none; border-radius: 12px; box-shadow: 0 2px 8px rgba(0,0,0,0.1);
    }
    .product-preview {
      max-width: 120px; max-height: 120px; object-fit: cover; margin-top: 10px;
    }
  </style>
</head>
<body>

<div class="container-fluid">
  <div class="row">
    <!-- Sidebar -->
    <div class="col-md-3 col-lg-2 sidebar d-flex flex-column">
      <h4 class="text-white text-center mb-4">Admin Panel</h4>
      <a href="index.php"><i class="fas fa-home mr-2"></i> Dashboard</a>
      <a href="product_list.php" class="active"><i class="fas fa-list mr-2"></i> Product List</a>
      <a href="add_product.php"><i class="fas fa-plus mr-2"></i> Add Product</a>
      <a href="logout.php" class="text-danger mt-auto mb-3"><i class="fas fa-sign-out-alt mr-2"></i> Logout</a>
    </div>

    <!-- Content -->
    <div class="col-md-9 col-lg-10 content">
      <h2>Edit Product</h2>

      <?php if ($msg): ?>
        <div class="alert alert-info mt-3"><?php echo $msg; ?></div>
      <?php endif; ?>

      <div class="card mt-4 p-4">
        <form method="POST" action="" enctype="multipart/form-data">
          <div class="form-group">
            <label>Product Name</label>
            <input type="text" name="product_name" class="form-control" required value="<?php echo htmlspecialchars($product['product_name']); ?>">
          </div>

          <div class="form-group">
            <label>Product Image (optional to change)</label>
            <input type="file" name="product_image" class="form-control-file" accept="image/*">
            <img src="image/<?php echo htmlspecialchars($product['product_image']); ?>" class="product-preview mt-2" alt="Current Image">
          </div>

          <div class="form-group">
            <label>Product Description</label>
            <textarea name="product_description" id="editor" class="form-control" rows="4" ><?php echo htmlspecialchars($product['product_description']); ?></textarea>
            </div>

          <button type="submit" class="btn btn-success">Update Product</button>
        </form>
      </div>
    </div>
  </div>
</div>
<script>
  ClassicEditor
    .create(document.querySelector('#editor'))
    .catch(error => {
        console.error(error);
    });
</script>

</body>
</html>