File manager

File manager - Edit - /home/custbahd/fitbora.net/blog/search/index.php

Back
<?php session_start(); include_once('../../admin/db/saucerer.php'); if (empty($_POST['valueToSearch'])) { header('location: ../'); } $result = mysqli_query($mysqli, "SELECT * FROM blogs ORDER BY id"); if(isset($_POST['search'])) { $valueToSearch = $_POST['valueToSearch']; // search in all table columns // using concat mysql function $query = "SELECT * FROM `blogs` WHERE CONCAT(`id`, `title`, `cat`, `topic`, `author`, `paragraph1`, `paragraph2`, `paragraph3`, `paragraph4`, `paragraph5`, `paragraph6`, `summ1`, `summ2`, `summ3`) LIKE '%".$valueToSearch."%'"; $search_result = filterTable($query); } else { $query = "SELECT * FROM `blogs` "; $search_result = filterTable($query); } // function to connect and execute the query function filterTable($query) { include("../../admin/db/search.php"); $filter_Result = mysqli_query($connect, $query); return $filter_Result; } ?> <!doctype html> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <link rel="icon" href="../../image/favicon/1.png" type="image/png"> <title>Search \| FitBora ©</title> <meta name="description" content="The fitness & wellness network"> <!-- Bootstrap CSS --> <link rel="stylesheet" href="../../css/bootstrap.css"> <link rel="stylesheet" href="../../vendors/linericon/style.css"> <link rel="stylesheet" href="../../css/font-awesome.min.css"> <link rel="stylesheet" href="../../vendors/owl-carousel/owl.carousel.min.css"> <link rel="stylesheet" href="../../vendors/bootstrap-datepicker/bootstrap-datetimepicker.min.css"> <link rel="stylesheet" href="../../vendors/nice-select/css/nice-select.css"> <link rel="stylesheet" href="../../vendors/owl-carousel/owl.carousel.min.css"> <!-- main css --> <link rel="stylesheet" href="../../css/style.css"> <link rel="stylesheet" href="../../css/responsive.css"> <!--Animations--> <link rel="stylesheet" type="text/css" href="../../css/animations/style.css"> <!--Fontawesome 6--> <link href="../../css/fontawesome/css/all.css" rel="stylesheet"> </head> <body> <!--================Header Area =================--> <header class="header_area"> <div class="container"> <nav class="navbar navbar-expand-lg navbar-light"> <!-- Brand and toggle get grouped for better mobile display --> <a class="navbar-brand logo_h" href="../../"><img src="../../image/logo.png" alt=""></a> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <!-- Collect the nav links, forms, and other content for toggling --> <div class="collapse navbar-collapse offset" id="navbarSupportedContent"> <ul class="nav navbar-nav menu_nav ml-auto"> <li class="nav-item"><a class="nav-link" href="../../">Home</a></li> <li class="nav-item active submenu dropdown"> <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Directories</a> <ul class="dropdown-menu"> <li class="nav-item"><a class="nav-link" href="../../listings">All Listings</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Gyms">Gyms</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Health Clubs">Health Clubs</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Spas">Spas</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Massage Parlors">Massage Parlors</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Physiotherapists">Physiotherapists</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Dance Clubs">Dance Clubs</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Sports Clubs">Sports Clubs</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Trainers">Trainers</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Dieticians">Dieticians</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Technicians">Technicians</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Consultants">Consultants</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Swimming Pools">Swimming Pools</a></li> <li class="nav-item"><a class="nav-link" href="../../listings/Equipment Suppliers">Equipment Suppliers</a></li> </ul> </li> <li class="nav-item submenu dropdown"> <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Categories</a> <ul class="dropdown-menu"> <li class="nav-item"><a class="nav-link" href="../../categories">All Categories</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Fitness">Fitness</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Wellness">Wellness</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Massage">Massage</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Steam Bath">Steam Bath</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Sauna">Sauna</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Dance">Dance</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Sports">Sports</a></li> <li class="nav-item"><a class="nav-link" href="../../categories/Experts">Experts</a></li> </ul> </li> <li class="nav-item"><a class="nav-link" href="../../blog">Blog</a></li> <li class="nav-item"><a class="nav-link" href="../../events">Events</a></li> <li class="nav-item"><a class="nav-link" href="../../about">About Us</a></li> <li class="nav-item"><a class="nav-link" href="../../contact">Contact Us</a></li> </ul> </div> </nav> </div> </header> <!--================Header Area =================--> <!--================Breadcrumb Area =================--> <section class="breadcrumb_area"> <div class="overlay bg-parallax" data-stellar-ratio="0.8" data-stellar-vertical-offset="0" data-background=""></div> <div class="container"> <div class="page-cover text-center"> <h2 class="page-cover-tittle">Search</h2> <ol class="breadcrumb"> <li><a href="../../">Home</a></li> <li class="active">Search</li> </ol> </div> </div> </section> <!--================Breadcrumb Area =================--> <!--================ Blog Area Start =================--> <section class="blog_area" id="there"> <div class="container"> <div class="row"> <div class="col-lg-8"> <div class="blog_left_sidebar"> <p class="text-center"> <?php $sql = "SELECT COUNT() FROM `blogs` WHERE CONCAT(`id`, `title`, `cat`, `topic`, `author`, `paragraph1`, `paragraph2`, `paragraph3`, `paragraph4`, `paragraph5`, `paragraph6`, `summ1`, `summ2`, `summ3`) LIKE '%".$valueToSearch."%'"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ if ($row['COUNT()']==0) { echo "No results found"; } elseif ($row['COUNT()']==1) { echo "".number_format($row['COUNT()'])." result for ".$valueToSearch.""; } else { echo "".number_format($row['COUNT()'])." results for ".$valueToSearch.""; } } ?> </p> <?php while($row = mysqli_fetch_array($search_result)):?> <?php echo '<article class="row blog_item">'; echo '<div class="col-md-3">'; echo '<div class="blog_info text-right">'; echo '<div class="post_tag">'; echo '<a href="../categories/?cat='.$row["cat"].'">'.$row["cat"].'</a>'; echo '</div>'; echo '<ul class="blog_meta list_style">'; echo '<li>'.$row["topic"].' <i class="fa fa-lightbulb ml-2"></i></li>'; echo '<li>'.$row["author"].' <i class="fa fa-user ml-2"></i></li>'; if ($row["web_link"]) { echo '<li><a href="'.$row["web_link"].'" class="text-underline">Link Available <i class="fa fa-link"></i> </a></li>'; } echo '<li>'.date("jS M, Y", strtotime($row["timestamp"])).' <i class="fa fa-calendar ml-2"></i></li>'; echo '</ul>'; echo '</div>'; echo '</div>'; echo '<div class="col-md-9">'; echo '<div class="blog_post">'; if ($row["image1"]) { echo '<img src="../../admin/blogs/images/'.$row["image1"].'" alt="'.$row["title"].' img">'; } echo '<div class="blog_details">'; echo '<a href="../single/?blog='.$row["code"].'"><h2>'.$row["title"].'</h2></a>'; echo '<p>'.$row["paragraph1"].'</p>'; echo '<a href="../single/?blog='.$row["code"].'" class="theme_btn button_hover">View More</a>'; echo '</div>'; echo '</div>'; echo '</div>'; echo '</article>'; ?> <?php endwhile;?> </div> </div> <div class="col-lg-4"> <div class="blog_right_sidebar"> <aside class="single_sidebar_widget search_widget"> <form action="../search/index.php" method="POST"> <div class="input-group"> <input type="search" name="valueToSearch" class="form-control" placeholder="Search Posts" required> <span class="input-group-btn"> <button class="btn btn-default" type="submit" name="search" value="Search"><i class="lnr lnr-magnifier"></i></button> </span> </div><!-- /input-group --> </form> <div class="br"></div> </aside> <aside class="single_sidebar_widget author_widget blogger_slider owl-carousel"> <?php $sql = "SELECT FROM bloggers WHERE deleted=''"; //use for MySQLi-OOP $query = $conn->query($sql); if($query->fetch_assoc()==0){ echo '<div align="center"> <i class="fa fa-user-circle mb-2" style="font-size: 100px;"></i> <h4>Blogger Names</h4> <p>Blogger Title</p> <div class="social_icon"> <a href="https://facebook.com"><i class="fab fa-facebook"></i></a> <a href="https://wa.me/instagram.com"><i class="fab fa-instagram"></i></a> <a href="https://x.com"><i class="fab fa-twitter"></i></a> <a href="https://linkedin.com"><i class="fab fa-linkedin"></i></a> <a href="https://wa.me/256746006066"><i class="fab fa-whatsapp"></i></a> </div> <p>Discover your next great find with our listing website. We connect you to the best deals, services & opportunities in one easy-to-navigate platform.</p> <div class="br"></div> </div>'; } ?> <?php $sql = "SELECT * FROM bloggers WHERE deleted='' ORDER BY id DESC"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo '<div align="center">'; echo '<img class="author_img rounded-circle mb-2" src="../../admin/bloggers/images/'.$row["image"].'" alt="'.$row["name"].'" width="120px">'; echo '<h4>'.$row["name"].'</h4>'; echo '<p>'.$row["title"].'</p>'; echo '<div class="social_icon">'; if ($row["facebook"]) { echo '<a href="'.$row["facebook"].'"><i class="fab fa-facebook"></i></a>'; } if ($row["instagram"]) { echo '<a href="'.$row["instagram"].'"><i class="fab fa-instagram"></i></a>'; } if ($row["twitter"]) { echo '<a href="'.$row["twitter"].'"><i class="fab fa-twitter"></i></a>'; } if ($row["linkedin"]) { echo '<a href="'.$row["linkedin"].'"><i class="fab fa-linkedin"></i></a>'; } if ($row["phone"]) { echo '<a href="https://wa.me/'.$row["phone"].'"><i class="fab fa-whatsapp"></i></a>'; } echo '</div>'; if ($row["description"]) { echo '<p>'.$row["description"].'</p>'; } echo '<div class="br"></div>'; echo '</div>'; } ?> </aside> <aside class="single_sidebar_widget popular_post_widget"> <h3 class="widget_title">Top Fitness Centres</h3> <?php $sql = "SELECT * FROM listings WHERE deleted='' ORDER BY id DESC LIMIT 4"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo '<div class="media post_item"> <img src="../../admin/listings/images/'.$row["image"].'" alt="post" width="100px"> <div class="media-body"> <a href="../../listings/1/?listing='.$row["url"].'"><h3>'.$row["title"].'</h3></a> <p>'.$row["sub"].'</p> </div> </div>'; } ?> <div class="br"></div> <a href="../../listings"><h3 class="widget_title text-uppercase">Discover More</h3></a> </aside> <aside class="single_sidebar_widget ads_widget"> <a href="#"><img class="img-fluid" src="../../image/blog/add.jpg" alt=""></a> <div class="br"></div> </aside> <aside class="single_sidebar_widget post_category_widget"> <h4 class="widget_title">Categories</h4> <ul class="list_style cat-list"> <?php $sql = "SELECT COUNT(), cat FROM blogs WHERE deleted='' GROUP BY cat ORDER BY id DESC"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo '<li> <a href="../categories/?cat='.$row["cat"].'" class="d-flex justify-content-between"> <p>'.$row["cat"].'</p> <p>'.$row["COUNT()"].'</p> </a> </li>'; } ?> </ul> <div class="br"></div> </aside> <aside class="single-sidebar-widget newsletter_widget"> <h4 class="widget_title">Newsletter</h4> <p class="text-bottom">Register your email and receive our latest updates</p> <form method="POST"> <div class="form-group d-flex flex-row"> <div class="input-group"> <div class="input-group-prepend"> <div class="input-group-text"><i class="fa fa-envelope" aria-hidden="true"></i></div> </div> <div class="username"><input type="text" class="form-control" id="username" name="username" value=""></div> <input type="text" class="form-control" name="email" id="email" placeholder="Email Address"> </div> <button type="submit" name="newsletter" id="newsletter" class="bbtns border-0">Subcribe</button> </div> </form> <p class="text-bottom message_box">You can unsubscribe at any time</p> <div class="br"></div> </aside> <aside class="single-sidebar-widget tag_cloud_widget"> <h4 class="widget_title">Tag Clouds</h4> <ul class="list_style"> <?php $sql = "SELECT COUNT(), topic FROM blogs WHERE deleted='' GROUP BY topic ORDER BY id DESC"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo '<li><a href="../topics/?topic='.$row["topic"].'">'.$row["topic"].'</a></li>'; } ?> </ul> </aside> </div> </div> </div> </div> </section> <!--================ Blog Area End =================--> <!--================ start footer Area =================--> <footer class="footer-area section_gap"> <div class="container"> <div class="row"> <div class="col-lg-4 col-md-12 col-sm-12 col-12"> <div class="single-footer-widget"> <h6 class="footer_title">Overview</h6> <p>FitBora is a premier online listing designed to connect fitness and wellness enthusiasts with the best gyms and fitness facilities in their area. Our comprehensive listing platform offers an extensive range of options, from high-end luxury fitness clubs to budget-friendly community gyms, spas and health clubs - ensuring there’s something for everyone.</p> </div> </div> <div class="col-lg-2 col-md-3 col-sm-3 col-6"> <div class="single-footer-widget"> <h6 class="footer_title">Locations</h6> <ul class="list_style"> <?php $sql = "SELECT COUNT(), district, image FROM listings WHERE deleted='' GROUP BY district ORDER BY id DESC LIMIT 5"; //use for MySQLi-OOP $query = $conn->query($sql); while($row = $query->fetch_assoc()){ echo '<li><a href="../../districts/ug/?district='.$row["district"].'"><i class="fa fa-angle-right"></i> '.$row["district"].'</a></li>'; } ?> </ul> </div> </div> <div class="col-lg-2 col-md-3 col-sm-3 col-6"> <div class="single-footer-widget"> <a href="../../categories"><h6 class="footer_title">Categories</h6></a> <ul class="list_style"> <li><a href="../../categories/Fitness"><i class="fa fa-angle-right"></i> Fitness</a></li> <li><a href="../../categories/Wellness"><i class="fa fa-angle-right"></i> Wellness</a></li> <li><a href="../../categories/Massage"><i class="fa fa-angle-right"></i> Massage</a></li> <li><a href="../../categories/Steam Bath"><i class="fa fa-angle-right"></i> Steam Bath</a></li> <li><a href="../../categories/Experts"><i class="fa fa-angle-right"></i> Experts</a></li> </ul> </div> </div> <div class="col-lg-2 col-md-3 col-sm-3 col-6"> <div class="single-footer-widget"> <h6 class="footer_title">Interact With</h6> <ul class="list_style"> <li><a href="../../listings/Trainers"><i class="fa fa-angle-right"></i> Trainers</a></li> <li><a href="../../listings/Dieticians"><i class="fa fa-angle-right"></i> Dieticians</a></li> <li><a href="../../listings/Technicians"><i class="fa fa-angle-right"></i> Technicians</a></li> <li><a href="../../listings/Consultants"><i class="fa fa-angle-right"></i> Consultants</a></li> <li><a href="../../listings/Physiotherapists"><i class="fa fa-angle-right"></i> Physiotherapists</a></li> </ul> </div> </div> <div class="col-lg-2 col-md-3 col-sm-3 col-6"> <div class="single-footer-widget"> <h6 class="footer_title">Quick Links</h6> <ul class="list_style"> <li><a href="../../blog"><i class="fa fa-angle-right"></i> Blogs</a></li> <li><a href="../../events"><i class="fa fa-angle-right"></i> Events</a></li> <li><a href="../../about"><i class="fa fa-angle-right"></i> About Us</a></li> <li><a href="../../contact"><i class="fa fa-angle-right"></i> Contact Us</a></li> <li><a href="../../listings"><i class="fa fa-angle-right"></i> Directories</a></li> </ul> </div> </div> </div> <div class="border_line"></div> <div class="row footer-bottom d-flex justify-content-between align-items-center"> <div class="col-lg-3 col-sm-12 footer-social"> <a href="https://facebook.com/fitbora"><i class="fab fa-facebook"></i></a> <a href="https://x.com/fitbora"><i class="fab fa-x-twitter"></i></a> <a href="https://instagram.com/fitbora"><i class="fab fa-instagram"></i></a> <a href="https://wa.me/256772434328"><i class="fab fa-whatsapp"></i></a> </div> <p class="col-lg-6 col-sm-12 footer-text m-0 text-center"> <a href="#">Fitbora</a> © <script>document.write(new Date().getFullYear());</script>, All Rights Reserved<span class="flash">.</span></p> <p class="col-lg-3 col-sm-12 footer-text m-0 text-center" style="font-size: 12px;">Powered by <a href="https://camonitor.online" target="_blank" style="color: #82848f;">Custom Assist Inc<span class="flash">.</span></a></p> </div> </div> </footer> <!--================ End footer Area =================--> <!-- Optional JavaScript --> <!-- jQuery first, then Popper.js, then Bootstrap JS --> <script src="../../js/jquery-3.2.1.min.js"></script> <script src="../../js/popper.js"></script> <script src="../../js/bootstrap.min.js"></script> <script src="../../vendors/owl-carousel/owl.carousel.min.js"></script> <script src="../../js/jquery.ajaxchimp.min.js"></script> <script src="../../js/mail-script.js"></script> <script src="../../vendors/bootstrap-datepicker/bootstrap-datetimepicker.min.js"></script> <script src="../../vendors/nice-select/js/jquery.nice-select.js"></script> <script src="../../js/mail-script.js"></script> <script src="../../js/stellar.js"></script> <script src="../../vendors/lightbox/simpleLightbox.min.js"></script> <script src="../../js/custom.js"></script> <script src="../../js/video-on-scroll.js"></script> <script> $(document).ready(function() { var delay = 500; $('#newsletter').click(function(e){ e.preventDefault(); var username = $('#username').val(); var newsletter = $('#newsletter').val(); var email = $('#email').val(); if(email == ''){ $('.message_box').html( '<span style="color:#F7931D;">Enter an email address!</span>' ); $('#email').focus(); return false; } if( $("#email").val()!='' ){ if( !isValidEmailAddress( $("#email").val() ) ){ $('.message_box').html( '<span style="color:#F7931D;">Provided email address is incorrect!</span>' ); $('#email').focus(); return false; } } $.ajax ({ type: "POST", url: "../../contact/newsletters/index.php", data: "email="+email+"&username="+username+"&newsletter="+newsletter, beforeSend: function() { $('.message_box').html( '<div align="center"><img src="../../image/ajax.gif" width="25" height="25"/></div>' ); }, success: function(data) { setTimeout(function() { $('.message_box').html(data); }, delay); } }); }); }); //Email validation Function function isValidEmailAddress(emailAddress) { var pattern = /^([a-z\d!#$%&'+\-\/=?^_`{\|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+(\.[a-z\d!#$%&'+\-\/=?^_`{\|}~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]+)\|"((([ \t]\r\n)?[ \t]+)?([\x01-\x08\x0b\x0c\x0e-\x1f\x7f\x21\x23-\x5b\x5d-\x7e\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]\|\\[\x01-\x09\x0b\x0c\x0d-\x7f\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))(([ \t]\r\n)?[ \t]+)?")@(([a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]\|[a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.)+([a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]\|[a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\d\-._~\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF][a-z\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])\.?$/i; return pattern.test(emailAddress); }; </script> </body> </html>

| ver. 1.4 | Github | . | PHP 8.1.33 | Generation time: 1.35 | proxy | phpinfo | Settings