File: /home/durgeshpandey215/www/ipsol.skilladders.com/footer_v2.php
<?php
// Ensure $base_url is defined if not already (fallback for root pages)
if (!isset($base_url)) {
$base_dir = dirname($_SERVER['SCRIPT_NAME']);
$base_url = rtrim(str_replace('\\', '/', $base_dir), '/') . '/';
// If run from root, base_dir might be /, resulting in //, fix that
if($base_url == '//') $base_url = '/';
}
// Fetch Categories for Footer
// Ensure DB connection
if(!isset($con)){
if(file_exists('controller/DB_Config.php')) {
require_once 'controller/DB_Config.php';
$con = OpenCon();
} elseif(file_exists('../controller/DB_Config.php')) {
require_once '../controller/DB_Config.php';
$con = OpenCon();
}
}
$footer_cats = [];
if(isset($con)) {
// Select parent categories
$cat_sql = "SELECT id, name FROM courses WHERE parent_course_id IS NULL AND delete_status = 'N' ORDER BY sort_order ASC";
$cat_res = mysqli_query($con, $cat_sql);
if($cat_res){
while($row = mysqli_fetch_assoc($cat_res)){
$footer_cats[] = $row;
}
}
}
?>
<!-- Footer Global Component -->
<footer class="bg-gray-900 text-slate-400 py-16 border-t border-gray-800 font-sans">
<div class="max-w-[1400px] mx-auto px-4 sm:px-6 lg:px-8">
<div class="grid grid-cols-2 lg:grid-cols-4 gap-8 md:gap-12">
<!-- Dynamic Categories -->
<?php if(!empty($footer_cats)): ?>
<?php foreach($footer_cats as $f_cat): ?>
<div class="col-span-1">
<h4 class="text-white font-bold text-base mb-4 relative inline-block">
<?php echo $f_cat['name']; ?>
<span class="absolute -bottom-1.5 left-0 w-1/2 h-0.5 bg-blue-500 rounded-full"></span>
</h4>
<ul class="flex flex-col space-y-2">
<?php
// Fetch Subcourses
if(isset($con)){
$sub_sql = "SELECT name, page_url FROM courses WHERE parent_course_id = ".$f_cat['id']." AND delete_status='N' ORDER BY sort_order ASC LIMIT 6";
$sub_res = mysqli_query($con, $sub_sql);
if($sub_res && mysqli_num_rows($sub_res) > 0):
while($sub = mysqli_fetch_assoc($sub_res)):
?>
<li>
<a href="<?php echo $base_url; ?>course/<?php echo $sub['page_url']; ?>.php" class="group flex items-center gap-1.5 text-slate-500 hover:text-white transition-all duration-300">
<i class="fa fa-angle-right text-xs text-slate-700 group-hover:text-blue-400 transition-colors"></i>
<span class="text-[13px] font-medium truncate"><?php echo $sub['name']; ?></span>
</a>
</li>
<?php
endwhile;
else:
echo "<li class='text-gray-600 italic text-xs col-span-2'>Coming Soon</li>";
endif;
}
?>
</ul>
</div>
<?php endforeach; ?>
<?php else: ?>
<!-- Fallback Static Popular Courses -->
<div class="col-span-1">
<h4 class="text-white font-bold text-base mb-4 relative inline-block">
Popular Courses
<span class="absolute -bottom-1.5 left-0 w-1/2 h-0.5 bg-blue-500 rounded-full"></span>
</h4>
<ul class="flex flex-col space-y-2">
<li>
<a href="<?php echo $base_url; ?>course/ccna-rs-training.php" class="group flex items-center gap-1.5 text-slate-500 hover:text-white transition-all duration-300">
<i class="fa fa-angle-right text-xs text-slate-700 group-hover:text-blue-400 transition-colors"></i>
<span class="text-[13px] font-medium truncate">CCNA R&S</span>
</a>
</li>
<li>
<a href="<?php echo $base_url; ?>course/ccnp-rs-training.php" class="group flex items-center gap-1.5 text-slate-500 hover:text-white transition-all duration-300">
<i class="fa fa-angle-right text-xs text-slate-700 group-hover:text-blue-400 transition-colors"></i>
<span class="text-[13px] font-medium truncate">CCNP R&S</span>
</a>
</li>
<li>
<a href="<?php echo $base_url; ?>course/ccie-security-training.php" class="group flex items-center gap-1.5 text-slate-500 hover:text-white transition-all duration-300">
<i class="fa fa-angle-right text-xs text-slate-700 group-hover:text-blue-400 transition-colors"></i>
<span class="text-[13px] font-medium truncate">CCIE Security</span>
</a>
</li>
</ul>
</div>
<?php endif; ?>
</div>
<!-- Bottom Section: Contact & Socials & Quick Links -->
<div class="mt-16 pt-8 border-t border-slate-800/50 grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-8 items-start">
<!-- Contact Info -->
<div class="md:col-span-2 space-y-6">
<a href="<?php echo $base_url; ?>index.php" class="inline-block mb-4 bg-white p-2 rounded-lg">
<img src="<?php echo $base_url; ?>img/LOGO1.png" alt="IPsol" class="h-10 w-auto opacity-100">
</a>
<div class="space-y-4">
<div class="flex items-start gap-4">
<i class="fa fa-map-marker mt-1 text-blue-400 text-lg"></i>
<p class="text-sm leading-relaxed max-w-md text-slate-400">10, Varkana Bhavan, Bhawani Shankar Road, Opp: Kabutar Khana, Dadar-West, Mumbai-400028, India</p>
</div>
<div class="flex items-center gap-4">
<i class="fa fa-phone text-blue-400 text-lg"></i>
<div class="text-sm flex gap-4">
<a href="tel:9820193115" class="hover:text-white transition block">9820193115</a>
<span class="text-slate-600">/</span>
<a href="tel:9664446988" class="hover:text-white transition block">9664446988</a>
</div>
</div>
<div class="flex items-center gap-4">
<i class="fa fa-envelope text-blue-400 text-lg"></i>
<a href="mailto:info@ipsol.in" class="text-sm hover:text-white transition">info@ipsol.in</a>
</div>
</div>
</div>
<!-- Quick Links -->
<div>
<h4 class="text-white font-bold text-lg mb-6">Quick Links</h4>
<ul class="space-y-3 text-sm">
<li><a href="<?php echo $base_url; ?>index.php" class="hover:text-blue-400 transition-colors">Home</a></li>
<li><a href="<?php echo $base_url; ?>about-us.php" class="hover:text-blue-400 transition-colors">About Us</a></li>
<li><a href="<?php echo $base_url; ?>placement.php" class="hover:text-blue-400 transition-colors">Placement</a></li>
<li><a href="<?php echo $base_url; ?>blog.php" class="hover:text-blue-400 transition-colors">Blog</a></li>
<li><a href="<?php echo $base_url; ?>contact.php" class="hover:text-blue-400 transition-colors">Contact Us</a></li>
</ul>
</div>
<!-- Socials -->
<div class="flex flex-col lg:items-end">
<h5 class="text-white font-bold text-sm mb-4">Connect With Us</h5>
<div class="flex gap-4">
<a href="https://www.facebook.com/IPSolutionsIndia/" class="w-10 h-10 rounded-full bg-slate-800 flex items-center justify-center group hover:bg-[#3b5998] transition-all duration-300">
<i class="fa fa-facebook text-slate-400 group-hover:text-white"></i>
</a>
<a href="https://twitter.com/ipsolin" class="w-10 h-10 rounded-full bg-slate-800 flex items-center justify-center group hover:bg-[#1da1f2] transition-all duration-300">
<i class="fa fa-twitter text-slate-400 group-hover:text-white"></i>
</a>
<a href="https://www.instagram.com/ipsolutionscisco/" class="w-10 h-10 rounded-full bg-slate-800 flex items-center justify-center group hover:bg-[#c32aa3] transition-all duration-300">
<i class="fa fa-instagram text-slate-400 group-hover:text-white"></i>
</a>
</div>
</div>
</div>
<div class="border-t border-gray-800 mt-12 pt-8 text-center text-sm text-gray-500">
<p>© <?php echo date('Y'); ?> IP SOLUTIONS. All Rights Reserved.</p>
</div>
</div>
</footer>