1#@!#!123s

: / home / u166148318 / domains / avrd.org / public_html / inc /
Filename : footer.php
back
<div class="footer">
    <div class="container">
        <div class="row">
            <div class="col-lg-3 col-md-6">
                <?php
                $sel = $conn->prepare("SELECT * FROM footer order by(id) DESC LIMIT 1 ");
                $sel->execute();
                $count = 0;
                $result = $sel->setFetchMode(PDO::FETCH_ASSOC);
                if ($row = $sel->fetch()) {
                ?>
                    <div class="footer-contact">
                        <h2>notre siège social</h2>
                        <p><i class="fa fa-map-marker-alt"></i><?php echo $row['location']; ?></p>
                        <p><i class="fa fa-phone-alt"></i><?php echo $row['phone_num']; ?></p>
                        <p><i class="fa fa-envelope"></i><?php echo $row['email']; ?></p>
                        <div class="footer-social">
                            <a class="btn btn-custom" href="<?php echo $row['twiter_url']; ?>" target="_blank"><i class="fab fa-twitter"></i></a>
                            <a class="btn btn-custom" href="<?php echo $row['fb_url']; ?>" target="_blank"><i class="fab fa-facebook-f"></i></a>
                            <a class="btn btn-custom" href="<?php echo $row['youtu_url']; ?>" target="_blank"><i class="fab fa-youtube"></i></a>
                            <a class="btn btn-custom" href="<?php echo $row['insta_url']; ?>" target="_blank"><i class="fab fa-instagram"></i></a>
                        </div>
                    </div>
            </div>
        <?php } ?>
        <div class="col-lg-3 col-md-6">
            <div class="footer-link">
                <h2>liens Populaires</h2>
                <a href="about.php">À-propos</a>
                <a href="causes.php">Réalisations</a>
                <a href="event.php">Événements à venir</a>
                <a href="volunteer.php">Devenir Bénévole</a>
                
            </div>
        </div>
        <div class="col-lg-3 col-md-6">
            <div class="footer-link">
                <h2>Liens utiles</h2>
                <a href="contact.php">Contacter Nous</a>
                <a href="contact.php">FQAs</a>
                <a href="partner.php">Nos Partenaires</a>
            </div>
        </div>
        <div class="col-lg-3 col-md-6">
            <div class="footer-newsletter">
                <h2>bulletin d'information</h2>
                <?php
                if (isset($_POST['submit'])) {


                    $email = $_POST['email'];


                    $insert_email = $conn->prepare("INSERT INTO `newsletter`(id, news_email) VALUES(?,?)");
                    $insert_email->execute([null, $email]);
                    if ($insert_email) {
                        echo "<font size='4px' padding='7px' color='white' text-align='center'>You are Now Part of Us.</font>";
                    } else {
                        echo "<font size='4px' padding='7px' color='red' text-align='center'>OOoops something went wrong, try again later.</font>";
                    }
                }
                ?>
                <form method="post">
                    <input class="form-control" placeholder="Votre Email va ici" name="email" required>
                    <button class="btn btn-custom" type="submit" name="submit">Envoyer</button>
                    <label>Don't worry, we don't spam!</label>
                </form>
            </div>
        </div>
        </div>
    </div>
    <div class="container copyright">
        <div class="row">
            <div class="col-md-6">
                <p>&copy; <a href="https://avrd.org/">avrd.org</a>, All Right Reserved.</p>
            </div>
            <div class="col-md-6">
                <p>Designed By <a href="https://wa.me/+256744578890">RUTECO</a></p>
            </div>
        </div>
    </div>
</div>