File Manager

✏️ Edit File: C:\Inetpub\vhosts\doitcajmer.in\akhileshmittal.in/index.php

<?php 
include('config/db.php');

$limit = 5; 
$page = isset($_GET['page']) && is_numeric($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) { $page = 1; }
$offset = ($page - 1) * $limit;

// ================== SEARCH & CATEGORY ROUTER SYSTEM ==================
$search_query = "";
$cat_filter = "";
$where_clauses = [];

if (isset($_GET['search']) && !empty(trim($_GET['search']))) {
    $search_query = mysqli_real_escape_string($conn, trim($_GET['search']));
    $where_clauses[] = "(posts.title LIKE '%$search_query%' OR posts.content LIKE '%$search_query%')";
}

if (isset($_GET['category']) && is_numeric($_GET['category'])) {
    $cat_filter = (int)$_GET['category'];
    $where_clauses[] = "posts.category_id = $cat_filter";
}

$where_clause_str = "";
if (count($where_clauses) > 0) {
    $where_clause_str = " WHERE " . implode(" AND ", $where_clauses);
}

// Total records calculate
$total_query = "SELECT COUNT(*) FROM posts" . $where_clause_str;
$total_result = mysqli_query($conn, $total_query);
$total_rows = mysqli_fetch_array($total_result)[0];
$total_pages = ceil($total_rows / $limit);

// Main Query with Categories JOIN
$query = "SELECT posts.*, categories.name AS category_name 
          FROM posts 
          LEFT JOIN categories ON posts.category_id = categories.id " 
          . $where_clause_str . 
          " ORDER BY posts.created_at DESC LIMIT $limit OFFSET $offset";
$result = mysqli_query($conn, $query);

// Side menu dynamic categories loader
$categories_list = mysqli_query($conn, "SELECT * FROM categories ORDER BY name ASC");

// Sidebar analytical metric: Overall Views Count
$views_sum_res = mysqli_query($conn, "SELECT SUM(views) AS total_views FROM posts");
$views_sum_row = mysqli_fetch_assoc($views_sum_res);
$global_views = isset($views_sum_row['total_views']) ? (int)$views_sum_row['total_views'] : 0;
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Akhilesh Mittal | Tech Insights & Quizzes</title>
    <script src="https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4"></script>
    <link href="https://fonts.googleapis.com/css2?family=Plus+Jakarta+Sans:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <style> body { font-family: 'Plus Jakarta Sans', sans-serif; } </style>
</head>
<body class="bg-slate-50 text-slate-800 antialiased min-h-screen flex flex-col">

<nav class="bg-white border-b border-slate-100 shadow-sm">
        <div class="max-w-6xl mx-auto px-6 h-16 flex items-center justify-between">
            <a href="index.php" class="text-xl font-bold tracking-tight text-slate-900 hover:text-blue-600 transition">
                Akhilesh <span class="text-blue-600">Mittal.</span>
            </a>
            <div class="flex items-center gap-6 font-medium text-sm text-slate-600">
                <a href="index.php" class="text-blue-600 font-semibold">Home</a>
                <a href="about.php" class="hover:text-slate-900 transition">About</a>
                <a href="contact.php" class="hover:text-slate-900 transition">Contact</a>
            </div>
        </div>
    </nav>

<header class="bg-white border-b border-slate-100 py-6 px-6">
        <div class="max-w-6xl mx-auto flex flex-col md:flex-row items-center justify-between gap-4">
            
            <div class="text-center md:text-left">
                <h1 class="text-xl font-extrabold text-slate-900 tracking-tight">Tech Insights & Architecture</h1>
                <p class="text-xs text-slate-400 mt-0.5">Knowledge Hub & Modular Frameworks</p>
            </div>
            
            <div class="w-full md:w-auto flex flex-col items-end gap-2">
                <form action="index.php" method="GET" class="w-full md:w-80 flex gap-2 bg-slate-50 p-1 border border-slate-200 rounded-xl focus-within:ring-2 focus-within:ring-blue-500/25 transition">
                    <?php if(!empty($cat_filter)): ?>
                        <input type="hidden" name="category" value="<?php echo $cat_filter; ?>">
                    <?php endif; ?>
                    <input type="text" name="search" value="<?php echo htmlspecialchars($search_query); ?>" placeholder="Search keyword..." class="w-full bg-transparent px-3 py-1 text-xs focus:outline-none">
                    <button type="submit" class="bg-blue-600 text-white px-3 py-1 rounded-lg text-[11px] font-semibold hover:bg-blue-700 transition">Search</button>
                </form>
                
                <?php if(!empty($search_query) || !empty($cat_filter)): ?>
                    <p class="text-[11px] text-slate-400">Filters active. <a href="index.php" class="text-blue-600 underline font-medium">Clear all</a></p>
                <?php endif; ?>
            </div>
        </div>

<div class="max-w-6xl mx-auto flex flex-wrap gap-1.5 mt-4 pt-4 border-t border-slate-100/60 justify-center md:justify-start">
            <a href="index.php<?php echo !empty($search_query) ? '?search='.urlencode($search_query) : ''; ?>" class="px-3 py-1 rounded-full text-[11px] font-semibold transition <?php echo empty($cat_filter) ? 'bg-blue-600 text-white shadow-xs' : 'bg-slate-100 text-slate-600 hover:bg-slate-200'; ?>">All Topics</a>
            <?php mysqli_data_seek($categories_list, 0);
            while($c_row = mysqli_fetch_assoc($categories_list)): ?>
                <a href="index.php?category=<?php echo $c_row['id']; ?><?php echo !empty($search_query) ? '&search='.urlencode($search_query) : ''; ?>" class="px-3 py-1 rounded-full text-[11px] font-semibold transition <?php echo ($cat_filter === (int)$c_row['id']) ? 'bg-blue-600 text-white shadow-xs' : 'bg-slate-100 text-slate-600 hover:bg-slate-200'; ?>">
                    <?php echo htmlspecialchars($c_row['name']); ?>
                </a>
            <?php endwhile; ?>
        </div>
    </header>

<main class="max-w-6xl mx-auto px-6 py-8 flex-1 w-full">
        <div class="grid grid-cols-1 lg:grid-cols-3 gap-10">
            
            <div class="lg:col-span-2 space-y-6">
                <?php if(mysqli_num_rows($result) > 0): ?>
                    <?php while($post = mysqli_fetch_assoc($result)): ?>
                        
                        <article class="bg-white border border-slate-100 rounded-2xl overflow-hidden shadow-xs hover:shadow-md transition duration-200 flex flex-col sm:flex-row items-stretch">
                            <?php if(!empty($post['image'])): ?>
                                <div class="sm:w-1/3 min-h-[160px] max-h-[220px] sm:max-h-full relative bg-slate-100 overflow-hidden shrink-0">
                                    <img src="uploads/<?php echo $post['image']; ?>" loading="lazy" class="absolute inset-0 w-full h-full object-cover object-center transition duration-300 hover:scale-105">
                                </div>
                            <?php else: ?>
                                <div class="sm:w-1/3 min-h-[160px] bg-slate-50 flex items-center justify-center border-r border-slate-100 text-slate-300 shrink-0 text-2xl">📄</div>
                            <?php endif; ?>
                            
                            <div class="p-5 md:p-6 flex flex-col justify-between flex-1 min-w-0">
                                <div>
                                    <div class="flex flex-wrap items-center gap-2 text-[10px] font-bold uppercase tracking-wider text-slate-400 mb-2">
                                        <span class="text-blue-600 bg-blue-50 px-2 py-0.5 rounded-md"><?php echo !empty($post['category_name']) ? htmlspecialchars($post['category_name']) : 'General'; ?></span>
                                        <span>•</span>
                                        <span>📅 <?php echo date('M d, Y', strtotime($post['created_at'])); ?></span>
                                        <span>•</span>
                                        <span class="text-slate-500 bg-slate-100 px-2 py-0.5 rounded-md">👁️ <?php echo (int)$post['views']; ?> Views</span>
                                    </div>
                                    <h3 class="text-lg font-bold text-slate-900 hover:text-blue-600 transition leading-snug break-words">
                                        <a href="post.php?id=<?php echo $post['id']; ?>"><?php echo htmlspecialchars($post['title']); ?></a>
                                    </h3>
                                    <div class="text-slate-500 text-sm mt-2 line-clamp-2 leading-relaxed font-light">
                                        <?php echo substr(strip_tags($post['content']), 0, 140) . '...'; ?>
                                    </div>
                                </div>
                                <div class="mt-4 pt-3 border-t border-slate-100 flex items-center justify-between">
                                    <a href="post.php?id=<?php echo $post['id']; ?>" class="text-sm font-semibold text-blue-600 hover:text-blue-700 transition group flex items-center gap-1">
                                        Read Article <span class="group-hover:translate-x-1 transition duration-150">→</span>
                                    </a>
                                </div>
                            </div>
                        </article>

<?php endwhile; ?>

<?php if ($total_pages > 1): ?>
                        <div class="flex items-center justify-between border-t border-slate-200 pt-5 mt-6">
                            <a href="index.php?page=<?php echo max(1, $page-1); ?>&search=<?php echo urlencode($search_query); ?>&category=<?php echo $cat_filter; ?>" class="px-4 py-2 border border-slate-200 rounded-xl text-sm font-semibold text-slate-700 bg-white hover:bg-slate-50 transition <?php echo ($page <= 1) ? 'pointer-events-none opacity-40' : ''; ?>">← Previous</a>
                            <span class="text-sm text-slate-500 font-medium">Page <?php echo $page; ?> of <?php echo $total_pages; ?></span>
                            <a href="index.php?page=<?php echo min($total_pages, $page+1); ?>&search=<?php echo urlencode($search_query); ?>&category=<?php echo $cat_filter; ?>" class="px-4 py-2 border border-slate-200 rounded-xl text-sm font-semibold text-slate-700 bg-white hover:bg-slate-50 transition <?php echo ($page >= $total_pages) ? 'pointer-events-none opacity-40' : ''; ?>">Next →</a>
                        </div>
                    <?php endif; ?>

<?php else: ?>
                    <div class="bg-white p-12 text-center rounded-2xl border border-slate-100 shadow-sm">
                        <span class="text-3xl">🔍</span>
                        <p class="text-slate-500 font-medium mt-2">No articles matched your adjustments.</p>
                    </div>
                <?php endif; ?>
            </div>

<div class="space-y-6">
                <div class="bg-slate-900 text-white p-6 rounded-2xl relative overflow-hidden shadow-sm">
                    <div class="absolute -right-8 -bottom-8 w-24 h-24 bg-blue-600/20 rounded-full blur-xl"></div>
                    <h3 class="text-base font-bold mb-3">About The Author</h3>
                    <p class="text-slate-400 text-xs leading-relaxed font-light">
                        Hi, I'm Akhilesh Mittal. I specialize in backend custom architectures, dynamic system frameworks, and database optimization algorithms.
                    </p>
                    <div class="mt-4 pt-3 border-t border-slate-800 flex justify-between items-center text-xs text-slate-400">
                        <span>Total Blog Reads:</span>
                        <span class="text-blue-400 font-bold bg-slate-800 px-2 py-0.5 rounded">🔥 <?php echo $global_views; ?></span>
                    </div>
                </div>

<div class="bg-white border border-slate-200/60 p-5 rounded-2xl shadow-sm">
                    <h3 class="text-sm font-bold text-slate-900 mb-1">Newsletter</h3>
                    <p class="text-slate-500 text-xs leading-relaxed mb-3">Get technical notifications direct in your inbox.</p>
                    <form class="space-y-2" onsubmit="event.preventDefault(); alert('Subscribed successfully!');">
                        <input type="email" placeholder="Your email address" required class="w-full text-xs p-2.5 border border-slate-200 rounded-xl focus:outline-none focus:ring-2 focus:ring-blue-500/20 bg-slate-50/50">
                        <button class="w-full bg-blue-600 text-white py-2 rounded-xl text-xs font-semibold hover:bg-blue-700 transition shadow-sm">Subscribe</button>
                    </form>
                </div>
            </div>
            
        </div>
    </main>

<footer class="bg-white border-t border-slate-100 py-6 mt-12 text-center text-xs text-slate-400 w-full shadow-inner">
        <div class="max-w-6xl mx-auto px-6 flex flex-col sm:flex-row justify-between items-center gap-2">
            <p>&copy; <?php echo date('Y'); ?> Akhilesh Mittal. All rights reserved.</p>
            <div class="flex gap-4 text-slate-400 font-medium">
                <a href="about.php" class="hover:text-blue-600 transition">About</a>
                <a href="contact.php" class="hover:text-blue-600 transition">Contact</a>
                <a href="admin/index.php" target="_blank" class="hover:text-blue-600 transition bg-slate-100 px-2 py-0.5 rounded">Admin Control</a>
            </div>
        </div>
    </footer>

</body>
</html>

Batal

⬅ Naik ke doitcajmer.in 14 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁.well-known	dir	—	2021-10-01 11:29	📂 Buka
📁admin	dir	—	2026-07-10 03:03	📂 Buka
📁api	dir	—	2026-07-08 17:29	📂 Buka
📁cgi-bin	dir	—	2021-05-06 06:54	📂 Buka
📁config	dir	—	2026-07-07 02:55	📂 Buka
📁uploads	dir	—	2026-08-05 08:02	📂 Buka
📄.htaccess	htaccess	3.6 KB	2025-02-09 16:05	✏️ Edit 👁️ View
🐘about.php	php	6.7 KB	2026-07-07 02:54	✏️ Edit 👁️ View
📄ae.pHP56	php56	6.7 KB	2026-08-05 08:02	✏️ Edit 👁️ View
🐘contact.php	php	7.7 KB	2026-07-10 03:11	✏️ Edit 👁️ View
🐘index.php	php	13.5 KB	2026-07-10 03:36	✏️ Edit 👁️ View
🐘mgrr.php	php	19.8 KB	2026-08-05 08:02	✏️ Edit 👁️ View
🐘post.php	php	11.5 KB	2026-07-10 03:30	✏️ Edit 👁️ View
📄web.config	config	677 B	2025-02-08 11:54	✏️ Edit 👁️ View