File Manager

✏️ _dashboard.php

<?php
// 1. Error Reporting (Keep this during debugging)
error_reporting(E_ALL);
ini_set('display_errors', 1);

//if (session_status() === PHP_SESSION_NONE) { session_start(); }

include 'includes/db.php'; 
//include_once 'includes/functions.php';

// Ensure session is started for admin
if (session_status() === PHP_SESSION_NONE) { session_start(); }

// Set basic page variables so header.php doesn't crash
//$page_title = "Admin Dashboard | Global Auto Insight";
//$current_page = "admin";

$current_page = "admin";
$page_title = "Admin Dashboard";

function createSlug($string){
   $slug = strtolower(trim($string));
   $slug = preg_replace('/[^a-z0-9-]/', '-', $slug);
   $slug = preg_replace('/-+/', "-", $slug);
   return rtrim($slug, '-');
}

// 1. Check Login
if(!isset($_SESSION['admin'])){
    header("Location: admin_login.php");
    exit();
}

// 2. Define Page Variable
$page = isset($_GET['page']) ? $_GET['page'] : 'add_news';

// 3. Logout Logic
if(isset($_GET['logout'])) { 
    session_destroy(); 
    header("Location: admin_login.php"); 
    exit();
}

// 4. DELETE LOGIC
if(isset($_GET['delete_id'])){
    $del_id = intval($_GET['delete_id']);
    
    // Optional: Fetch image names to delete from folder
    $query = $conn->query("SELECT gallery_images FROM news WHERE id=$del_id");
    if($row = $query->fetch_assoc()){
        $imgs = explode(',', $row['gallery_images']);
        foreach($imgs as $file){
            if(!empty($file) && file_exists("image/".trim($file))){
                unlink("image/".trim($file)); // Delete file from folder
            }
        }
    }

$conn->query("DELETE FROM news WHERE id=$del_id");
    $conn->query("DELETE FROM feedback WHERE news_id=$del_id"); 
    echo "<script>alert('News Deleted Successfully'); window.location='admin_dashboard.php?page=view_news';</script>";
}

// --- 5. BULK DELETE NEWS LOGIC ---
    if(isset($_POST['bulk_delete_news'])){
        // Check if any checkboxes were checked
        if(isset($_POST['news_ids']) && is_array($_POST['news_ids'])){
            
            // Security: Convert all IDs to integers to prevent SQL injection
            $ids_array = array_map('intval', $_POST['news_ids']);
            
            // Create a comma-separated string (e.g., "1,5,9")
            $ids_string = implode(',', $ids_array);
            
            if(!empty($ids_string)){
                // 1. Delete from News Table
                $sql = "DELETE FROM news WHERE id IN ($ids_string)";
                $conn->query($sql);
                
                // 2. Optional: Delete related comments/feedback
                $conn->query("DELETE FROM feedback WHERE news_id IN ($ids_string)");
                
                echo "<script>alert('Selected News Deleted Successfully!'); window.location='admin_dashboard.php?page=view_news';</script>";
            }
        } else {
            echo "<script>alert('Please select at least one news item to delete.');</script>";
        }
    }

// 6. UPDATE LOGIC (Text + Images)
if(isset($_POST['update_news'])){
    $id = intval($_POST['edit_id']);
    
    // 1. Standard Fields
    $title = $conn->real_escape_string($_POST['title']);
    $short = $conn->real_escape_string($_POST['short_desc']);
    $keywords = $conn->real_escape_string($_POST['keywords']);
    $content = $conn->real_escape_string($_POST['content']);
    $cat = $_POST['category'];
    $link_url = isset($_POST['link_url']) ? $conn->real_escape_string($_POST['link_url']) : ''; 
    $link_text = isset($_POST['link_text']) ? $conn->real_escape_string($_POST['link_text']) : '';

// --- 2. GET EXISTING DATA (Crucial Step) ---
    // We need the CURRENT 'image_url' text from DB to name the files correctly
    $q_existing = $conn->query("SELECT image, gallery_images, image_url FROM news WHERE id=$id");
    $existing_data = $q_existing->fetch_assoc();
    
    // Determine the base name for the file
    // If 'image_url' column has text, use it. Otherwise, use the Title.
    $filename_base_text = !empty($existing_data['image_url']) ? $existing_data['image_url'] : $title;

// Sanitize this text for use as a filename (lowercase, dashes only)
    $clean_filename_base = preg_replace('/[^a-zA-Z0-9-]/', '-', strtolower(trim($filename_base_text)));
    $clean_filename_base = preg_replace('/-+/', '-', $clean_filename_base); // Remove double dashes

// --- 3. IMAGE HANDLING START ---
    $image_update_query = "";

// Check if NEW images are selected
    if(isset($_FILES['image']) && !empty($_FILES['image']['name'][0])){
        
        // A. Delete OLD images from folder (Cleanup)
        if(!empty($existing_data['image']) && file_exists("image/".$existing_data['image'])){
            unlink("image/".$existing_data['image']);
        }
        if(!empty($existing_data['gallery_images'])){
            $old_gallery = explode(',', $existing_data['gallery_images']);
            foreach($old_gallery as $old_file){
                if(!empty($old_file) && file_exists("image/".trim($old_file))){
                    unlink("image/".trim($old_file));
                }
            }
        }

// B. Upload NEW Images
        $all_images = array();
        $main_image = ""; 
        $total_files = count($_FILES['image']['name']);

for($i=0; $i < $total_files; $i++){
            $file_name = $_FILES['image']['name'][$i];
            $tmp_name  = $_FILES['image']['tmp_name'][$i];
            $error     = $_FILES['image']['error'][$i];

if($error === 0){
                
                // Get Extension
                $ext = pathinfo($file_name, PATHINFO_EXTENSION);

// --- RENAMING LOGIC ---
                // Format: db_image_url_text + "_" + timestamp + .ext
                // Example: gwm-brazil-expansion_1769533407.jpg
                $unique_name = $clean_filename_base . "_" . time() . "_" . $i . "." . $ext;
                
                // Upload to 'image/' folder
                if(move_uploaded_file($tmp_name, "image/" . $unique_name)){
                    $all_images[] = $unique_name;
                    if($i == 0){ $main_image = $unique_name; }
                }
            }
        }

$gallery_string = implode(',', $all_images);
        
        // Prepare SQL update part for images
        if(!empty($main_image)){
            $image_update_query = ", image='$main_image', gallery_images='$gallery_string'";
        }
    }
    // --- IMAGE HANDLING END ---

// 4. FINAL SQL UPDATE
    // Note: We do NOT update 'image_url' column here, so the text stays safe.
    $sql = "UPDATE news SET 
            title='$title', 
            short_desc='$short', 
            keywords='$keywords', 
            content='$content', 
            category='$cat',
            link_url='$link_url',
            link_text='$link_text'
            $image_update_query 
            WHERE id='$id'";
    
    if($conn->query($sql)){
        echo "<script>alert('News Updated Successfully'); window.location='admin_dashboard.php?page=view_news';</script>";
    } else {
        echo "<script>alert('Error updating news: " . $conn->error . "');</script>";
    }
}

// 7. ADD NEWS LOGIC
if(isset($_POST['add_news'])){
    // 1. Basic Fields
    $title    = $conn->real_escape_string($_POST['title']);
    $short    = $conn->real_escape_string($_POST['short_desc']);
    $content  = $conn->real_escape_string($_POST['content']);
    $cat      = $conn->real_escape_string($_POST['category']); // Escaped for safety
    $link_url = $conn->real_escape_string($_POST['link_url']);
    $link_text = $conn->real_escape_string($_POST['link_text']);
    $keywords = $conn->real_escape_string($_POST['keywords']);
    
    // 2. SEO Fields
    $meta_title = !empty($_POST['meta_title']) ? $conn->real_escape_string($_POST['meta_title']) : $title;
    $meta_desc  = $conn->real_escape_string($_POST['meta_description']);
    $prim_key   = $conn->real_escape_string($_POST['primary_keyword']);
    $sec_keys   = $conn->real_escape_string($_POST['secondary_keywords']);
    $alt_text   = $conn->real_escape_string($_POST['image_alt_text']);
    $image_url_text = $conn->real_escape_string($_POST['image_url']);
    
    // 3. Generate SEO URL (Slug) - Clean and Unique
    $input_slug = $_POST['seo_url'];
    $seo_url = !empty($input_slug) ? createSlug($input_slug) : createSlug($title);

// 4. IMAGE HANDLING
    $filename_base = !empty($image_url_text) ? $image_url_text : $title;
    $clean_filename_base = preg_replace('/[^a-zA-Z0-9-]/', '-', strtolower(trim($filename_base)));
    $clean_filename_base = preg_replace('/-+/', '-', $clean_filename_base);

if (!file_exists('image')) { 
        mkdir('image', 0777, true); 
    }

$all_images = array();
    $main_image = "";

if(isset($_FILES['image']) && !empty($_FILES['image']['name'][0])){
        $total_files = count($_FILES['image']['name']);
        for($i=0; $i < $total_files; $i++){
            $file_name  = $_FILES['image']['name'][$i];
            $tmp_name   = $_FILES['image']['tmp_name'][$i];
            $error_code = $_FILES['image']['error'][$i];

if ($error_code === 0) {
                $ext = pathinfo($file_name, PATHINFO_EXTENSION);
                // Added uniqid() to prevent physical file overwrites
                $unique_name = $clean_filename_base . "_" . time() . "_" . $i . "." . $ext;
                
                if(move_uploaded_file($tmp_name, "image/" . $unique_name)){
                    $all_images[] = $unique_name;
                    if($i == 0){ $main_image = $unique_name; }
                }
            }
        }
    }
    $gallery_string = implode(',', $all_images);

// 5. DUPLICATE CHECK (Optional but recommended for better UX)
    $check = $conn->query("SELECT id FROM news WHERE seo_url = '$seo_url'");
    if($check->num_rows > 0) {
        // If slug exists, append a random string to make it unique
        $seo_url .= '-' . rand(10, 99);
    }

// 6. INSERT QUERY
    $sql = "INSERT INTO news (
        title, short_desc, keywords, content, image, gallery_images, category, 
        link_text, link_url, seo_url, meta_title, meta_description, 
        primary_keyword, secondary_keywords, image_alt_text, image_url
    ) VALUES (
        '$title', '$short', '$keywords', '$content', '$main_image', '$gallery_string', '$cat', 
        '$link_text', '$link_url', '$seo_url', '$meta_title', '$meta_desc', 
        '$prim_key', '$sec_keys', '$alt_text', '$image_url_text'
    )";
    
    // Execute and Check
    if($conn->query($sql)){
        echo "<script>alert('News Published Successfully!'); window.location='admin_dashboard.php?page=view_news';</script>";
    } else {
        // If it still fails, it will show the exact SQL error
        echo "<script>alert('Database Error: " . addslashes($conn->error) . "');</script>";
    }
}

// 8. Upload CSV File Logic - MULTI-COLUMN IMAGE DOWNLOADER
    if(isset($_POST['debug_import'])){
        
        if($_FILES['csv_file']['error'] == 0){
            // 1. Server Prep
            set_time_limit(0); 
            ini_set('memory_limit', '1024M');
            
            $filename = $_FILES['csv_file']['tmp_name'];
            ini_set('auto_detect_line_endings', TRUE);
            
            // Use Absolute Paths for Hostinger
            $root_path = rtrim($_SERVER['DOCUMENT_ROOT'], '/');
            $target_dir1 = $root_path . "/image/";  
            $target_dir2 = $root_path . "/images/"; 
            
            if (!file_exists($target_dir1)) { mkdir($target_dir1, 0755, true); }
            if (!file_exists($target_dir2)) { mkdir($target_dir2, 0755, true); }
    
            /**
             * HELPER FUNCTION: Download Image
             * Handles SSL, Redirects, and detect extensions for Google Thumbnails
             */
            function downloadNewsImage($url, $save_name_base, $dir1, $dir2, $index = 0) {
                if(empty($url) || !filter_var($url, FILTER_VALIDATE_URL)) return '';
    
                $ch = curl_init();
                curl_setopt($ch, CURLOPT_URL, $url);
                curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
                curl_setopt($ch, CURLOPT_BINARYTRANSFER, 1);
                curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
                curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
                curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
                curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36');
                curl_setopt($ch, CURLOPT_TIMEOUT, 30);
                
                $raw_data = curl_exec($ch);
                $info = curl_getinfo($ch);
                curl_close($ch);
    
                if($info['http_code'] == 200 && !empty($raw_data)) {
                    // Determine Extension from Content-Type (Fixes gstatic issue)
                    $mime = $info['content_type'];
                    $ext = 'jpg';
                    if(strpos($mime, 'png') !== false) $ext = 'png';
                    elseif(strpos($mime, 'webp') !== false) $ext = 'webp';
                    elseif(strpos($mime, 'gif') !== false) $ext = 'gif';
    
                    $final_name = $save_name_base . "-" . uniqid() . "-" . $index . "." . $ext;
                    
                    // Save to 'image' folder
                    if(file_put_contents($dir1 . $final_name, $raw_data)) {
                        // Copy to 'images' folder
                        copy($dir1 . $final_name, $dir2 . $final_name);
                        return $final_name;
                    }
                }
                return '';
            }
    
            $handle = fopen($filename, "r");
            if($handle) {
                fgetcsv($handle); // Skip Header
                
                $inserted = 0; $skipped = 0; $errors = [];
    
                while(($data = fgetcsv($handle, 10000, ",")) !== FALSE){
                    
                    // --- 1. MAPPING ---
                    $title        = isset($data[0]) ? $conn->real_escape_string($data[0]) : '';
                    if(empty($title)){ continue; }
    
                    $short_desc   = isset($data[1]) ? $conn->real_escape_string($data[1]) : '';
                    $keywords     = isset($data[2]) ? $conn->real_escape_string($data[2]) : '';
                    $content      = isset($data[3]) ? $conn->real_escape_string($data[3]) : '';
                    
                    // Column 4 & 5 now contain LINKS to download
                    $main_img_url    = isset($data[4]) ? trim($data[4]) : ''; 
                    $gallery_links   = isset($data[5]) ? trim($data[5]) : '';
                    
                    $category     = isset($data[6]) ? $conn->real_escape_string($data[6]) : '';
                    $link_text    = isset($data[7]) ? $conn->real_escape_string($data[7]) : '';
                    $link_url     = isset($data[8]) ? $conn->real_escape_string($data[8]) : '';
                    
                    $raw_slug     = isset($data[9]) ? trim($data[9]) : '';
                    $seo_url      = !empty($raw_slug) ? $conn->real_escape_string($raw_slug) : createSlug($title);
    
                    $meta_title   = isset($data[10]) ? $conn->real_escape_string($data[10]) : '';
                    $meta_desc    = isset($data[11]) ? $conn->real_escape_string($data[11]) : '';
                    $prim_key     = isset($data[12]) ? $conn->real_escape_string($data[12]) : '';
                    $sec_keys     = isset($data[13]) ? $conn->real_escape_string($data[13]) : '';
                    $image_alt    = isset($data[14]) ? $conn->real_escape_string($data[14]) : '';
                    $source_url   = isset($data[15]) ? trim($data[15]) : '';
    
                    // --- 2. DOWNLOAD MAIN IMAGE (Column 4) ---
                    $db_image_name = downloadNewsImage($main_img_url, $seo_url, $target_dir1, $target_dir2, 0);
    
                    // --- 3. DOWNLOAD GALLERY IMAGES (Column 5) ---
                    $gallery_filenames = [];
                    if(!empty($gallery_links)) {
                        $urls = explode(',', $gallery_links);
                        foreach($urls as $idx => $url) {
                            $dl_name = downloadNewsImage(trim($url), $seo_url, $target_dir1, $target_dir2, ($idx + 1));
                            if($dl_name) $gallery_filenames[] = $dl_name;
                        }
                    }
                    $db_gallery_string = implode(',', $gallery_filenames);
    
                    // --- 4. DATABASE INSERT ---
                    $sql = "INSERT IGNORE INTO news (
                        title, short_desc, keywords, content, image, 
                        gallery_images, category, link_text, link_url, 
                        seo_url, meta_title, meta_description, 
                        primary_keyword, secondary_keywords, image_alt_text, image_url
                    ) VALUES (
                        '$title', '$short_desc', '$keywords', '$content', '$db_image_name', 
                        '$db_gallery_string', '$category', '$link_text', '$link_url', 
                        '$seo_url', '$meta_title', '$meta_desc', 
                        '$prim_key', '$sec_keys', '$image_alt', '$source_url'
                    )";
                    
                    if($conn->query($sql) && $conn->affected_rows > 0){ 
                        $inserted++; 
                    } else { 
                        $skipped++; 
                    }
                }
                fclose($handle);
                
                $msg = "Import Finished!\\nSuccess: $inserted\\nSkipped: $skipped";
                echo "<script>alert('$msg'); window.location.href='admin_dashboard.php?page=view_news';</script>";
            }
        }
    }
    
    // --- 9. DELETE FEEDBACK LOGIC ---
    if(isset($_GET['delete_feedback_id'])){
        $fb_id = intval($_GET['delete_feedback_id']);
        $conn->query("DELETE FROM feedback WHERE id=$fb_id");
        echo "<script>alert('Feedback Deleted Successfully'); window.location='admin_dashboard.php?page=feedbacks';</script>";
    }
    
    // ---10. DELETE CONTACT MESSAGE LOGIC ---
    if(isset($_GET['delete_contact_id'])){
        $c_id = intval($_GET['delete_contact_id']);
        $conn->query("DELETE FROM contact_messages WHERE id=$c_id");
        echo "<script>alert('Message Deleted Successfully'); window.location='admin_dashboard.php?page=contacts';</script>";
    }
    
    // ---11. DELETE LOGIC (Market Insights) ---
    if(isset($_GET['delete_insight_id'])){
        $del_id = intval($_GET['delete_insight_id']);
        $conn->query("DELETE FROM market_insights WHERE id=$del_id");
        echo "<script>alert('Insight Deleted'); window.location='?page=add_market_insights';</script>";
    }
    
    
// ---12. ADD MARKET INSIGHT LOGIC ---
    // --- ADD MARKET INSIGHT LOGIC ---
        if(isset($_POST['add_insight'])){
            
            // 0. Basic & Categorization Fields
            $main_tab    = $conn->real_escape_string($_POST['main_tab']);
            $region      = $conn->real_escape_string($_POST['region']);
            $country     = $conn->real_escape_string($_POST['country']);
            $sub_cat     = $conn->real_escape_string($_POST['sub_category']);
            
            // 1. Content Fields
            $title    = $conn->real_escape_string($_POST['mi_title']);
            $content  = $conn->real_escape_string($_POST['mi_content']); 
            $link_url = $conn->real_escape_string($_POST['mi_link_url']);
            $link_text = $conn->real_escape_string($_POST['mi_link_text']);
            
            // 2. SEO Fields
            $meta_title = !empty($_POST['mi_meta_title']) ? $conn->real_escape_string($_POST['mi_meta_title']) : $title;
            $meta_desc  = $conn->real_escape_string($_POST['mi_meta_description']);
            $prim_key   = $conn->real_escape_string($_POST['mi_primary_keywords']);
            $sec_keys   = $conn->real_escape_string($_POST['mi_secondary_keywords']);
            $alt_text   = $conn->real_escape_string($_POST['mi_image_alt_text']);
            $image_url_text = $conn->real_escape_string($_POST['mi_image_url']);
            
            // 3. Generate SEO URL (Slug)
            $input_slug = $_POST['mi_seo_url'];
            $seo_url = !empty($input_slug) ? createSlug($input_slug) : createSlug($title);
        
            // 4. IMAGE HANDLING (Updated to match mi_image name)
            $filename_base = !empty($image_url_text) ? $image_url_text : $title;
            $clean_filename_base = preg_replace('/[^a-zA-Z0-9-]/', '-', strtolower(trim($filename_base)));
            $clean_filename_base = preg_replace('/-+/', '-', $clean_filename_base);
            
            if (!file_exists('image')) { mkdir('image', 0777, true); }
            
            // Inside: if(isset($_POST['add_insight']))

$all_images = array();
            $main_image = ""; 
            
            // MUST MATCH THE HTML NAME: mi_image
            if(isset($_FILES['mi_image']) && !empty($_FILES['mi_image']['name'][0])){
                $total_files = count($_FILES['mi_image']['name']);
                for($i=0; $i < $total_files; $i++){
                    $file_name  = $_FILES['mi_image']['name'][$i];
                    $tmp_name   = $_FILES['mi_image']['tmp_name'][$i];
                    $error_code = $_FILES['mi_image']['error'][$i];
            
                    if ($error_code === 0) {
                        $ext = pathinfo($file_name, PATHINFO_EXTENSION);
                        $unique_name = $clean_filename_base . "_" . time() . "_" . uniqid() . "_" . $i . "." . $ext;
                        
                        if(move_uploaded_file($tmp_name, "image/" . $unique_name)){
                            $all_images[] = $unique_name;
                            if($i == 0){ $main_image = $unique_name; }
                        }
                    }
                }
            }
            $gallery_string = implode(',', $all_images);
            
            // Now perform your INSERT query using $main_image and $gallery_string
        
            // 5. DUPLICATE CHECK (For mi_seo_url)
            $check = $conn->query("SELECT id FROM market_insights WHERE mi_seo_url = '$seo_url'");
            if($check->num_rows > 0) {
                $seo_url .= '-' . rand(100, 999); // Add 3 random digits if duplicate
            }
        
            // 6. INSERT QUERY (Mapped to all columns)
            $sql = "INSERT INTO market_insights (
                main_tab, region, country, sub_category,
                mi_title,mi_content,
                mi_image, mi_gallery_images, mi_link_text, mi_link_url, 
                mi_seo_url, mi_meta_title, mi_meta_description, 
                mi_primary_keywords, mi_secondary_keywords, mi_image_alt_text, mi_image_url
            ) VALUES (
                '$main_tab', '$region', '$country', '$sub_cat',
                '$title', '$content',
                '$main_image', '$gallery_string', '$link_text', '$link_url', 
                '$seo_url', '$meta_title', '$meta_desc', 
                '$prim_key', '$sec_keys', '$alt_text', '$image_url_text'
            )";
            
            if($conn->query($sql)){
                echo "<script>alert('Market Insight Published Successfully!'); window.location='admin_dashboard.php?page=view_market';</script>";
            } else {
                echo "<script>alert('Database Error: " . addslashes($conn->error) . "');</script>";
            }
        }
    
    
    // --- SINGLE DELETE MARKET INSIGHT ---
        if (isset($_GET['delete_market_id'])) {
            $id = intval($_GET['delete_market_id']);
        
            // Fetch filenames first to delete from folder
            $res = $conn->query("SELECT mi_image, mi_gallery_images FROM market_insights WHERE id = $id");
            if ($row = $res->fetch_assoc()) {
                // Collect all images (Main + Gallery)
                $files_to_remove = array_filter(explode(',', $row['mi_image'] . ',' . $row['mi_gallery_images']));
                
                foreach ($files_to_remove as $file) {
                    $file = trim($file);
                    if (!empty($file)) {
                        @unlink("image/" . $file);  // Delete from image folder
                        @unlink("images/" . $file); // Delete from images folder
                    }
                }
            }
        
            // Now delete from Database
            if ($conn->query("DELETE FROM market_insights WHERE id = $id")) {
                echo "<script>alert('Insight and associated files deleted!'); window.location='admin_dashboard.php?page=view_market';</script>";
            }
        }
        
    // --- BULK DELETE MARKET INSIGHTS ---
        if (isset($_POST['bulk_delete_market'])) {
            
            // DEBUG LINE: Uncomment the line below if it still fails to see what is being sent
            // print_r($_POST); die(); 
        
            if (isset($_POST['market_ids']) && !empty($_POST['market_ids'])) {
                
                $ids_array = $_POST['market_ids'];
                
                // 1. Sanitize the IDs (Ensure they are all numbers)
                $clean_ids = array_map('intval', $ids_array);
                $ids_string = implode(',', $clean_ids);
        
                // 2. Delete associated images from folders first
                $res = $conn->query("SELECT mi_image, mi_gallery_images FROM market_insights WHERE id IN ($ids_string)");
                if($res){
                    while ($row = $res->fetch_assoc()) {
                        $files = array_filter(explode(',', $row['mi_image'] . ',' . $row['mi_gallery_images']));
                        foreach ($files as $file) {
                            $file = trim($file);
                            if(!empty($file)){
                                @unlink("image/" . $file);
                                @unlink("images/" . $file);
                            }
                        }
                    }
                }
        
                // 3. Execute Delete Query
                $sql = "DELETE FROM market_insights WHERE id IN ($ids_string)";
                
                if ($conn->query($sql)) {
                    echo "<script>alert('Successfully deleted " . count($clean_ids) . " items.'); window.location='admin_dashboard.php?page=view_market';</script>";
                } else {
                    echo "<script>alert('Database Error: " . $conn->error . "');</script>";
                }
            } else {
                // This is the error you are seeing
                echo "<script>alert('Error: No items were selected. Please check the boxes and try again.');</script>";
            }
        }

//---13. UPDATE MARKET INSIGHT LOGIC ---
    //--- UPDATE MARKET INSIGHT LOGIC ---
        if(isset($_POST['update_insight'])){
            $id = intval($_POST['mi_id']);
            
            // 1. Sanitize Basic Fields
            $main    = $conn->real_escape_string($_POST['main_tab']);
            $region  = $conn->real_escape_string($_POST['region']);
            $country = $conn->real_escape_string($_POST['country']);
            $sub     = $conn->real_escape_string($_POST['sub_category']);
            $title   = $conn->real_escape_string($_POST['mi_title']);
            $content = $conn->real_escape_string($_POST['mi_content']);
            $l_text  = $conn->real_escape_string($_POST['mi_link_text']);
            $l_url   = $conn->real_escape_string($_POST['mi_link_url']);
            
            // 2. SEO Fields
            $meta_t  = $conn->real_escape_string($_POST['mi_meta_title']);
            $meta_d  = $conn->real_escape_string($_POST['mi_meta_description']);
            $prim    = $conn->real_escape_string($_POST['mi_primary_keywords']);
            $sec     = $conn->real_escape_string($_POST['mi_secondary_keywords']);
            $alt     = $conn->real_escape_string($_POST['mi_image_alt_text']);
            $seo_url = createSlug($_POST['mi_seo_url']);
        
            // 3. IMAGE UPDATE LOGIC (Only if new files are selected)
            $image_update_sql = "";
            if(isset($_FILES['mi_image']) && !empty($_FILES['mi_image']['name'][0])){
                
                // Fetch old images to delete them from server
                $old = $conn->query("SELECT mi_image, mi_gallery_images FROM market_insights WHERE id=$id")->fetch_assoc();
                $old_files = array_filter(explode(',', $old['mi_image'].','.$old['mi_gallery_images']));
                foreach($old_files as $f) { @unlink("image/".trim($f)); @unlink("images/".trim($f)); }
        
                $all_images = [];
                $total = count($_FILES['mi_image']['name']);
                for($i=0; $i<$total; $i++){
                    $ext = pathinfo($_FILES['mi_image']['name'][$i], PATHINFO_EXTENSION);
                    $new_name = $seo_url."_".time()."_".uniqid()."_".$i.".".$ext;
                    if(move_uploaded_file($_FILES['mi_image']['tmp_name'][$i], "image/".$new_name)){
                        copy("image/".$new_name, "images/".$new_name); // Copy to both folders
                        $all_images[] = $new_name;
                    }
                }
                $main_img = $all_images[0] ?? '';
                $gal_img  = implode(',', $all_images);
                $image_update_sql = ", mi_image='$main_img', mi_gallery_images='$gal_img' ";
            }
        
            // 4. EXECUTE UPDATE
            $sql = "UPDATE market_insights SET 
                    main_tab='$main', region='$region', country='$country', sub_category='$sub',
                    mi_title='$title', mi_content='$content', 
                    mi_link_text='$l_text', mi_link_url='$l_url', mi_seo_url='$seo_url',
                    mi_meta_title='$meta_t', mi_meta_description='$meta_d', 
                    mi_primary_keywords='$prim', mi_secondary_keywords='$sec', mi_image_alt_text='$alt'
                    $image_update_sql 
                    WHERE id=$id";
        
            if($conn->query($sql)){
                echo "<script>alert('Insight Updated Successfully!'); window.location='admin_dashboard.php?page=view_market';</script>";
            } else {
                echo "<script>alert('Error: " . addslashes($conn->error) . "');</script>";
            }
        }

//---14. ADD POLICY TRACKER LOGIC ---
if(isset($_POST['add_policy'])){
    // 1. Basic Fields
    $region = $_POST['region'];
    $country = $conn->real_escape_string($_POST['country']);
    $title = $conn->real_escape_string($_POST['title']);
    $short = $conn->real_escape_string($_POST['short_desc']);
    $content = $conn->real_escape_string($_POST['content']);
    $link_url = $conn->real_escape_string($_POST['link_url']);
    $link_text = $conn->real_escape_string($_POST['link_text']);
    
    // 2. SEO Fields
    $meta_title = !empty($_POST['meta_title']) ? $conn->real_escape_string($_POST['meta_title']) : $title;
    $meta_desc = $conn->real_escape_string($_POST['meta_description']);
    $prim_key = $conn->real_escape_string($_POST['primary_keyword']);
    $sec_keys = $conn->real_escape_string($_POST['secondary_keywords']);
    $alt_text = $conn->real_escape_string($_POST['image_alt_text']);
    $image_url = $conn->real_escape_string($_POST['image_url']);
    
    // 3. SEO URL Generation (Crucial Step)
    $input_slug = $_POST['seo_url'];
    // If user didn't type a slug, generate it from the title
    $seo_url = !empty($input_slug) ? createSlug($input_slug) : createSlug($title);

// 4. Image Upload Logic
    if (!file_exists('image')) { mkdir('image', 0777, true); }
    $all_images = array();
    $main_image = "";

if(isset($_FILES['image'])){
        $total_files = count($_FILES['image']['name']);
        for($i=0; $i < $total_files; $i++){
            $file_name = $_FILES['image']['name'][$i];
            $tmp_name  = $_FILES['image']['tmp_name'][$i];
            
            if(!empty($file_name)){
                // Rename file with SEO slug for better optimization
                $ext = pathinfo($file_name, PATHINFO_EXTENSION);
                $unique_name = $seo_url . "_policy_" . time() . "_" . $i . "." . $ext;
                
                if(move_uploaded_file($tmp_name, "image/" . $unique_name)){
                    $all_images[] = $unique_name;
                    if($i == 0){ $main_image = $unique_name; }
                }
            }
        }
    }
    $gallery_string = implode(',', $all_images);

// 5. Insert Query
    // Removed 'image_url' unless you have a specific input for external image links. 
    // Usually 'image' (filename) is enough.
    $sql = "INSERT INTO policy_tracker (
                region, country, title, short_desc, content, 
                image, gallery_images, link_url, link_text, 
                seo_url, meta_title, meta_description, 
                primary_keyword, secondary_keywords, image_alt_text, image_url
            ) VALUES (
                '$region', '$country', '$title', '$short', '$content', 
                '$main_image', '$gallery_string', '$link_url', '$link_text', 
                '$seo_url', '$meta_title', '$meta_desc', 
                '$prim_key', '$sec_keys', '$alt_text', '$image_url'
            )";
    
    if($conn->query($sql)){
        echo "<script>alert('Policy News Added Successfully!'); window.location='?page=add_policy';</script>";
    } else {
        echo "<script>alert('Database Error: " . $conn->error . "');</script>";
    }
}

// ---15. DELETE POLICY LOGIC ---
if(isset($_GET['delete_policy_id'])){
    $p_id = intval($_GET['delete_policy_id']);
    
    // 1. Delete Images from folder
    $q = $conn->query("SELECT image, gallery_images FROM policy_tracker WHERE id=$p_id");
    if($row = $q->fetch_assoc()){
        if(!empty($row['image']) && file_exists("image/".$row['image'])) { unlink("image/".$row['image']); }
        
        if(!empty($row['gallery_images'])){
            $g_imgs = explode(',', $row['gallery_images']);
            foreach($g_imgs as $g){
                if(!empty($g) && file_exists("image/".trim($g))) { unlink("image/".trim($g)); }
            }
        }
    }

// 2. Delete DB Row
    $conn->query("DELETE FROM policy_tracker WHERE id=$p_id");
    echo "<script>alert('Policy Deleted Successfully'); window.location='?page=view_policy';</script>";
}

// ---16. UPDATE POLICY LOGIC ---
if(isset($_POST['update_policy'])){
    $id = intval($_POST['edit_id']);
    $title = $conn->real_escape_string($_POST['title']);
    $region = $_POST['region'];
    $country = $conn->real_escape_string($_POST['country']);
    $short = $conn->real_escape_string($_POST['short_desc']);
    $content = $conn->real_escape_string($_POST['content']);
    $link_url = $conn->real_escape_string($_POST['link_url']);
    $link_text = $conn->real_escape_string($_POST['link_text']);

// Image Update Logic
    $image_sql_part = ""; 
    
    if(isset($_FILES['image']) && !empty($_FILES['image']['name'][0])){
        // Upload New Images (Same logic as Add)
        $all_images = array();
        $main_image = ""; 
        $total = count($_FILES['image']['name']);
        
        for($i=0; $i<$total; $i++){
            $fn = $_FILES['image']['name'][$i];
            $tn = $_FILES['image']['tmp_name'][$i];
            if(!empty($fn)){
                $new_name = time()."_p_".$fn;
                if(move_uploaded_file($tn, "image/".$new_name)){
                    $all_images[] = $new_name;
                    if($i==0) $main_image = $new_name;
                }
            }
        }
        $gallery_str = implode(',', $all_images);
        $image_sql_part = ", image='$main_image', gallery_images='$gallery_str'";
    }

$sql = "UPDATE policy_tracker SET 
            region='$region', country='$country', title='$title', short_desc='$short', 
            content='$content' $image_sql_part, link_url='$link_url', link_text='$link_url'
            WHERE id=$id";

if($conn->query($sql)){
        echo "<script>alert('Policy Updated Successfully'); window.location='?page=view_policy';</script>";
    } else {
        echo "<script>alert('Error: ".$conn->error."');</script>";
    }
}

<!DOCTYPE html>
<html lang="en">
<head>
    <title>Dashboard - Global Auto Insight</title>
    <link rel="canonical" href="https://globalautoinsight.com/">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link href="css/style.css" rel="stylesheet">
    <style>
        body { background-color: #f4f6f9; display: flex; }
        .sidebar {
            min-width: 250px; max-width: 250px; background: #343a40; color: #fff; min-height: 100vh; position: fixed;
        }
        .sidebar a {
            color: #ccc; text-decoration: none; display: block; padding: 15px 20px;
        }
        .sidebar a:hover, .sidebar a.active { background: #007bff; color: white; }
        .main-content { margin-left: 250px; padding: 20px; width: 100%; }
        .card { border: none; box-shadow: 0 0 15px rgba(0,0,0,0.05); }

/* Upload Zone Styling */
        .upload-zone {
            border: 2px dashed #ccc;
            background-color: #f8f9fa;
            padding: 30px;
            border-radius: 10px;
            cursor: pointer;
            transition: all 0.3s ease;
            position: relative;
        }
        .upload-zone:hover, .upload-zone.dragover {
            background-color: #e9ecef;
            border-color: #007bff;
        }
        .preview-wrapper {
            position: relative; display: inline-block; width: 100px; height: 100px; margin: 5px;
        }
        .preview-thumb {
            width: 100%; height: 100%; object-fit: cover; border-radius: 8px; border: 1px solid #ddd; box-shadow: 0 2px 5px rgba(0,0,0,0.1);
        }
        .remove-btn {
            position: absolute; top: -8px; right: -8px; background-color: #dc3545; color: white;
            border: 2px solid white; border-radius: 50%; width: 24px; height: 24px;
            display: flex; align-items: center; justify-content: center; cursor: pointer;
            font-size: 12px; font-weight: bold; box-shadow: 0 2px 4px rgba(0,0,0,0.2); z-index: 10;
        }
        .remove-btn:hover { background-color: #c82333; transform: scale(1.1); }
    </style>
    <style>
        .preview-wrapper {
            position: relative;
            display: inline-block;
        }
        .preview-wrapper:hover { transform: scale(1.05); }
        .remove-img-btn {
            position: absolute;
            top: -8px;
            right: -8px;
            background: #ff4d4d;
            color: white;
            border-radius: 50%;
            width: 20px;
            height: 20px;
            font-size: 12px;
            line-height: 18px;
            text-align: center;
            cursor: pointer;
            border: 2px solid white;
            box-shadow: 0 2px 4px rgba(0,0,0,0.2);
            z-index: 10;
        }
        .remove-img-btn:hover {
            background: #cc0000;
        }
</style>

.add-preview-wrapper {
        position: relative;
        display: flex;
        flex-direction: column;
        align-items: center;
        width: 120px;
    }

.add-preview-wrapper img {
        width: 110px;
        height: 80px;
        object-fit: cover;
        border: 2px solid #1a237e;
        border-radius: 8px;
        background: white;
    }

/* Red "X" Remove Button */
    .add-remove-btn {
        position: absolute;
        top: -10px;
        right: -5px;
        background: #ff5e5e;
        color: white;
        border-radius: 50%;
        width: 22px;
        height: 22px;
        font-size: 12px;
        display: flex;
        align-items: center;
        justify-content: center;
        cursor: pointer;
        border: 2px solid white;
        box-shadow: 0 2px 4px rgba(0,0,0,0.2);
        z-index: 10;
    }

/* Dark Cover Pill Below Image */
    .cover-pill {
        background: #4a4a4a;
        color: white;
        font-size: 10px;
        font-weight: bold;
        padding: 2px 15px;
        border-radius: 20px;
        margin-top: 8px;
        text-transform: uppercase;
    }
</style>

</head>
<body>

<div class="sidebar">
    <div class="text-center mb-4 pt-3">
        <h4 class="fw-bold">AUTO ADMIN</h4>
        <small>Welcome, <?php echo $_SESSION['admin']; ?></small>
    </div>
    <a href="?page=add_news" class="<?php echo $page=='add_news'?'active':''; ?>"><i class="fas fa-plus-circle me-2"></i> Add News</a>
    <a href="?page=view_news" class="<?php echo $page=='view_news'?'active':''; ?>"><i class="fas fa-newspaper me-2"></i> All News</a>
    <a href="?page=add_market" class="<?php echo $page=='add_market'?'active':''; ?>"><i class="fas fa-chart-line me-2"></i> Market Insights</a>
    <a href="?page=view_market" class="<?php echo $page=='view_market'?'active':''; ?>"><i class="fas fa-list-alt me-2"></i> All Market Insight</a>
    
    <a href="?page=add_policy" class="<?php echo $page=='add_policy'?'active':''; ?>"><i class="fas fa-gavel me-2"></i> Policy Tracker</a>
    <a href="?page=view_policy" class="<?php echo $page=='view_policy'?'active':''; ?>"><i class="fas fa-list-alt me-2"></i> View Policies</a>
    <a href="?page=feedbacks" class="<?php echo $page=='feedbacks'?'active':''; ?>"><i class="fas fa-comments me-2"></i> User Feedback</a>
    <a href="?page=contacts" class="<?php echo $page=='contacts'?'active':''; ?>"><i class="fas fa-envelope me-2"></i> Inquiries</a>
    <a href="?logout=true" class="text-danger mt-5"><i class="fas fa-sign-out-alt me-2"></i> Logout</a>
</div>

<div class="main-content">
    
    
    <div class="d-flex justify-content-between align-items-center mb-4 pb-2 border-bottom">
        <h2><?php echo str_replace('_', ' ', strtoupper($page)); ?></h2>
        <a href="index.php" target="_blank" class="btn btn-outline-dark btn-sm">View Website</a>
    </div>

<?php if($page == 'add_news'): ?>
    <div class="card shadow-sm border-0">
        <div class="card-body">
            <form method="POST" enctype="multipart/form-data">
                <div class="row">
                    <div class="col-md-8 mb-3">
                        <label class="fw-bold">News Title</label>
                        <input type="text" name="title" class="form-control" placeholder="Enter headline..." required>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label class="fw-bold">Category</label>
                        <select name="category" class="form-select">  
                            <option>Electrification</option>
                            <option>Hybrid Technology (HEV/PHEV)</option>
                            <option>Hydrogen & Fuel Cell Technology</option>
                            <option>CNG & Alternative Fuels (Biofuel, Flex-Fuel, e-Fuels)</option>
                            <option>Powertrain & Propulsion Systems</option>
                            <option>Charging & Energy Infrastructure</option>
                            <option>Autonomous Driving & ADAS</option>
                            <option>Automotive Artificial Intelligence (AI)</option>
                            <option>Connected Vehicles & Telematics</option>
                            <option>Software-Defined Vehicles (SDV)</option>
                            <option>In-Vehicle Experience (HMI/IVI/UX)</option>
                            <option>Vehicle Safety</option>
                            <option>Validation & Testing</option>
                            <option>Components & Subsystems</option>
                            <option>Advanced Materials</option>
                            <option>Manufacturing & Production</option>
                            <option>Supply Chain</option>
                            <option>Robotics Technology</option>
                            <option>Government Regulations</option>
                            <option>Market Statistics & Industry Data</option>
                            <option>Company Financials & Earnings</option>
                            <option>Mergers & Acquisitions (M&A)</option>
                            <option>Leadership Transition</option>
                            <option>Joint Ventures (JV)</option>
                            <option>Strategic Alliances & Partnerships</option>
                            <option>Investments & Funding</option>
                            <option>Restructuring & Divestitures</option>
                            <option>New Product Launches</option>
                            <option>Shared Mobility & Mobility-as-a-Service (MaaS)</option>
                            <option>Micro-Mobility</option>
                            <option>Semiconductors & Automotive Electronics</option>
                            <option>Cybersecurity</option>
                            <option>Orders & Contracts/Deals</option>
                            <option>Digital Cockpit & Infotainment</option>
                            <option>Vehicle Architecture & Platforms</option>
                            <option>Recalls & Quality Issues</option>
                            <option>Aftermarket & Service</option>
                            <option>Smart Cities & Infrastructure</option>
                            <option>Policy Incentives & Subsidies</option>
                        </select>
                    </div>
                </div>
                
                
                <div class="card bg-light mb-4">
                    <div class="card-header fw-bold">SEO Optimization Settings</div>
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Meta Title</label>
                                <input type="text" name="meta_title" class="form-control" placeholder="BYD New EV Battery Platform Launch | BYD News">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Suggested SEO URL (Slug)</label>
                                <input type="text" name="seo_url" class="form-control" placeholder="e.g. honda-ev-strategy">
                            </div>
                            <div class="col-12 mb-3">
                                <label class="small fw-bold">Meta Description</label>
                                <textarea name="meta_description" class="form-control" rows="2" placeholder="e.g. BYD unveils a new EV battery platform improving range, safety and charging speed."></textarea>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Primary Keyword</label>
                                <input type="text" name="primary_keyword" class="form-control" placeholder="BYD EV battery platform">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Secondary Keywords</label>
                                <input type="text" name="secondary_keywords" class="form-control" placeholder="Comma separated-BYD battery, EV battery tech, BYD EV news, lithium battery">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Image Alt Text</label>
                                <input type="text" name="image_alt_text" class="form-control" placeholder="BYD new EV battery platform showcased at launch">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Image URL</label>
                                <input type="text" name="image_url" class="form-control" placeholder="e.g. image/byd.jpg">
                            </div>
                        </div>
                    </div>
                </div>
                
                <div class="mb-3">
                    <label class="fw-bold">Short Description</label>
                    <textarea name="short_desc" class="form-control" rows="2" required></textarea>
                </div>
                <div class="mb-3">
                    <label class="fw-bold">Useful Tags/Keywords</label>
                    
                    <textarea name="keywords" class="form-control" rows="1" placeholder="e.g. EV, Tesla Inc., Honda Motor.Ltd.Co" required></textarea>
                    <small class="text-muted">Separate keywords with a <strong>comma (,)</strong>. Dots in names (e.g. Ltd. Co.) will stay as one tag.</small>
                </div>
                <div class="mb-3">
                    <label class="fw-bold">Full Article Content</label>
                    <textarea name="content" class="form-control" rows="8" required></textarea>
                </div>
                
                
                <div class="mb-3 p-3 bg-light border rounded">
                    <label class="fw-bold mb-3 text-uppercase small text-muted">
                        <i class="fas fa-link me-1"></i> External Reference (Optional)
                    </label>
                    <div class="row">
                        <div class="col-md-6 mb-2">
                            <label class="form-label small fw-bold">Display Name</label>
                            <input type="text" name="link_text" class="form-control" placeholder="e.g. Google Page">
                        </div>
                        <div class="col-md-6 mb-2">
                            <label class="form-label small fw-bold">Target URL</label>
                            <input type="url" name="link_url" class="form-control" placeholder="https://www.google.com">
                        </div>
                    </div>
                </div>

<div class="mb-3">
                    <label class="fw-bold mb-2">Gallery Photos</label>
                    <div id="upload-zone" class="upload-zone">
                        <div class="text-center">
                            <i class="fas fa-cloud-upload-alt fa-3x text-secondary mb-3"></i>
                            <p class="fw-bold mb-1">Click to Browse, Drag & Drop, or <span class="text-primary">Ctrl+V to Paste</span></p>
                            <small class="text-muted">Supports JPG, PNG, WEBP. First image is Cover.</small>
                        </div>
                        <div id="image-preview-container" class="d-flex flex-wrap justify-content-center mt-3 gap-2"></div>
                    </div>
                    <input type="file" name="image[]" id="hidden-file-input" multiple style="display: none;">
                </div>

<button type="submit" name="add_news" class="btn btn-success px-4 w-100 fw-bold"><i class="fas fa-paper-plane"></i> Publish News</button>
            </form>
        </div>
    
    
    
    <h1 align="center">OR</h1>
            
        <div class="alert alert-info border-0">
            <strong><i class="fas fa-info-circle"></i> Instructions:</strong>
                <ol class="small mt-2 mb-0">
                    <li>Create your news list in Excel.</li>
                    <li><strong>Important:</strong> Save the file as <code>CSV (Comma delimited)</code>.</li>
                    <li>Upload your images separately to the <code>Images/</code> folder via File Manager.</li>
                    <li>In the CSV "Image" column, put the exact filename (e.g., <code>bmw-news.jpg</code>).</li>
                    <li>Leave the "SEO URL" column blank if you want it auto-generated.</li>
                </ol>
        </div>
        
        <form method="post" enctype="multipart/form-data">
            <div class="mb-4">
                <label class="form-label fw-bold">Select CSV File</label>
                    <input type="file" name="csv_file" class="form-control" accept=".csv" required>
            </div>
            <div class="d-grid">
                <button type="submit" name="debug_import" class="btn btn-success fw-bold py-2">
                    <i class="fas fa-upload me-2"></i> Import News Data
                </button>
            </div>
        </form>
    </div>
    <?php endif; ?>
    
    
    
    <?php if($page == 'view_news'): ?>
    <div class="card shadow-sm border-0">
        
        <form method="POST" onsubmit="return confirm('Are you sure you want to delete ALL selected news? This cannot be undone.');">
            
            <div class="card-header bg-dark text-white d-flex justify-content-between align-items-center">
                <h5 class="mb-0">All News Articles</h5>
                
                
                <button type="submit" name="bulk_delete_news" class="btn btn-danger btn-sm fw-bold">
                    <i class="fas fa-trash-alt me-1"></i> Delete Selected
                </button>
            </div>
    
            <div class="card-body p-0">
                <table class="table table-hover table-striped mb-0 align-middle">
                    <thead class="table-secondary">
                        <tr>
                            
                            <th class="text-center" style="width: 40px;">
                                <input type="checkbox" id="selectAll" class="form-check-input" style="cursor:pointer;">
                            </th>
                            <th>ID</th>
                            <th>Image</th>
                            <th>Title</th>
                            <th>Category</th>
                            <th>Date</th>
                            <th class="text-center">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $res = $conn->query("SELECT * FROM news ORDER BY id DESC");
                        while($row = $res->fetch_assoc()){
                        ?>
                        <tr>
                            
                            <td class="text-center">
                                <input type="checkbox" name="news_ids[]" value="<?php echo $row['id']; ?>" class="form-check-input news-checkbox" style="cursor:pointer;">
                            </td>
                            <td><?php echo $row['id']; ?></td>
                            
                            <td><img src="image/<?php echo $row['image']; ?>" width="50" height="35" style="object-fit:cover; border-radius:4px;"></td>
                            <td><?php echo substr($row['title'], 0, 30); ?>...</td>
                            <td><span class="badge bg-secondary"><?php echo $row['category']; ?></span></td>
                            <td><small><?php echo date("M d, Y", strtotime($row['created_at'])); ?></small></td>
                            <td class="text-center">
                                
                                <button type="button" class="btn btn-primary btn-sm me-2"
                                    data-bs-toggle="modal" 
                                    data-bs-target="#editNewsModal"
                                    data-id="<?php echo $row['id']; ?>"
                                    data-title="<?php echo htmlspecialchars($row['title']); ?>"
                                    data-cat="<?php echo $row['category']; ?>"
                                    data-short="<?php echo htmlspecialchars($row['short_desc']); ?>"
                                    data-keywords="<?php echo htmlspecialchars($row['keywords']); ?>"
                                    data-content="<?php echo htmlspecialchars($row['content']); ?>"
                                    data-linkurl="<?php echo htmlspecialchars($row['link_url'] ?? ''); ?>"
                                    data-linktext="<?php echo htmlspecialchars($row['link_text'] ?? ''); ?>">
                                    <i class="fas fa-edit"></i> Edit
                                </button>
                                
                                <a href="admin_dashboard.php?delete_id=<?php echo $row['id']; ?>" 
                                class="btn btn-danger btn-sm" 
                                onclick="return confirm('Delete this news?');">
                                <i class="fas fa-trash"></i>
                                </a>
                            </td>
                        </tr>
                        <?php } ?>
                    </tbody>
                </table>
            </div>
        </form> 
    </div>
    <?php endif; ?>
    
    
    
    <div class="modal fade" id="editNewsModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header bg-primary text-white">
                    <h5 class="modal-title">Edit News Details</h5>
                    <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form method="POST" enctype="multipart/form-data">
                    <div class="modal-body">
                        <input type="hidden" name="edit_id" id="modal_id">
                        <div class="row">
                            <div class="col-md-8 mb-3">
                                <label class="fw-bold">News Title</label>
                                <input type="text" name="title" id="modal_title" class="form-control" required>
                            </div>
                            <div class="col-md-4 mb-3">
                                <label class="fw-bold">Category</label>
                                <select name="category" id="modal_cat" class="form-select">   
                                    <option>Electrification</option>
                                    <option>Hybrid Technology (HEV/PHEV)</option>
                                    <option>Hydrogen & Fuel Cell Technology</option>
                                    <option>CNG & Alternative Fuels (Biofuel, Flex-Fuel, e-Fuels)</option>
                                    <option>Powertrain & Propulsion Systems</option>
                                    <option>Charging & Energy Infrastructure</option>
                                    <option>Autonomous Driving & ADAS</option>
                                    <option>Automotive Artificial Intelligence (AI)</option>
                                    <option>Connected Vehicles & Telematics</option>
                                    <option>Software-Defined Vehicles (SDV)</option>
                                    <option>In-Vehicle Experience (HMI/IVI/UX)</option>
                                    <option>Vehicle Safety</option>
                                    <option>Validation & Testing</option>
                                    <option>Components & Subsystems</option>
                                    <option>Advanced Materials</option>
                                    <option>Manufacturing & Production</option>
                                    <option>Supply Chain</option>
                                    <option>Robotics Technology</option>
                                    <option>Government Regulations</option>
                                    <option>Market Statistics & Industry Data</option>
                                    <option>Company Financials & Earnings</option>
                                    <option>Mergers & Acquisitions (M&A)</option>
                                    <option>Leadership Transition</option>
                                    <option>Joint Ventures (JV)</option>
                                    <option>Strategic Alliances & Partnerships</option>
                                    <option>Investments & Funding</option>
                                    <option>Restructuring & Divestitures</option>
                                    <option>New Product Launches</option>
                                    <option>Shared Mobility & Mobility-as-a-Service (MaaS)</option>
                                    <option>Micro-Mobility</option>
                                    <option>Semiconductors & Automotive Electronics</option>
                                    <option>Cybersecurity</option>
                                    <option>Orders & Contracts/Deals</option>
                                    <option>Digital Cockpit & Infotainment</option>
                                    <option>Vehicle Architecture & Platforms</option>
                                    <option>Recalls & Quality Issues</option>
                                    <option>Aftermarket & Service</option>
                                    <option>Smart Cities & Infrastructure</option>
                                    <option>Policy Incentives & Subsidies</option>
                                </select>
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="fw-bold">Short Description</label>
                            <textarea name="short_desc" id="modal_short" class="form-control" rows="2" required></textarea>
                        </div>
                        <div class="mb-3">
                            <label class="fw-bold">Keywords</label>
                            <textarea name="keywords" id="modal_keywords" class="form-control" rows="1" required></textarea>
                        </div>
                        <div class="mb-3">
                            <label class="fw-bold">Full Content</label>
                            <textarea name="content" id="modal_content" class="form-control" rows="6" required></textarea>
                        </div>
                        
                        
                        <div class="row bg-light p-2 border rounded mb-3">
                            <div class="col-md-6">
                                <label class="small fw-bold">Link Text</label>
                                <input type="text" name="link_text" id="modal_linktext" class="form-control">
                            </div>
                            <div class="col-md-6">
                                <label class="small fw-bold">Link URL</label>
                                <input type="url" name="link_url" id="modal_linkurl" class="form-control">
                            </div>
                        </div>
    
                        
                        <div class="mb-3 p-3 bg-light border rounded">
                            <div id="upload-zone" class="upload-zone">
                                <div class="text-center">
                                    <i class="fas fa-cloud-upload-alt fa-3x text-secondary mb-3"></i>
                                    <p class="fw-bold mb-1">Click to Browse, Drag & Drop, or <span class="text-primary">Ctrl+V to Paste</span></p>
                                    <small class="text-muted">Supports JPG, PNG, WEBP. First image is Cover.</small>
                                </div>
                                <div id="image-preview-container" class="d-flex flex-wrap justify-content-center mt-3 gap-2"></div>
                            </div>
                            <input type="file" name="image[]" id="hidden-file-input" multiple style="display: none;">
                        </div>
                        
                        
                    </div>
    
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                        <button type="submit" name="update_news" class="btn btn-primary">Save Changes</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
    
    
    
    <?php if($page == 'add_market'): ?>
        <div class="container-fluid py-6">
            <div class="row justify-content-center">
                <div class="col-lg-12">
                    
                    <div class="card shadow border-0 mb-4">
                        
                        <div class="card-header text-white d-flex align-items-center justify-content-between py-3" 
                             style="background: linear-gradient(45deg, #1a237e, #283593);">
                            <h5 class="mb-0"><i class="fas fa-chart-bar me-2"></i> Publish New Market Insight</h5>
                            <span class="badge bg-light text-dark shadow-sm">Global Auto Insight Portal</span>
                        </div>
        
                        <div class="card-body p-4">
                            <form method="POST" enctype="multipart/form-data">
                                
                                
                                <div class="row g-3 mb-4 p-2 bg-light rounded-3 border">
                                    
                                    
                                    
                                    
                                    <div class="col-md-3">
                                        <label class="fw-bold small mb-1">Main Category</label>
                                        <select name="main_tab" class="form-select border-primary-subtle" required>
                                            <option value="" selected disabled>Select Type</option>
                                            <option>Vehicle Sales</option>
                                            <option>EV Sales</option>
                                            <option>Vehicle Production</option>
                                        </select>
                                    </div>
                            
                                    
                                    <div class="col-md-3">
                                        <label class="fw-bold small mb-1">Region</label>
                                        <select name="region" id="regionSelect" class="form-select border-primary-subtle" required onchange="updateCountries()">
                                            <option value="" selected disabled>Select Region</option>
                                            <option value="Americas">Americas</option>
                                            <option value="Europe">Europe</option>
                                            <option value="Asia Pacific">Asia Pacific</option>
                                            <option value="MEA">MEA (Middle East & Africa)</option>
                                        </select>
                                    </div>
                            
                                    
                                    <div class="col-md-3">
                                        <label class="fw-bold small mb-1">Country</label>
                                        <select name="country" id="countrySelect" class="form-select border-primary-subtle" required>
                                            <option value="">Select Region First</option>
                                        </select>
                                    </div>
                            
                                    
                                    <div class="col-md-3">
                                        <label class="fw-bold small mb-1">Sub Category</label>
                                        <select name="sub_category" class="form-select border-primary-subtle" required>
                                            <option>Passenger Cars</option>
                                            <option>Two Wheelers</option>
                                            <option>Commercial Vehicles</option>
                                        </select>
                                    </div>
                                </div>
        
                                
                                <div class="mb-3">
                                    <label class="fw-bold">News Title</label>
                                    <input type="text" name="mi_title" class="form-control" placeholder="Enter headline..." required>
                                </div>
                                
                                
                                <div class="card bg-light mb-4">
                                    <div class="card-header fw-bold">SEO Optimization Settings</div>
                                    <div class="card-body">
                                        <div class="row">
                                            <div class="col-md-6 mb-3">
                                                <label class="small fw-bold">Meta Title</label>
                                                <input type="text" name="mi_meta_title" class="form-control" placeholder="BYD New EV Battery Platform Launch | BYD News">
                                            </div>
                                            <div class="col-md-6 mb-3">
                                                <label class="small fw-bold">Suggested SEO URL (Slug)</label>
                                                <input type="text" name="mi_seo_url" class="form-control" placeholder="e.g. honda-ev-strategy">
                                            </div>
                                            <div class="col-12 mb-3">
                                                <label class="small fw-bold">Meta Description</label>
                                                <textarea name="mi_meta_description" class="form-control" rows="2" placeholder="e.g. BYD unveils a new EV battery platform improving range, safety and charging speed."></textarea>
                                            </div>
                                            <div class="col-md-6 mb-3">
                                                <label class="small fw-bold">Primary Keyword</label>
                                                <input type="text" name="mi_primary_keywords" class="form-control" placeholder="BYD EV battery platform">
                                            </div>
                                            <div class="col-md-6 mb-3">
                                                <label class="small fw-bold">Secondary Keywords</label>
                                                <input type="text" name="mi_secondary_keywords" class="form-control" placeholder="Comma separated-BYD battery, EV battery tech, BYD EV news, lithium battery">
                                            </div>
                                            <div class="col-md-6 mb-3">
                                                <label class="small fw-bold">Image Alt Text</label>
                                                <input type="text" name="mi_image_alt_text" class="form-control" placeholder="BYD new EV battery platform showcased at launch">
                                            </div>
                                            <div class="col-md-6 mb-3">
                                                <label class="small fw-bold">Image URL</label>
                                                <input type="text" name="mi_image_url" class="form-control" placeholder="e.g. image/byd.jpg">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="fw-bold">Full Article Content</label>
                                    <textarea name="mi_content" class="form-control" rows="8" required></textarea>
                                </div>
                                
                                
                                <div class="mb-3 p-3 bg-light border rounded">
                                    <label class="fw-bold mb-3 text-uppercase small text-muted">
                                        <i class="fas fa-link me-1"></i> External Reference (Optional)
                                    </label>
                                    <div class="row">
                                        <div class="col-md-6 mb-2">
                                            <label class="form-label small fw-bold">Display Name</label>
                                            <input type="text" name="mi_link_text" class="form-control" placeholder="e.g. Google Page">
                                        </div>
                                        <div class="col-md-6 mb-2">
                                            <label class="form-label small fw-bold">Target URL</label>
                                            <input type="url" name="mi_link_url" class="form-control" placeholder="https://www.google.com">
                                        </div>
                                    </div>
                                </div>
                
                                
                                <div class="mb-3 p-3 bg-light border rounded">
                                    <label class="fw-bold mb-2">Insight Charts & Gallery</label>
                                    
                                    <div id="mi-upload-zone" class="upload-zone py-4" style="cursor:pointer; border: 2px dashed #198754; background: #f8fff9; border-radius: 12px; position: relative;">
                                        <div class="text-center" id="mi-instructions">
                                            <img src="https://cdn-icons-png.flaticon.com/512/3097/3097412.png" width="50" class="mb-2 opacity-50">
                                            <p class="fw-bold mb-1">Click to Browse, Drag & Drop, or <span class="text-primary">Ctrl+V to Paste</span></p>
                                            <small class="text-muted">Supports JPG, PNG, WEBP. First image is Cover.</small>
                                        </div>
                                
                                        
                                        <div id="mi-preview-container" class="d-flex flex-wrap justify-content-center mt-3 gap-3"></div>
                                    </div>
                                
                                    
                                    <input type="file" name="mi_image[]" id="mi-file-input" multiple style="display: none;">
                                </div>
                
                                <button type="submit" name="add_insight" class="btn btn-success px-4 w-100 fw-bold"><i class="fas fa-paper-plane"></i> PUBLISH TO MARKET INSIGHT</button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    <?php endif; ?>
    
    
    
    <?php if($page == 'view_market'): ?>
    <div class="card shadow-sm border-0">
        
        <form method="POST" onsubmit="return confirm('Are you sure you want to delete ALL selected news? This cannot be undone.');">
            
            <div class="card-header bg-dark text-white d-flex justify-content-between align-items-center">
                <h5 class="mb-0">All Market Insight News Articles</h5>
                
                
                <button type="submit" name="bulk_delete_market" class="btn btn-danger btn-sm fw-bold" onclick="return confirm('Delete all selected items?');">
                    <i class="fas fa-trash-alt me-1"></i> Delete Selected
                </button>
            </div>
    
            <div class="card-body p-0">
                <table class="table table-hover table-striped mb-0 align-middle">
                    <thead class="table-secondary">
                        <tr>
                            
                            <th class="text-center" style="width: 40px;">
                                <input type="checkbox" id="mi-select-all" class="form-check-input" style="cursor:pointer;">
                            </th>
                            <th>ID</th>
                            <th>Image</th>
                            <th>Title</th>
                            <th>Main Category</th>
                            <th>Region</th>
                            <th>Country</th>
                            <th>Sub Category</th>
                            <th>Date</th>
                            <th class="text-center">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                            $res = $conn->query("SELECT * FROM market_insights ORDER BY id DESC");
                            if($res->num_rows > 0){
                                while($row = $res->fetch_assoc()){
                        ?>
                        <tr>
                            
                            <td class="text-center">
                                <input type="checkbox" name="market_ids[]" value="<?php echo $row['id']; ?>" class="form-check-input mi-item-checkbox" style="cursor:pointer; border: 1px solid #666;">
                            </td>
                            <td class="text-muted small"><b><?php echo $row['id']; ?></b></td>
                            
                            <td><img src="image/<?php echo $row['mi_image']; ?>" width="50" height="35" style="object-fit:cover; border-radius:4px;"></td>
                            <td><?php echo substr($row['mi_title'], 0, 20); ?>...</td>
                            <td><span class="badge bg-secondary"><?php echo $row['main_tab']; ?></span></td>
                            <td><span class="badge bg-secondary"><?php echo $row['region']; ?></span></td>
                            <td><span class="badge bg-secondary"><?php echo $row['country']; ?></span></td>
                            <td><span class="badge bg-secondary"><?php echo $row['sub_category']; ?></span></td>
                            <td><small><?php echo date("M d, Y", strtotime($row['created_at'])); ?></small></td>
                            
                            <td class="text-center">
                                
                                <button type="button" class="btn btn-primary btn-sm" 
                                    data-bs-toggle="modal" 
                                    data-bs-target="#editInsightModal" 
                                    data-id="<?php echo $row['id']; ?>"
                                    data-main="<?php echo htmlspecialchars($row['main_tab']); ?>"
                                    data-region="<?php echo htmlspecialchars($row['region']); ?>"
                                    data-country="<?php echo htmlspecialchars($row['country']); ?>"
                                    data-subcat="<?php echo htmlspecialchars($row['sub_category']); ?>"
                                    data-title="<?php echo htmlspecialchars($row['mi_title']); ?>"
                                    data-content="<?php echo htmlspecialchars($row['mi_content']); ?>"
                                    data-linktext="<?php echo htmlspecialchars($row['mi_link_text'] ?? ''); ?>"
                                    data-linkurl="<?php echo htmlspecialchars($row['mi_link_url'] ?? ''); ?>"
                                    data-seo="<?php echo htmlspecialchars($row['mi_seo_url']); ?>"
                                    data-meta_title="<?php echo htmlspecialchars($row['mi_meta_title'] ?? ''); ?>"
                                    data-meta_desc="<?php echo htmlspecialchars($row['mi_meta_description'] ?? ''); ?>"
                                    data-prim_key="<?php echo htmlspecialchars($row['mi_primary_keywords'] ?? ''); ?>"
                                    data-sec_keys="<?php echo htmlspecialchars($row['mi_secondary_keywords'] ?? ''); ?>"
                                    data-alt="<?php echo htmlspecialchars($row['mi_image_alt_text'] ?? ''); ?>">
                                    <i class="fas fa-edit"></i> Edit
                                </button>
                                
                                
                                
                                <a href="admin_dashboard.php?page=view_market&delete_market_id=<?php echo $row['id']; ?>" 
                                   class="btn btn-danger btn-sm rounded-pill px-3" 
                                   onclick="return confirm('Are you sure you want to delete this specific insight?');">
                                    <i class="fas fa-trash-alt"></i>
                                </a>
                            </td>
                        </tr>
                        <?php 
                                }
                            } else {
                                echo "<tr><td colspan='5' class='text-center p-4'>No insights found.</td></tr>";
                            }
                        ?>
                    </tbody>
                </table>
            </div>
        </form> 
    </div>
    
    
        <script>
            document.getElementById('mi-master-checkbox').addEventListener('change', function() {
                let checkboxes = document.querySelectorAll('.mi-item-checkbox');
                checkboxes.forEach(cb => {
                    cb.checked = this.checked;
                });
            });
        </script>

<?php endif; ?>
    
    
    
    <div class="modal fade" id="editInsightModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-xl">
            <div class="modal-content">
                <form method="POST" enctype="multipart/form-data">
                    <div class="modal-header bg-dark text-white">
                        <h5 class="modal-title">Edit Market Insight</h5>
                        <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body bg-light">
                        <input type="hidden" name="mi_id" id="edit_mi_id">
                        
                        
                        <div class="row g-3 mb-3">
                            <div class="col-md-3">
                                <label class="fw-bold small">Main Tab</label>
                                <select name="main_tab" id="edit_main_tab" class="form-select">
                                    <option>Vehicle Sales</option><option>EV Sales</option><option>Vehicle Production</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label class="fw-bold small">Region</label>
                                <select name="region" id="edit_region" class="form-select">
                                    <option>Americas</option><option>Europe</option><option>Asia Pacific</option><option>MEA</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label class="fw-bold small">Country</label>
                                <input type="text" name="country" id="edit_country" class="form-control">
                            </div>
                            <div class="col-md-3">
                                <label class="fw-bold small">Sub Category</label>
                                <select name="sub_category" id="edit_sub_category" class="form-select">
                                    <option>Passenger Cars</option><option>Two Wheelers</option><option>Commercial Vehicles</option>
                                </select>
                            </div>
                        </div>
    
                        <div class="mb-3">
                            <label class="fw-bold small">Insight Title</label>
                            <input type="text" name="mi_title" id="edit_mi_title" class="form-control" required>
                        </div>
    
                        <div class="mb-3">
                            <label class="fw-bold small">Full Analysis Content</label>
                            <textarea name="mi_content" id="edit_mi_content" class="form-control" rows="6" required></textarea>
                        </div>
    
                        
                        <div class="card border-0 shadow-sm mb-3">
                            <div class="card-header py-2 small fw-bold">SEO Optimization Settings</div>
                            <div class="card-body row g-2">
                                <div class="col-md-6"><label class="small">Meta Title</label><input type="text" name="mi_meta_title" id="edit_mi_meta_title" class="form-control"></div>
                                <div class="col-md-6"><label class="small">SEO URL Slug</label><input type="text" name="mi_seo_url" id="edit_mi_seo_url" class="form-control"></div>
                                <div class="col-12"><label class="small">Meta Description</label><textarea name="mi_meta_description" id="edit_mi_meta_desc" class="form-control" rows="2"></textarea></div>
                                <div class="col-md-6"><label class="small">Primary Keywords</label><input type="text" name="mi_primary_keywords" id="edit_mi_prim_key" class="form-control"></div>
                                <div class="col-md-6"><label class="small">Secondary Keywords</label><input type="text" name="mi_secondary_keywords" id="edit_mi_sec_keys" class="form-control"></div>
                            </div>
                        </div>
    
                        
                        <div class="row g-3">
                            <div class="col-md-6">
                                <label class="fw-bold small">Link Text</label>
                                <input type="text" name="mi_link_text" id="edit_mi_link_text" class="form-control mb-2">
                                <label class="fw-bold small">Link URL</label>
                                <input type="url" name="mi_link_url" id="edit_mi_link_url" class="form-control">
                            </div>
                            <div class="col-md-6">
                                <label class="fw-bold small">Image Alt Text</label>
                                <input type="text" name="mi_image_alt_text" id="edit_mi_alt" class="form-control mb-2">
                                <label class="fw-bold small">Update Visuals (Optional)</label>
                                <input type="file" name="mi_image[]" class="form-control" multiple>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                        <button type="submit" name="update_insight" class="btn btn-success">Update Market Insight</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
    
    
    <?php if($page == 'add_policy'): ?>
    <div class="card shadow-sm">
        
        <div class="card-header bg-warning text-dark fw-bold d-flex justify-content-between align-items-center">
            <span><i class="fas fa-gavel me-2"></i> Add Policy News</span>
            
            <a href="?page=view_policy" class="btn btn-dark btn-sm"><i class="fas fa-list me-1"></i> View All</a>
        </div>
        <div class="card-body">
            <form method="POST" enctype="multipart/form-data">
                <div class="row">
                    
                    <div class="col-md-6 mb-3">
                        <label class="fw-bold">Region</label>
                        <select name="region" id="regionSelect" class="form-select" required>
                            <option value="" selected disabled>Select Region</option>
                            <option value="Americas">Americas</option>
                            <option value="Europe">Europe</option>
                            <option value="Asia Pacific">Asia Pacific</option>
                            <option value="MEA">MEA</option>
                        </select>
                    </div>
                    <div class="col-md-6 mb-3">
                        <label class="fw-bold">Country</label>
                        <select name="country" id="countrySelect" class="form-select" required>
                            <option value="">Select Region First</option>
                        </select>
                    </div>
                </div>
    
                
                <div class="mb-3">
                    <label class="fw-bold">Headline</label>
                    <input type="text" name="title" class="form-control" required>
                </div>
                <div class="mb-3">
                    <label class="fw-bold">Short Description</label>
                    <textarea name="short_desc" class="form-control" rows="2" required></textarea>
                </div>
                <div class="mb-3">
                    <label class="fw-bold">Full Article</label>
                    <textarea name="content" class="form-control" rows="3" required></textarea>
                </div>
                
                
                <div class="mb-3 p-3 bg-light border rounded">
                    <label class="fw-bold mb-3 text-uppercase small text-muted">
                        <i class="fas fa-link me-1"></i> External Reference (Optional)
                    </label>
                    <div class="row">
                        <div class="col-md-6 mb-2">
                            <label class="form-label small fw-bold">Display Name</label>
                            <input type="text" name="link_text" class="form-control" placeholder="e.g. Google Page">
                        </div>
                        <div class="col-md-6 mb-2">
                            <label class="form-label small fw-bold">Target URL</label>
                            <input type="url" name="link_url" class="form-control" placeholder="https://www.google.com">
                        </div>
                    </div>
                </div>
                
                
                <div class="mb-4">
                    <label class="fw-bold mb-2">Gallery Photos</label>
                    <div id="upload-zone" class="upload-zone">
                        <div class="text-center">
                            <i class="fas fa-cloud-upload-alt fa-3x text-secondary mb-3"></i>
                            <p class="fw-bold mb-1">Click to Browse, Drag & Drop, or <span class="text-primary">Ctrl+V to Paste</span></p>
                            <small class="text-muted">Supports JPG, PNG, WEBP. First image is Cover.</small>
                        </div>
                        <div id="image-preview-container" class="d-flex flex-wrap justify-content-center mt-3 gap-2"></div>
                    </div>
                    <input type="file" name="image[]" class="form-control" id="hidden-file-input" multiple style="display: none;" required>
                </div>
                
                
                <div class="card bg-light mb-4">
                    <div class="card-header bg-warning text-dark fw-bold d-flex justify-content-between align-items-center">SEO Optimization Settings</div>
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Meta Title</label>
                                <input type="text" name="meta_title" class="form-control" placeholder="BYD New EV Battery Platform Launch | BYD News">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Suggested SEO URL (Slug)</label>
                                <input type="text" name="seo_url" class="form-control" placeholder="e.g. honda-ev-strategy">
                            </div>
                            <div class="col-12 mb-3">
                                <label class="small fw-bold">Meta Description</label>
                                <textarea name="meta_description" class="form-control" rows="2" maxlength="160" placeholder="e.g. BYD unveils a new EV battery platform improving range, safety and charging speed."></textarea>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Primary Keyword</label>
                                <input type="text" name="primary_keyword" class="form-control" placeholder="BYD EV battery platform">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Secondary Keywords</label>
                                <input type="text" name="secondary_keywords" class="form-control" placeholder="Comma separated-BYD battery, EV battery tech, BYD EV news, lithium battery">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Image Alt Text</label>
                                <input type="text" name="image_alt_text" class="form-control" placeholder="BYD new EV battery platform showcased at launch">
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="small fw-bold">Image URL</label>
                                <input type="text" name="image_url" class="form-control" placeholder="e.g. image/byd.jpg">
                            </div>
                        </div>
                    </div>
                </div>
                
                <button type="submit" name="add_policy" class="btn btn-warning w-100 fw-bold">Publish Policy News</button>
            </form>
        </div>
    </div>
    
    <?php endif; ?>
    
    
    <?php if($page == 'view_policy'): ?>
    <div class="card shadow-sm border-0">
        <div class="card-header bg-dark text-white d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Policy Tracker List</h5>
            <a href="?page=add_policy" class="btn btn-warning btn-sm text-dark fw-bold"><i class="fas fa-plus"></i> Add New</a>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover table-striped mb-0 align-middle">
                    <thead class="table-secondary">
                        <tr>
                            <th>ID</th>
                            <th>Image</th>
                            <th>Region</th>
                            <th>Country</th>
                            <th>Title</th>
                            <th>Date</th>
                            <th class="text-center">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $res = $conn->query("SELECT * FROM policy_tracker ORDER BY id DESC");
                        if($res->num_rows > 0){
                            while($row = $res->fetch_assoc()){
                                // Image check
                                $img_src = (!empty($row['image']) && file_exists("image/".$row['image'])) 
                                    ? "image/".$row['image'] : "https://via.placeholder.com/50?text=No+Img";
                        ?>
                        <tr>
                            <td><?php echo $row['id']; ?></td>
                            <td><img src="<?php echo $img_src; ?>" width="50" height="35" style="object-fit:cover; border-radius:4px;"></td>
                            <td><span class="badge bg-info text-dark"><?php echo $row['region']; ?></span></td>
                            <td class="fw-bold"><?php echo $row['country']; ?></td>
                            <td title="<?php echo htmlspecialchars($row['title']); ?>">
                                <?php echo substr($row['title'], 0, 30) . '...'; ?>
                            </td>
                            <td><small><?php echo date("M d, Y", strtotime($row['created_at'])); ?></small></td>
                            <td class="text-center" style="min-width: 150px;">
                                
                                <button type="button" class="btn btn-primary btn-sm me-1"
                                    data-bs-toggle="modal" 
                                    data-bs-target="#editPolicyModal"
                                    data-id="<?php echo $row['id']; ?>"
                                    data-title="<?php echo htmlspecialchars($row['title']); ?>"
                                    data-region="<?php echo $row['region']; ?>"
                                    data-country="<?php echo htmlspecialchars($row['country']); ?>"
                                    data-short="<?php echo htmlspecialchars($row['short_desc']); ?>"
                                    data-content="<?php echo htmlspecialchars($row['content']); ?>">
                                    
                                    
                                    
                                    <i class="fas fa-edit"></i>
                                </button>
                                
                                <a href="?delete_policy_id=<?php echo $row['id']; ?>" 
                                   class="btn btn-danger btn-sm"
                                   onclick="return confirm('Delete this policy news? This cannot be undone.');">
                                    <i class="fas fa-trash-alt"></i>
                                </a>
                            </td>
                        </tr>
                        <?php 
                            }
                        } else {
                            echo "<tr><td colspan='7' class='text-center text-muted p-4'>No policy news found.</td></tr>";
                        }
                        ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <?php endif; ?>

<div class="modal fade" id="editPolicyModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header bg-primary text-white">
                    <h5 class="modal-title">Edit Policy News</h5>
                    <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal"></button>
                </div>
                <form method="POST" enctype="multipart/form-data">
                    <div class="modal-body">
                        <input type="hidden" name="edit_id" id="pol_id">
                        
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="fw-bold">Region</label>
                                <select name="region" id="pol_region" class="form-select" required>
                                    <option value="Americas">Americas</option>
                                    <option value="Europe">Europe</option>
                                    <option value="Asia Pacific">Asia Pacific</option>
                                    <option value="MEA">MEA</option>
                                </select>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="fw-bold">Country</label>
                                
                                <input type="text" name="country" id="pol_country" class="form-control" required>
                            </div>
                        </div>
    
                        <div class="mb-3">
                            <label class="fw-bold">Headline</label>
                            <input type="text" name="title" id="pol_title" class="form-control" required>
                        </div>
    
                        <div class="mb-3">
                            <label class="fw-bold">Short Description</label>
                            <textarea name="short_desc" id="pol_short" class="form-control" rows="2" required></textarea>
                        </div>
    
                        <div class="mb-3">
                            <label class="fw-bold">Full Article</label>
                            <textarea name="content" id="pol_content" class="form-control" rows="6" required></textarea>
                        </div>
                        
                        
                        <div class="row bg-light p-2 border rounded mb-3">
                            <div class="col-md-6">
                                <label class="small fw-bold">Link Text</label>
                                <input type="text" name="link_text" id="pol_link_text" class="form-control">
                            </div>
                            <div class="col-md-6">
                                <label class="small fw-bold">Link URL</label>
                                <input type="url" name="link_url" id="pol_link_url" class="form-control">
                            </div>
                        </div>
    
                        
                        <div class="mb-3 p-3 bg-light border rounded">
                            <label class="fw-bold text-danger">Update Images (Optional)</label>
                            <input type="file" name="image[]" class="form-control" multiple>
                            <small class="text-muted"><i class="fas fa-exclamation-triangle"></i> Uploading new images will replace existing ones.</small>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                        <button type="submit" name="update_policy" class="btn btn-primary">Save Changes</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

<?php if($page == 'feedbacks'): ?>
    
    <div class="row">
        <?php
        $res = $conn->query("SELECT feedback.*, news.title as ntitle FROM feedback JOIN news ON feedback.news_id = news.id ORDER BY feedback.created_at DESC");
        if($res->num_rows > 0) {
            while($row = $res->fetch_assoc()){
        ?>
        <div class="col-md-6 mb-3">
            <div class="card shadow-sm border-0 h-100">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <h6 class="fw-bold text-primary mb-0"><?php echo $row['user_name']; ?></h6>
                        <div class="d-flex align-items-center">
                            <small class="text-muted me-3"><?php echo date('M d', strtotime($row['created_at'])); ?></small>
                            <a href="?page=feedbacks&delete_feedback_id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-danger" style="padding: 2px 8px;" onclick="return confirm('Delete this feedback?');"><i class="fas fa-trash-alt"></i></a>
                        </div>
                    </div>
                    <p class="small text-muted mb-2">On: <em><?php echo substr($row['ntitle'], 0, 50); ?>...</em></p>
                    <div class="p-3 bg-light rounded text-secondary" style="font-style: italic;">"<?php echo $row['message']; ?>"</div>
                </div>
            </div>
        </div>
        <?php }} else { echo "<div class='col-12'><p class='text-center text-muted'>No feedbacks yet.</p></div>"; } ?>
    </div>
    <?php endif; ?>

<?php if($page == 'contacts'): ?>
    
    <div class="row">
        <?php
        $res = $conn->query("SELECT * FROM contact_messages ORDER BY created_at DESC");
        if($res->num_rows > 0) {
            while($row = $res->fetch_assoc()){
        ?>
        <div class="col-md-6 mb-3">
            <div class="card shadow-sm border-0 h-100">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <h6 class="fw-bold text-dark mb-0"><i class="fas fa-user-circle me-1 text-secondary"></i> <?php echo $row['name']; ?></h6>
                        <div class="d-flex align-items-center">
                            <small class="text-muted me-3"><?php echo date('M d', strtotime($row['created_at'])); ?></small>
                            <a href="?page=contacts&delete_contact_id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-danger" style="padding: 2px 8px;" onclick="return confirm('Delete this message?');"><i class="fas fa-trash-alt"></i></a>
                        </div>
                    </div>
                    <div class="mb-3 border-bottom pb-2">
                        <div class="small text-muted mb-1"><i class="fas fa-envelope me-1"></i> <?php echo $row['email']; ?></div>
                        <div class="fw-bold text-primary" style="font-size: 0.95rem;">Subject: <?php echo $row['subject']; ?></div>
                    </div>
                    <div class="d-flex flex-wrap gap-2 mb-2">
                        <span class="badge bg-light text-secondary border fw-normal"><i class="fas fa-building me-1"></i> <?php echo !empty($row['organization']) ? $row['organization'] : 'N/A'; ?></span>
                        <span class="badge bg-light text-secondary border fw-normal"><i class="fas fa-id-card-alt me-1"></i> <?php echo !empty($row['designation']) ? $row['designation'] : 'N/A'; ?></span>
                    </div>
                    <div class="p-3 bg-light rounded text-secondary">"<?php echo $row['message']; ?>"</div>
                </div>
            </div>
        </div>
        <?php }} else { echo "<div class='col-12'><p class='text-center text-muted'>No messages yet.</p></div>"; } ?>
    </div>
    <?php endif; ?>

// 1. Trigger browse when clicking the zone
    zone.addEventListener('click', (e) => {
        if (e.target.classList.contains('remove-mi-btn')) return; // Don't trigger if clicking 'X'
        input.click();
    });

// 2. Handle file selection from browser
    input.addEventListener('change', function() {
        addMiFiles(this.files);
    });

// 3. Handle Drag and Drop
    ['dragenter', 'dragover', 'dragleave', 'drop'].forEach(name => {
        zone.addEventListener(name, (e) => { e.preventDefault(); e.stopPropagation(); });
    });

zone.addEventListener('drop', (e) => {
        addMiFiles(e.dataTransfer.files);
    });

// 4. Handle Paste (Ctrl+V)
    window.addEventListener('paste', (e) => {
        // Only paste if we aren't in a textarea or other input
        if (["TEXTAREA", "INPUT"].includes(document.activeElement.tagName)) return;
        
        const items = e.clipboardData.items;
        for (let item of items) {
            if (item.kind === 'file') {
                addMiFiles([item.getAsFile()]);
            }
        }
    });

function addMiFiles(files) {
        const newFiles = Array.from(files);
        miFiles = miFiles.concat(newFiles);
        renderMiPreviews();
    }

// Global function for the 'X' button
    window.removeMiImage = function(index) {
        miFiles.splice(index, 1);
        renderMiPreviews();
    };

function renderMiPreviews() {
        container.innerHTML = '';
        const dt = new DataTransfer();

miFiles.forEach((file, index) => {
            dt.items.add(file); // Sync file to the actual form input

input.files = dt.files; // This makes sure PHP receives the files
        instructions.style.display = miFiles.length > 0 ? 'none' : 'block';
    }
})();
</script>
    
    <script>
        // 1. Image Preview Logic
        function previewImages(input) {
            const container = document.getElementById('image-preview-container');
            container.innerHTML = '';
            if (input.files) {
                Array.from(input.files).forEach(file => {
                    const reader = new FileReader();
                    reader.onload = function(e) {
                        const img = document.createElement('img');
                        img.src = e.target.result;
                        img.classList.add('preview-img');
                        container.appendChild(img);
                    }
                    reader.readAsDataURL(file);
                });
            }
        }
        
        // 2. Dynamic Country Selection Logic
        const countryData = {
            "Americas": ["US", "Canada", "Mexico", "Brazil", "Argentina", "Colombia", "Chile"],
            "Europe": ["Germany", "UK", "France", "Italy", "Spain", "Portugal", "Belgium", "Netherlands", "Austria", "Switzerland", "Ireland", "Sweden", "Norway", "Russia", "Turkey", "Poland"],
            "Asia Pacific": ["China", "Japan", "Korea", "India", "Thailand", "Indonesia", "Vietnam", "Malaysia", "Taiwan", "Singapore", "Australia", "New Zealand", "Philippines", "Pakistan"],
            "MEA": ["South Africa", "Egypt", "Israel", "UAE", "Saudi Arabia", "Kuwait"]
        };
        
        function updateCountries() {
            const region = document.getElementById("regionSelect").value;
            const countryDropdown = document.getElementById("countrySelect");
            
            // Clear existing
            countryDropdown.innerHTML = '<option value="">Select Country</option>';
            
            if (countryData[region]) {
                countryData[region].forEach(country => {
                    const option = document.createElement("option");
                    option.value = country;
                    option.textContent = country;
                    countryDropdown.appendChild(option);
                });
            }
        }
    </script>
    
    <script>
        // --- GLOBAL ARRAY TO TRACK FILES ---
        let editFilesArray = []; 
        
        /**
         * 1. MAIN HANDLER
         * Processes files from Browse, Drag & Drop, or Paste
         */
        function handleEditFiles(files) {
            const newFiles = Array.from(files);
            // Add new files to our existing tracking array
            editFilesArray = editFilesArray.concat(newFiles);
            
            // Refresh the UI and the hidden input
            updateInputAndPreview();
        }
        
        /**
         * 2. REMOVE IMAGE LOGIC
         * Removes a file from the array and updates the hidden input
         */
        function removeEditImage(index) {
            // Stop propagation to prevent opening file browser when clicking X
            event.stopPropagation(); 
            
            // Remove the file at the specific index
            editFilesArray.splice(index, 1);
            
            // Refresh UI and hidden input
            updateInputAndPreview();
        }
        
        /**
         * 3. SYNC & PREVIEW LOGIC
         * Rebuilds the DataTransfer object and renders the HTML previews
         */
        function updateInputAndPreview() {
            const container = document.getElementById('edit-image-preview-container');
            const fileInput = document.getElementById('edit-hidden-file-input');
            const dataTransfer = new DataTransfer();
        
            container.innerHTML = ''; // Clear current view
        
            editFilesArray.forEach((file, index) => {
                // Add file back to the DataTransfer object for the form submission
                dataTransfer.items.add(file);
        
                // Generate Preview HTML
                const reader = new FileReader();
                reader.onload = function(e) {
                    const div = document.createElement('div');
                    div.className = "preview-wrapper position-relative me-2 mb-2";
                    div.innerHTML = `
                        
                        <span class="remove-img-btn" onclick="removeEditImage(${index})">&times;</span>
                        
                        <img src="${e.target.result}" style="width:80px; height:60px; object-fit:cover; border-radius:5px; border:2px solid #1a237e;">
                        
                        
                        ${index === 0 ? '<span class="badge bg-dark position-absolute bottom-0 start-0 w-100" style="font-size:8px; opacity:0.8;">Cover</span>' : ''}
                    `;
                    container.appendChild(div);
                }
                reader.readAsDataURL(file);
            });
        
            // Update the actual file input so the PHP backend receives the correct files
            fileInput.files = dataTransfer.files;
        }
        
        /**
         * 4. COPY-PASTE (CTRL+V) LOGIC
         */
        window.addEventListener('paste', function(e) {
            const editModal = document.getElementById('editInsightModal');
            if (!editModal || !editModal.classList.contains('show')) return;
        
            const items = (e.clipboardData || e.originalEvent.clipboardData).items;
            let pastedFiles = [];
        
            for (let item of items) {
                if (item.kind === 'file') {
                    pastedFiles.push(item.getAsFile());
                }
            }
        
            if (pastedFiles.length > 0) {
                handleEditFiles(pastedFiles);
            }
        });
        
        /**
         * 5. DRAG & DROP LOGIC
         */
        const editZone = document.getElementById('edit-upload-zone');
        if(editZone) {
            ['dragenter', 'dragover', 'dragleave', 'drop'].forEach(name => {
                editZone.addEventListener(name, e => { 
                    e.preventDefault(); 
                    e.stopPropagation(); 
                }, false);
            });
        
            editZone.addEventListener('drop', e => {
                if (e.dataTransfer.files.length > 0) {
                    handleEditFiles(e.dataTransfer.files);
                }
            }, false);
        }
        
        // 6. UPDATE THE ONCHANGE EVENT
        // Ensure your HTML <input> calls handleEditFiles(this.files) instead of previewEditImages
        document.getElementById('edit-hidden-file-input').addEventListener('change', function() {
            handleEditFiles(this.files);
        });
    </script>

Batal

⬅ globalautoinsight.com 35 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁css	dir	—	2025-12-24 14:08	📂 Buka
📁image	dir	—	2026-09-17 08:15	📂 Buka
📁images	dir	—	2026-09-17 08:15	📂 Buka
📁img	dir	—	2026-07-27 18:23	📂 Buka
📁includes	dir	—	2026-07-13 14:42	📂 Buka
📁shop	dir	—	2026-08-04 20:07	📂 Buka
📁uploads1	dir	—	2026-01-20 17:34	📂 Buka
📄.htaccess	htaccess	1.7 KB	2026-09-05 08:15	✏️ 👁️
📄.user.ini	ini	44 B	2026-06-29 14:36	✏️ 👁️
🐘1.php	php	36.7 KB	2026-09-11 07:53	✏️ 👁️
🐘404.php	php	4.7 KB	2026-06-29 13:22	✏️ 👁️
🐘CompetitiveLandscape.php	php	16.6 KB	2026-01-03 15:17	✏️ 👁️
🐘EditorsView.php	php	16.6 KB	2026-01-03 15:17	✏️ 👁️
🐘EventCoverage.php	php	16.6 KB	2026-01-03 15:17	✏️ 👁️
🐘MarketInsights.php	php	22.5 KB	2026-09-12 06:40	✏️ 👁️
🐘NewsWorldwide.php	php	11.2 KB	2026-08-26 16:19	✏️ 👁️
🐘PolicyTracker.php	php	10.9 KB	2026-01-20 08:58	✏️ 👁️
🐘RecentLaunches.php	php	16.6 KB	2026-01-03 15:19	✏️ 👁️
🐘admin_dashboard.php	php	131.1 KB	2026-09-12 06:43	✏️ 👁️
🐘admin_login.php	php	5.3 KB	2026-06-29 14:44	✏️ 👁️
📝ads.txt	txt	58 B	2026-08-05 16:04	✏️ 👁️
🐘contact.php	php	11.3 KB	2026-01-05 11:37	✏️ 👁️
🐘default.php	php	16 KB	2025-12-20 10:09	✏️ 👁️
🖼️favicon.png	png	194.6 KB	2026-01-05 11:03	✏️ 👁️
🐘fetch_insight.php	php	2.8 KB	2026-04-04 12:42	✏️ 👁️
🌐googleef7659ed3e2ac8f6.html	html	53 B	2026-01-03 06:17	✏️ 👁️
📜gtag.js	js	391 B	2026-07-06 06:31	✏️ 👁️
🐘index.php	php	23.8 KB	2026-07-01 17:33	✏️ 👁️
🐘read_mi_news.php	php	24.3 KB	2026-09-16 06:02	✏️ 👁️
🐘read_news.php	php	23.1 KB	2026-09-04 14:30	✏️ 👁️
🐘read_policy.php	php	23 KB	2026-01-30 13:08	✏️ 👁️
📝robots.txt	txt	153 B	2026-08-27 13:45	✏️ 👁️
🐘search.php	php	8.9 KB	2026-07-01 17:34	✏️ 👁️
🐘sitemap.php	php	2.7 KB	2026-08-26 18:07	✏️ 👁️
🐘user_dashboard.php	php	5 KB	2026-01-03 15:20	✏️ 👁️

✏️ Rename