

<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;'>✏ 编辑: add-review.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
session_start();
require_once '../config.php';

if (!isset($_SESSION['admin_logged_in'])) {
    header('Location: /login.php');
    exit();
}

$conn = getDBConnection();
$conn-&gt;set_charset(&quot;utf8mb4&quot;);

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $author_name = trim($_POST['author_name']);
    $rating = (int)$_POST['rating'];
    $text = trim($_POST['text']);
    $status = $_POST['status'];
    $review_date = $_POST['review_date']; // Manual date input
    
    $stmt = $conn-&gt;prepare(&quot;INSERT INTO google_review (author_name, rating, text, status, created_at) VALUES (?, ?, ?, ?, ?)&quot;);
    $stmt-&gt;bind_param(&quot;sisss&quot;, $author_name, $rating, $text, $status, $review_date);
    
    if ($stmt-&gt;execute()) {
        $_SESSION['success_message'] = &quot;Review added successfully!&quot;;
        header('Location: reviews.php');
        exit();
    } else {
        $error = &quot;Error adding review: &quot; . htmlspecialchars($stmt-&gt;error);
    }
    $stmt-&gt;close();
}

$conn-&gt;close();
?&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;Add New Review - Admin Panel&lt;/title&gt;
    &lt;link href=&quot;https://fonts.googleapis.com/css2?family=El+Messiri:wght@400;500;600;700&amp;display=swap&quot; rel=&quot;stylesheet&quot;&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css&quot;/&gt;
    &lt;style&gt;
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }

        body {
            font-family: 'El Messiri', sans-serif;
            background: #f5f5f5;
            padding: 20px;
        }

        .container {
            max-width: 800px;
            margin: 0 auto;
            background: white;
            border-radius: 10px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
            overflow: hidden;
        }

        .header {
            background: linear-gradient(135deg, #ccab85 0%, #f9f1d3 50%, #dbc6a5 100%);
            padding: 30px;
            color: #862033;
        }

        .header h1 {
            font-size: 28px;
            font-weight: 700;
        }

        .content {
            padding: 30px;
        }

        .form-group {
            margin-bottom: 25px;
        }

        .form-group label {
            display: block;
            margin-bottom: 8px;
            color: #333;
            font-weight: 600;
        }

        .form-group label .required {
            color: #dc3545;
        }

        .form-group input,
        .form-group textarea,
        .form-group select {
            width: 100%;
            padding: 12px;
            border: 1px solid #ddd;
            border-radius: 5px;
            font-family: 'El Messiri', sans-serif;
            font-size: 16px;
        }

        .form-group textarea {
            min-height: 120px;
            resize: vertical;
        }

        .star-rating {
            display: flex;
            gap: 5px;
            font-size: 30px;
            color: #ddd;
            cursor: pointer;
        }

        .star-rating .star {
            transition: color 0.2s;
        }

        .star-rating .star.active {
            color: #FFD700;
        }

        .btn {
            padding: 12px 30px;
            border: none;
            border-radius: 5px;
            cursor: pointer;
            font-family: 'El Messiri', sans-serif;
            font-weight: 600;
            font-size: 16px;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 8px;
            transition: all 0.3s ease;
        }

        .btn-primary {
            background: #862033;
            color: white;
        }

        .btn-primary:hover {
            background: #6a1a28;
        }

        .btn-secondary {
            background: #6c757d;
            color: white;
        }

        .btn-actions {
            display: flex;
            gap: 15px;
            margin-top: 30px;
        }

        .error-message {
            background: #f8d7da;
            color: #721c24;
            padding: 15px;
            border-radius: 5px;
            margin-bottom: 20px;
            border: 1px solid #f5c6cb;
        }

        .char-count {
            text-align: right;
            font-size: 14px;
            color: #666;
            margin-top: 5px;
        }

        .date-helper {
            font-size: 13px;
            color: #666;
            margin-top: 5px;
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;div class=&quot;container&quot;&gt;
        &lt;div class=&quot;header&quot;&gt;
            &lt;h1&gt;&lt;i class=&quot;fas fa-plus-circle&quot;&gt;&lt;/i&gt; Add New Review&lt;/h1&gt;
        &lt;/div&gt;

        &lt;div class=&quot;content&quot;&gt;
            &lt;?php if (isset($error)): ?&gt;
                &lt;div class=&quot;error-message&quot;&gt;
                    &lt;i class=&quot;fas fa-exclamation-circle&quot;&gt;&lt;/i&gt; &lt;?php echo $error; ?&gt;
                &lt;/div&gt;
            &lt;?php endif; ?&gt;

            &lt;form method=&quot;POST&quot; accept-charset=&quot;UTF-8&quot;&gt;
                &lt;div class=&quot;form-group&quot;&gt;
                    &lt;label&gt;Customer Name &lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
                    &lt;input type=&quot;text&quot; name=&quot;author_name&quot; required placeholder=&quot;Enter customer name&quot; maxlength=&quot;255&quot;&gt;
                &lt;/div&gt;

                &lt;div class=&quot;form-group&quot;&gt;
                    &lt;label&gt;Rating &lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
                    &lt;div class=&quot;star-rating&quot; id=&quot;starRating&quot;&gt;
                        &lt;span class=&quot;star&quot; data-value=&quot;1&quot;&gt;★&lt;/span&gt;
                        &lt;span class=&quot;star&quot; data-value=&quot;2&quot;&gt;★&lt;/span&gt;
                        &lt;span class=&quot;star&quot; data-value=&quot;3&quot;&gt;★&lt;/span&gt;
                        &lt;span class=&quot;star&quot; data-value=&quot;4&quot;&gt;★&lt;/span&gt;
                        &lt;span class=&quot;star&quot; data-value=&quot;5&quot;&gt;★&lt;/span&gt;
                    &lt;/div&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;rating&quot; id=&quot;ratingInput&quot; value=&quot;5&quot; required&gt;
                &lt;/div&gt;

                &lt;div class=&quot;form-group&quot;&gt;
                    &lt;label&gt;Review Text &lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
                    &lt;textarea name=&quot;text&quot; id=&quot;reviewText&quot; required placeholder=&quot;Enter customer review...&quot; maxlength=&quot;2000&quot;&gt;&lt;/textarea&gt;
                    &lt;div class=&quot;char-count&quot;&gt;
                        &lt;span id=&quot;charCount&quot;&gt;0&lt;/span&gt; / 2000 characters
                    &lt;/div&gt;
                &lt;/div&gt;

                &lt;div class=&quot;form-group&quot;&gt;
                    &lt;label&gt;Review Date &lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
                    &lt;input type=&quot;datetime-local&quot; name=&quot;review_date&quot; id=&quot;reviewDate&quot; required&gt;
                    &lt;div class=&quot;date-helper&quot;&gt;
                        &lt;i class=&quot;fas fa-info-circle&quot;&gt;&lt;/i&gt; Select the date when this review was posted
                    &lt;/div&gt;
                &lt;/div&gt;

                &lt;div class=&quot;form-group&quot;&gt;
                    &lt;label&gt;Status &lt;span class=&quot;required&quot;&gt;*&lt;/span&gt;&lt;/label&gt;
                    &lt;select name=&quot;status&quot; required&gt;
                        &lt;option value=&quot;active&quot;&gt;Active&lt;/option&gt;
                        &lt;option value=&quot;inactive&quot;&gt;Inactive&lt;/option&gt;
                    &lt;/select&gt;
                &lt;/div&gt;

                &lt;div class=&quot;btn-actions&quot;&gt;
                    &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;
                        &lt;i class=&quot;fas fa-save&quot;&gt;&lt;/i&gt; Add Review
                    &lt;/button&gt;
                    &lt;a href=&quot;reviews.php&quot; class=&quot;btn btn-secondary&quot;&gt;
                        &lt;i class=&quot;fas fa-times&quot;&gt;&lt;/i&gt; Cancel
                    &lt;/a&gt;
                &lt;/div&gt;
            &lt;/form&gt;
        &lt;/div&gt;
    &lt;/div&gt;

    &lt;script&gt;
        // Star rating functionality
        const stars = document.querySelectorAll('.star');
        const ratingInput = document.getElementById('ratingInput');
        
        stars.forEach(star =&gt; {
            star.addEventListener('click', function() {
                const value = this.getAttribute('data-value');
                ratingInput.value = value;
                updateStars(value);
            });
        });
        
        function updateStars(rating) {
            stars.forEach(star =&gt; {
                if (star.getAttribute('data-value') &lt;= rating) {
                    star.classList.add('active');
                } else {
                    star.classList.remove('active');
                }
            });
        }
        
        // Initialize with 5 stars
        updateStars(5);

        // Character counter
        const reviewText = document.getElementById('reviewText');
        const charCount = document.getElementById('charCount');
        
        reviewText.addEventListener('input', function() {
            charCount.textContent = this.value.length;
        });

        // Set default date to current date and time
        document.addEventListener('DOMContentLoaded', function() {
            const now = new Date();
            const year = now.getFullYear();
            const month = String(now.getMonth() + 1).padStart(2, '0');
            const day = String(now.getDate()).padStart(2, '0');
            const hours = String(now.getHours()).padStart(2, '0');
            const minutes = String(now.getMinutes()).padStart(2, '0');
            
            const dateTimeValue = `${year}-${month}-${day}T${hours}:${minutes}`;
            document.getElementById('reviewDate').value = dateTimeValue;
        });
    &lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/askmanisha/public_html/admin/add-review.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' 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>