<?php
require_once 'config.php';
?>

<div class="container-fluid footer py-5 wow fadeIn" data-wow-delay="0.2s">
            <div class="container py-5">
                <div class="row g-5">
                    <!-- <div class="col-md-6 col-lg-6 col-xl-3">
                        <div class="footer-item d-flex flex-column">
                            <div class="footer-item">
                                <h4 class="text-white mb-4">Newsletter</h4>
                                <p class="mb-3">Dolor amet sit justo amet elitr clita ipsum elitr est.Lorem ipsum dolor sit amet, consectetur adipiscing elit consectetur adipiscing elit.</p>
                                <div class="position-relative mx-auto">
                                    <input class="form-control w-100 py-3 ps-4 pe-5" type="text" placeholder="Enter your email">
                                    <button type="button" class="btn btn-secondary position-absolute top-0 end-0 py-2 mt-2 me-2">SignUp</button>
                                </div>
                            </div>
                        </div>
                    </div> -->
                    <div class="col-md-6 col-lg-6 col-xl-3">
                        <div class="footer-item d-flex flex-column">
                            <h4 class="text-white mb-4">
                                <?php echo $engValue =='ENG'?'Explore': 'Explorer' ?>
                                
                            </h4>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'Home': 'Accueil' ?> </a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'Services': 'Services' ?></a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'About Us': 'À propos de nous' ?></a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'Latest Projects': 'Derniers Projets' ?></a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'Testimonial': 'Témoignage' ?></a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'Our Team': 'Notre Équipe' ?></a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i><?php echo $engValue =='ENG'?'Contact Us': 'Contactez-nous' ?></a>
                            
                             <a href="https://mail.zoho.com/zm" target="_blank" rel="noopener noreferrer"><i class="fas fa-angle-right me-2"></i>Email</a>
                             
                             
                            
                           
                            
                            
                        </div>
                    </div>
                    <div class="col-md-6 col-lg-6 col-xl-3">
                        <div class="footer-item d-flex flex-column">
                            <h4 class="text-white mb-4">
                                <?php echo $engValue =='ENG'?'Our Services': 'Nos services' ?>
                            </h4>



<?php

if (isset($_POST['lang'])) {
    $_SESSION['lang'] = $_POST['lang'];
    $engValue = $_POST['lang']; // Store in variable too
} elseif (isset($_SESSION['lang'])) {
    $engValue = $_SESSION['lang']; // Restore from session
}

try {

    $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8", DB_USER, DB_PASS);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Get the language column (default to ENG)
    $column = isset($_GET['lang']) ? $_GET['lang'] : 'ENG';

    // Whitelist allowed columns
    $allowed_columns = ['ENG', 'FRE'];
    if (!in_array($column, $allowed_columns)) {
        die("Invalid column name.");
    }

    
//echo 'Eng value:'.$engValue;
    // Safe query
    $stmt = $pdo->prepare("SELECT `$engValue` FROM system_params WHERE PARAM_TYPE = :param_type");
    $stmt->execute(['param_type' => 'core_bus']);

    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);

    if ($results) {
        
        foreach ($results as $row) {
            //echo "<li>" . htmlspecialchars($row[$column]) . "</li>";
            echo "<a href=\"#\"><i class=\"fas fa-angle-right me-2\"></i> ". htmlspecialchars($row[$engValue]) ."</a>";
        }
        
    } else {
        echo "No records found.";
    }
} catch (PDOException $e) {
    echo "Database error: " . $e->getMessage();
}
?>





                            <!-- <a href="#"><i class="fas fa-angle-right me-2"></i> General Construction</a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i> Property Maintenance</a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i> Project Managment</a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i> Virtual Design & Build</a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i> Residential Construction</a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i> Preconstruction</a>
                            <a href="#"><i class="fas fa-angle-right me-2"></i> Design Build</a> -->



                        </div>
                    </div>
                    <div class="col-md-6 col-lg-6 col-xl-3">
                        <div class="footer-item d-flex flex-column">
                            <h4 class="text-white mb-4">
                                
                                <?php echo $engValue =='ENG'?'Contact Info': 'Informations de contact' ?>
                            </h4>
                            <a href=""><i class="fa fa-map-marker-alt me-2"></i>Av. Commerciale, RUBANGURA HOUSE, 5th Floor </a>
                            <a href=""><i class="fas fa-envelope me-2"></i>info@strongconstructions.rw/strongconstructions@yahoo.fr</a>
                            <!-- <a href=""><i class="fas fa-envelope me-2"></i> info@example.com</a> -->
                            <a href=""><i class="fas fa-phone me-2"></i>+250 788307079/788487258</a>
                            
                            <div class="footer-btn d-flex align-items-center">
                                <a class="btn btn-secondary btn-md-square me-2" href=""><i class="fab fa-facebook-f text-white"></i></a>
                                <a class="btn btn-secondary btn-md-square me-2" href=""><i class="fab fa-twitter text-white"></i></a>
                                <a class="btn btn-secondary btn-md-square me-2" href=""><i class="fab fa-instagram text-white"></i></a>
                                <a class="btn btn-secondary btn-md-square me-0" href=""><i class="fab fa-linkedin-in text-white"></i></a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>