prepare($sql); $stmt->execute([$name, $email, $phone, $subject, $form_message]); $_SESSION['form_message'] = ['type' => 'success', 'text' => 'Your message has been sent successfully! We will get back to you soon.']; } catch (PDOException $e) { $_SESSION['form_message'] = ['type' => 'error', 'text' => 'There was a database error. Please try again.']; } } else { $_SESSION['form_message'] = ['type' => 'error', 'text' => 'Please fill in all required fields with valid information.']; } header("Location: " . $_SERVER['REQUEST_URI']); exit; } // --- 2. Comment Form Handling --- if (isset($_POST['submit_comment'])) { $name = clean_input($_POST['name']); $email = clean_input($_POST['email']); $comment_text = clean_input($_POST['comment']); $post_slug = clean_input($_POST['post_slug']); $post_type = clean_input($_POST['post_type']); if (!empty($name) && !empty($email) && filter_var($email, FILTER_VALIDATE_EMAIL) && !empty($comment_text) && !empty($post_slug) && !empty($post_type)) { try { // is_approved ko '1' (auto-approve) kar diya gaya hai $sql = "INSERT INTO comments (post_slug, post_type, name, email, comment, is_approved, created_at) VALUES (?, ?, ?, ?, ?, 1, NOW())"; $stmt = $pdo->prepare($sql); $stmt->execute([$post_slug, $post_type, $name, $email, $comment_text]); $_SESSION['form_message'] = ['type' => 'success', 'text' => 'Your comment has been posted successfully!']; } catch (PDOException $e) { $_SESSION['form_message'] = ['type' => 'error', 'text' => 'There was a database error submitting your comment.']; } } else { $_SESSION['form_message'] = ['type' => 'error', 'text' => 'Please fill in all required fields to submit a comment.']; } header("Location: " . $_SERVER['REQUEST_URI']); exit; } // --- 3. Display Session Message (if any) --- if (isset($_SESSION['form_message'])) { $msg = $_SESSION['form_message']; $message_html = '
' . htmlspecialchars($msg['text']) . '
'; unset($_SESSION['form_message']); } // --- END OF FORM HANDLING --- // --- 1. URL Routing Logic --- $request_uri = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH); // Folder where the script is installed $base_path = '/free-seo-tools'; // Remove the installation folder if (strpos($request_uri, $base_path) === 0) { $request_uri = substr($request_uri, strlen($base_path)); } // Remove index.php if present $request_uri = preg_replace('#^/index\.php#', '/', $request_uri); // Final slug $slug = trim($request_uri, '/'); $category_slug = null; $tool_data = null; $page_data = null; $category_data = null; $blog_post_slug = null; $blog_post_data = null; if (empty($slug) || $slug === 'index.php') { $action = 'home'; } else if ($slug === 'blog') { $action = 'blog_index'; } else if (strpos($slug, 'blog/') === 0) { $blog_post_slug = substr($slug, strlen('blog/')); $stmt = $pdo->prepare("SELECT * FROM blog_posts WHERE slug = ? AND is_active = 1"); $stmt->execute([$blog_post_slug]); $blog_post_data = $stmt->fetch(PDO::FETCH_ASSOC); if ($blog_post_data) { $action = 'blog_post'; } else { $action = '404'; } } else if (strpos($slug, 'category/') === 0) { $category_slug = substr($slug, strlen('category/')); $stmt = $pdo->prepare("SELECT * FROM categories WHERE slug = ? AND is_active = 1"); $stmt->execute([$category_slug]); $category_data = $stmt->fetch(PDO::FETCH_ASSOC); if ($category_data) { $action = 'category'; } else { $action = '404'; } } else { $stmt = $pdo->prepare("SELECT * FROM tools WHERE slug = ? AND is_active = 1"); $stmt->execute([$slug]); $tool_data = $stmt->fetch(PDO::FETCH_ASSOC); if ($tool_data) { $action = 'tool'; // 🔽 NAYA: Tool Analytics 🔽 try { $sql_update_view = "UPDATE tools SET view_count = view_count + 1 WHERE id = ?"; $pdo->prepare($sql_update_view)->execute([$tool_data['id']]); } catch (PDOException $e) { /* Do nothing */ } } else { $stmt = $pdo->prepare("SELECT * FROM pages WHERE slug = ? AND is_active = 1"); $stmt->execute([$slug]); $page_data = $stmt->fetch(PDO::FETCH_ASSOC); if ($page_data) { $action = 'page'; } else { $action = '404'; } } } // --- 2. Data Fetching and SEO Setup --- $tools = []; $categories = []; $blog_posts = []; if ($action === 'home' || $action === 'category') { try { $cat_stmt = $pdo->query("SELECT id, name, slug FROM categories WHERE is_active = 1 ORDER BY name ASC"); $categories = $cat_stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $categories = []; } } if ($action === 'home') { try { // 🔽 NAYA: Category Wise Logic 🔽 $stmt_tools = $pdo->query("SELECT t.tool_name, t.slug, t.short_description, t.icon_class, c.slug as category_slug, c.name as category_name FROM tools t JOIN categories c ON t.category_id = c.id WHERE t.is_active = 1 AND c.is_active = 1 ORDER BY c.name ASC, t.tool_name ASC"); $tools_with_cat = $stmt_tools->fetchAll(PDO::FETCH_ASSOC); $stmt_no_cat = $pdo->query("SELECT tool_name, slug, short_description, icon_class, NULL as category_slug, 'Other Tools' as category_name FROM tools WHERE is_active = 1 AND (category_id IS NULL OR category_id NOT IN (SELECT id FROM categories WHERE is_active = 1)) ORDER BY tool_name ASC"); $tools_no_cat = $stmt_no_cat->fetchAll(PDO::FETCH_ASSOC); $tools = array_merge($tools_with_cat, $tools_no_cat); } catch (PDOException $e) { $tools = []; } $page_seo = [ 'title' => get_setting('home_seo_title') ?: get_setting('site_name') . ' - Online Tools', 'description' => get_setting('home_seo_description'), 'keywords' => get_setting('home_seo_keywords') ]; } elseif ($action === 'category' && $category_data) { try { $stmt = $pdo->prepare("SELECT tool_name, slug, short_description, icon_class FROM tools WHERE is_active = 1 AND category_id = ? ORDER BY tool_name ASC"); $stmt->execute([$category_data['id']]); $tools = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $tools = []; } $page_seo = [ 'title' => secure_input($category_data['name']) . ' Tools | ' . get_setting('site_name'), 'description' => secure_input($category_data['description']) ?: 'Find the best ' . secure_input($category_data['name']) . ' tools on ' . get_setting('site_name') . '.', 'keywords' => strtolower(secure_input($category_data['name'])) . ', online tools, ' . get_setting('site_name') ]; } elseif ($action === 'blog_index') { try { $stmt = $pdo->query("SELECT title, slug, thumbnail_url, LEFT(content, 150) as excerpt, created_at FROM blog_posts WHERE is_active = 1 ORDER BY created_at DESC"); $blog_posts = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $blog_posts = []; } $page_seo = [ 'title' => 'Blog | ' . get_setting('site_name'), 'description' => 'Read our latest articles, tutorials, and updates about PDF & image tools and productivity.', 'keywords' => 'blog, articles, tutorials, pdf tips, image tips, ' . get_setting('site_name') ]; } elseif ($action === 'blog_post' && $blog_post_data) { $page_seo = [ 'title' => secure_input($blog_post_data['seo_title'] ?: $blog_post_data['title'] . ' | ' . get_setting('site_name')), 'description' => secure_input($blog_post_data['seo_description']), 'keywords' => secure_input($blog_post_data['seo_keywords']) ]; } elseif ($action === 'tool' && $tool_data) { $page_seo = [ 'title' => secure_input($tool_data['seo_title'] ?: $tool_data['tool_name'] . ' | ' . get_setting('site_name')), 'description' => secure_input($tool_data['seo_description'] ?: $tool_data['short_description']), 'keywords' => secure_input($tool_data['seo_keywords']) ]; } elseif ($action === 'page' && $page_data) { $page_seo = [ 'title' => secure_input($page_data['seo_title'] ?: $page_data['title'] . ' | ' . get_setting('site_name')), 'description' => secure_input($page_data['seo_description']), 'keywords' => secure_input($page_data['seo_keywords']) ]; } else { http_response_code(404); $page_seo = [ 'title' => '404 Not Found | ' . get_setting('site_name'), 'description' => 'The page you requested could not be found.' ]; $action = '404'; } // --- 3. HTML Rendering --- $page_title = $page_seo['title'] ?? get_setting('site_name'); $meta_description = $page_seo['description'] ?? ''; $meta_keywords = $page_seo['keywords'] ?? ''; include 'header.php'; if ($action !== 'tool') { echo '
'; } else { echo '
'; } // Naya: Session Message if ($action === 'page' || $action === 'tool' || $action === 'blog_post') { echo '
' . $message_html . '
'; } switch ($action) { case 'home': ?>

Browse by Category

5): ?>
' . secure_input($current_category) . ''; endif; ?>

No active tools found. Please add tools via the admin panel.

Tools

No tools found in the '' category yet.

Back to All Categories

prepare("SELECT tool_name, slug, short_description, icon_class FROM tools WHERE category_id = ? AND id != ? AND is_active = 1 LIMIT 4"); $stmt_related->execute([$tool_data['category_id'], $tool_data['id']]); $related_tools = $stmt_related->fetchAll(PDO::FETCH_ASSOC); } ?>

Related Tools
prepare("SELECT name, comment, created_at FROM comments WHERE post_slug = ? AND post_type = 'tool' AND is_approved = 1 ORDER BY created_at DESC"); $stmt_comments->execute([$tool_data['slug']]); $comments = $stmt_comments->fetchAll(PDO::FETCH_ASSOC); ?>

Comments ()

  • Be the first to leave a comment!

Leave a Comment

Our Blog

Latest articles, tips, and updates.

No blog posts found yet. Please check back later!

Published on

<?php echo secure_input($blog_post_data['title']); ?>
prepare("SELECT title, slug, thumbnail_url, LEFT(content, 150) as excerpt, created_at FROM blog_posts WHERE id != ? AND is_active = 1 ORDER BY created_at DESC LIMIT 3"); $stmt_related->execute([$blog_post_data['id']]); $related_posts = $stmt_related->fetchAll(PDO::FETCH_ASSOC); ?>

Recent Posts

prepare("SELECT name, comment, created_at FROM comments WHERE post_slug = ? AND post_type = 'blog' AND is_approved = 1 ORDER BY created_at DESC"); $stmt_comments->execute([$blog_post_data['slug']]); $comments = $stmt_comments->fetchAll(PDO::FETCH_ASSOC); ?>

Comments ()

  • Be the first to leave a comment!

Leave a Comment

Back to Blog

404

Oops! Page Not Found

Sorry, the page you are looking for doesn't exist or has been moved.

Go to Homepage
'; // 🔽 NAYA 🔽: Country Code Library JS if ($action === 'page' && isset($page_data['slug']) && $page_data['slug'] === 'contact-us'): ?>