File "edit_single.php"

Full Path: /home/alphpwcp/previewstream.online/admin/edit_single.php
File size: 3.9 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?php
session_start();
include '../db.php';

// Check if admin is logged in
if (!isset($_SESSION['admin_id'])) {
    header('Location: login.php');
    exit;
}

// Get company ID from URL
$id = intval($_GET['id'] ?? 0);

// Fetch existing company data
$stmt = $pdo->prepare("SELECT * FROM companies WHERE id = ?");
$stmt->execute([$id]);
$company = $stmt->fetch();

if (!$company) {
    die('Company not found!');
}

// Fetch categories for dropdown
$categories = $pdo->query("SELECT id, name FROM categories")->fetchAll();

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = trim($_POST['name']);
    $website = trim($_POST['website']);
    $region = trim($_POST['region']);
    $category_id = intval($_POST['category_id']) ?: null;
    $description = trim($_POST['description']);

    // File upload handling
    $image = $company['image']; // keep current image by default
    if (!empty($_FILES['image']['name'])) {
        $uploadDir = '../images/companies/';
        $newImage = basename($_FILES['image']['name']);
        $targetFile = $uploadDir . $newImage;

        // Move uploaded file
        if (move_uploaded_file($_FILES['image']['tmp_name'], $targetFile)) {
            $image = $newImage;
        }
    }

    // Update database, now including description
    $update = $pdo->prepare("
        UPDATE companies
        SET name = ?, website = ?, region = ?, category_id = ?, image = ?, description = ?
        WHERE id = ?
    ");
    $update->execute([$name, $website, $region, $category_id, $image, $description, $id]);

    header('Location: edit_company.php?success=1');
    exit;
}
?>

<?php include 'menu.php'; ?>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Edit Company - Admin</title>
<link rel="stylesheet" href="../style.css">
<style>
    .container { max-width:400px; margin:2rem auto; }
    form { display:flex; flex-direction:column; gap:0.8rem; }
    label { font-weight: bold; }
    input[type="text"], select, textarea { padding:0.6rem; border-radius:6px; border:1px solid #ccc; }
    button { padding:0.6rem; background:#007BFF; color:#fff; border:none; border-radius:6px; cursor:pointer; }
    button:hover { background:#0056b3; }
</style>
</head>
<body>
<div class="container">
    <h2>Edit Company: <?= htmlspecialchars($company['name']) ?></h2>
    <form method="post" enctype="multipart/form-data">
        <label>Name:</label>
        <input type="text" name="name" value="<?= htmlspecialchars($company['name']) ?>" required>

        <label>Website:</label>
        <input type="text" name="website" value="<?= htmlspecialchars($company['website']) ?>">

        <label>Region:</label>
        <input type="text" name="region" value="<?= htmlspecialchars($company['region']) ?>">

        <label>Category:</label>
        <select name="category_id">
            <option value="">-- None --</option>
            <?php foreach ($categories as $cat): ?>
                <option value="<?= $cat['id'] ?>" <?= ($cat['id'] == $company['category_id']) ? 'selected' : '' ?>>
                    <?= htmlspecialchars($cat['name']) ?>
                </option>
            <?php endforeach; ?>
        </select>

        <label>Description:</label>
        <textarea name="description" rows="4"><?= htmlspecialchars($company['description']) ?></textarea>

        <label>Current Image:</label>
        <?php if ($company['image']): ?>
            <img src="../images/companies/<?= htmlspecialchars($company['image']) ?>" alt="Company Image" style="width:100px;">
        <?php else: ?>
            <p>No image uploaded</p>
        <?php endif; ?>

        <label>Upload New Image (optional):</label>
        <input type="file" name="image">

        <button type="submit">Update Company</button>
    </form>
    <p><a href="edit_company.php">← Back to Companies</a></p>
</div>
</body>
</html>