prepare($articleQuery); if ($stmt === false) { die("MySQL prepare error: " . $mysqli->error); } $stmt->bind_param("i", $articleId); $stmt->execute(); $stmt->store_result(); // Bind results $stmt->bind_result($mainTitle, $mainImage, $mainDescription, $url, $formattedDate, $btnName); if (!$stmt->fetch()) { // If no article is found, display an error message echo "
Article not found!
"; exit; } $stmt->close(); // Fetch the dynamic content for the article $contentQuery = "SELECT contentTitle, contentDescription FROM article_content WHERE article_id = ?"; $contentStmt = $mysqli->prepare($contentQuery); if ($contentStmt === false) { die("MySQL prepare error: " . $mysqli->error); } $contentStmt->bind_param("i", $articleId); $contentStmt->execute(); $contentResult = $contentStmt->get_result(); $dynamicContent = []; while ($row = $contentResult->fetch_assoc()) { $dynamicContent[] = $row; } $contentStmt->close(); // Fetch more related articles than needed to ensure we have enough after filtering $relatedQuery = "SELECT id, mainTitle, mainImage, mainDescription, DATE_FORMAT(date, '%d-%m-%Y') AS formattedDate FROM articles WHERE id != ? ORDER BY date DESC LIMIT 12"; $relatedStmt = $mysqli->prepare($relatedQuery); if ($relatedStmt === false) { die("MySQL prepare error: " . $mysqli->error); } $relatedStmt->bind_param("i", $articleId); $relatedStmt->execute(); $relatedResult = $relatedStmt->get_result(); // Initialize arrays for sorting $relatedWithImages = []; $relatedWithoutImages = []; // Categorize related posts based on image availability while ($row = $relatedResult->fetch_assoc()) { if (hasValidImage($row['mainImage'])) { // Limit to 3 articles with images if (count($relatedWithImages) < 3) { $relatedWithImages[] = $row; } } else { // Limit to 3 articles without images if (count($relatedWithoutImages) < 3) { $relatedWithoutImages[] = $row; } } } $relatedStmt->close(); } else { // If no ID is provided, redirect with an error message header("Location: index.php"); exit; } // Helper function to check if image exists and is valid function hasValidImage($image_path) { if (empty($image_path) || $image_path == 'null' || $image_path == 'undefined') { return false; } $full_path = './uploads/' . $image_path; if (file_exists($full_path) && is_file($full_path) && is_readable($full_path)) { $file_info = getimagesize($full_path); if ($file_info && strpos($file_info['mime'], 'image/') === 0) { return true; } } return false; } // Get shortened text with ellipsis function shortenText($text, $length) { if (strlen($text) <= $length) { return $text; } return substr($text, 0, $length) . '...'; } ?> <?php echo htmlspecialchars($mainTitle); ?> - Mamta Music Banaras
Back

<?php echo htmlspecialchars($mainTitle); ?>

Additional Information

Related Articles

Trending Articles

$post): ?>
<?php echo htmlspecialchars($post['mainTitle']); ?>

Read Article

Expert Insights

$post): ?>

Read Article

Share This Article

Help others discover this valuable content

" target="_blank" class="share-btn flex flex-col items-center justify-center bg-white hover:bg-blue-50 border border-gray-200 rounded-lg p-4 transition-all duration-300 group">
Facebook &text=" target="_blank" class="share-btn flex flex-col items-center justify-center bg-white hover:bg-blue-50 border border-gray-200 rounded-lg p-4 transition-all duration-300 group">
Twitter " target="_blank" class="share-btn flex flex-col items-center justify-center bg-white hover:bg-green-50 border border-gray-200 rounded-lg p-4 transition-all duration-300 group">
WhatsApp " class="share-btn flex flex-col items-center justify-center bg-white hover:bg-red-50 border border-gray-200 rounded-lg p-4 transition-all duration-300 group">
Email
Link copied to clipboard!