404
Article Not Found
The financial article you are looking for might have been moved or does not exist.
Return to Homepage
prepare("
SELECT c.name, c.slug
FROM categories c
JOIN post_categories pc ON c.id = pc.category_id
WHERE pc.post_id = ?
");
$categories_stmt->execute([$post['id']]);
$post_categories = $categories_stmt->fetchAll();
} catch (PDOException $e) {
// Gracefully handle if tables don't exist
}
// Fetch tags for the post
$post_tags = [];
try {
$tags_stmt = $pdo->prepare("
SELECT t.name, t.slug
FROM tags t
JOIN post_tags pt ON t.id = pt.tag_id
WHERE pt.post_id = ?
");
$tags_stmt->execute([$post['id']]);
$post_tags = $tags_stmt->fetchAll();
} catch (PDOException $e) {
// Gracefully handle if tables don't exist
}
// Fetch related posts
$related_posts = [];
if (!empty($post_categories)) {
try {
$first_category_id_stmt = $pdo->prepare("SELECT category_id FROM post_categories WHERE post_id = ? LIMIT 1");
$first_category_id_stmt->execute([$post['id']]);
$first_category_id = $first_category_id_stmt->fetchColumn();
if ($first_category_id) {
$related_stmt = $pdo->prepare("
SELECT DISTINCT p.id, p.title, p.slug, p.excerpt, p.created_at, p.featured_image_id,
p.word_count, p.status,
i.file_path as featured_image, i.alt_text as featured_alt_text
FROM posts p
LEFT JOIN images i ON p.featured_image_id = i.id
JOIN post_categories pc ON p.id = pc.post_id
WHERE pc.category_id = ?
AND p.id != ?
AND p.status = 'published'
ORDER BY p.created_at DESC
LIMIT 4
");
$related_stmt->execute([$first_category_id, $post['id']]);
$related_posts = $related_stmt->fetchAll();
}
} catch (PDOException $e) {
// Gracefully handle errors
error_log("Error fetching related posts: " . $e->getMessage());
}
}
// Meta data and helper values
$page_title = html_entity_decode($post['meta_title'] ?: $post['title']) . ' - MiscCalculators';
$meta_description = $post['meta_description'] ?: ($post['excerpt'] ?? 'Read our latest financial guide on MiscCalculators');
$reading_time = ceil(($post['word_count'] ?? 500) / 200);
// Function to format date
function formatDate($date) {
return date('F j, Y', strtotime($date));
}
// Function to get time ago
function timeAgo($date) {
$timestamp = strtotime($date);
$difference = time() - $timestamp;
if ($difference < 3600) {
$minutes = floor($difference / 60);
return $minutes . ' minutes ago';
} elseif ($difference < 86400) {
$hours = floor($difference / 3600);
return $hours . ' hours ago';
} else {
$days = floor($difference / 86400);
return $days . ' days ago';
}
}
// *** START: Load calculators from tools.json ***
$calculators = [];
$tools_file_path = __DIR__ . '/../tools.json'; // Assumes tools.json is in the parent public_html directory
if (file_exists($tools_file_path)) {
$tools_json = file_get_contents($tools_file_path);
$all_tools = json_decode($tools_json, true);
if (is_array($all_tools)) {
$calculators = array_filter($all_tools, function($tool) {
return isset($tool['status']) && $tool['status'] === 'active';
});
}
}
// *** END: Load calculators ***
// Admin functions to render admin controls
function renderAdminControls($postId, $elementType, $elementId = '') {
global $userIsAdmin;
if (!$userIsAdmin) {
return '';
}
$jsArg = is_numeric($elementId) ? $elementId : ("'" . addslashes($elementId) . "'");
$controls = '';
switch ($elementType) {
case 'title':
$controls = '