File "index.php"

Full Path: /home/custbahd/tourismfraternity.com/add-listing/add/1/index.php
File size: 26.49 KB
MIME-type: text/x-php
Charset: utf-8

<?php
session_start();
include_once('../../../admin/db/saucerer.php');

if (empty($_GET['url'])) {
  header('location:../../');
} else {
$url = $_GET['url'];
}

$sql = "SELECT count(*) FROM listings WHERE url='$url'"; 

$result = $conn->query($sql); 

while($row = mysqli_fetch_array($result)) { 

       if ($row['count(*)']==0) {
          header('location:../../');
        } 
    }

$sql = "SELECT count(*) FROM listings WHERE cat='Hospitality Facility' AND sub_type='' AND url='$url' OR cat='Tourist Attraction' AND sub_type='' AND url='$url' OR cat='Important Stakeholder' AND sub_type='' AND url='$url' OR cat='Tour Guide' AND gender='' AND url='$url'"; 

$result = $conn->query($sql); 

while($row = mysqli_fetch_array($result)) { 

       if ($row['count(*)']==0) {
          header('location:../../');
        } 
    }

?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    
    <title>Add Listing | Tourism Fraternity Network &copy;</title>


    <meta name="description" content="A premier online listing for businesses and travelers">

    <meta name="keywords" content="">

    <link rel="shortcut icon" type="image/x-icon" href="../../../assets/images/favicon.png" />
    
    <!-- Plugin css -->
    <link rel="stylesheet" type="text/css" href="../../../assets/css/font-awesome.min.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/fonts/flaticon.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/bootstrap.min.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/animate.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/swiper.min.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/lightcase.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/jquery.nstSlider.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/flexslider.css" media="all" />

    <!-- own style css -->
    <link rel="stylesheet" type="text/css" href="../../../assets/css/style.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/rtl.css" media="all" />
    <link rel="stylesheet" type="text/css" href="../../../assets/css/responsive.css" media="all" />  

    <!--Animations-->
    <link rel="stylesheet" type="text/css" href="../../../assets/css/animations/style.css"> 

    <!--Fontawesome 6-->
    <link href="../../../assets/css/fontawesome/css/all.css" rel="stylesheet">

    <link href="../../../admin/css/datatable/dataTable.bootstrap.min.css" rel="stylesheet">  


    <style type="text/css">

.popup img{
	margin-top: 25px;
	width: 400px;
	height: 250px;
	object-fit: cover;
}
.popup h3{
  text-transform: uppercase;
  font-size: 18px;
  margin-top: 10px;
  color: #000000;
}
.popup h3 span{
  display: block;
  font-weight: normal;
  font-size: 14px;
  margin-top: 10px;
}
.popup p{
    font-size: 14px;
    text-align: center;
    margin: 20px 0;
    line-height: 25px;
}
.popup a{
    display: block;
    position: relative;
    margin: 5px;
    text-align: center;
    background-color: #53a92c;
    color: #ffffff;
    text-decoration: none;
    padding: 8px 0;
    transition: 0.5s;
}
.popup a:hover{
    background-color: #F7970F;
}
.popup a.popup-link{
    display: inline-block;
    padding: 8px 30px;
}

    </style>

</head>

<body>


    <!-- Start Pre-Loader-->
    <div id="loading">
        <div id="loading-center">
            <div id="loading-center-absolute">
                <div class="object" id="object_one"></div>
                <div class="object" id="object_two"></div>
                <div class="object" id="object_three"></div>
                <div class="object" id="object_four"></div>
            </div>
        </div>
    </div>
    <!-- End Pre-Loader -->


    <div class="box-layout">
        
        <header class="header-style-1">
            <div class="bg-header-top d-lg-none">
                <div class="container">
                    <div class="row">
                        <div class="header-top">
                            <div class="row">
                                <div class="col-lg-3 col-12">
                                    <div class="d-flex flex-wrap justify-content-between">
                                        <a href="../../../"><img src="../../../assets/images/logo/2.png" alt="logo" class="img-responsive" /></a>
                                        <button type="button" class="navbar-toggler collapsed d-lg-none" data-bs-toggle="collapse" data-bs-target="#bs-example-navbar-collapse-1" aria-controls="bs-example-navbar-collapse-1" aria-expanded="false">
                                            <span class="navbar-toggler-icon">
                                                <i class="fa fa-bars"></i>
                                            </span>
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- .bg-header-top -->

            <!-- Start Menu -->
            <div class="bg-main-menu menu-scroll">
                <div class="container">
                    <div class="row">
                        <div class="main-menu p-0">
                            <div class="main-menu-bottom">
                                <div class="main-menu-area w-100">
                                    <div class="navbar-collapse collapse" id="bs-example-navbar-collapse-1">
                                        <a href="../../../" class="d-none d-lg-block"><img src="../../../assets/images/logo/1.png" alt="logo" class="img-responsive" /></a>
                                        <ul>
                                            <li><a href="../../../" class="active">HOME</a></li>
                                            <li>
                                                <a href="#">Listings</a>
                                                <ul class="sub-menu">
                                                    <li><a href="../../../listings/tour-operators"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Operators/ Companies</a></li>
                                                    <li><a href="../../../listings/tour-guides"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Guides</a></li>
                                                    <li>
                                                        <a href="#"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Hospitality Facilities</a>
                                                        <ul class="sub-sub-menu">
                                                            <li><a href="../../../listings/hospitality-facilities/hotels"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Hotels</a></li>
                                                            <li><a href="../../../listings/hospitality-facilities/motels"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Motels</a></li>
                                                            <li><a href="../../../listings/hospitality-facilities/lodges"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Lodges</a></li>
                                                            <li><a href="../../../listings/hospitality-facilities/restaurants"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Restaurants</a></li>
                                                            <li><a href="../../../listings/hospitality-facilities/night-clubs"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Night Clubs</a></li>
                                                        </ul>
                                                    </li>
                                                    <li><a href="../../../listings/travel-agencies"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Travel Agencies</a></li>
                                                    <li>
                                                        <a href="#"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tourist Attractions</a>
                                                        <ul class="sub-sub-menu">
                                                            <li><a href="../../../listings/tourist-attractions/national-parks"><i class="fa fa-angle-double-right" aria-hidden="true"></i> National Parks</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/game-reserves"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Game Reserves</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/eco"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Eco</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/cultural"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Cultural</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/religious"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Religious</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/birding"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Birding</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/waters"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Waters</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/mountains"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Mountains</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/antiquities"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Antiquities</a></li>
                                                            <li><a href="../../../listings/tourist-attractions/others"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Others</a></li>
                                                        </ul>
                                                    </li>
                                                    <li>
                                                        <a href="#"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Important Stakeholders</a>
                                                        <ul class="sub-sub-menu">
                                                            <li><a href="../../../listings/important-stakeholders/ministries"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Ministries</a></li>
                                                            <li><a href="../../../listings/important-stakeholders/regulators"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Regulators</a></li>
                                                        </ul>
                                                    </li>
                                                </ul>
                                            </li>
                                            <li>
                                                <a href="#">Categories</a>
                                                <ul class="sub-menu">
                                                    <li><a href="../../../listings/hospitality-facilities"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Hotels/ Lodges</a></li>
                                                    <li><a href="../../../listings/tour-operators"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Operators</a></li>
                                                    <li><a href="../../../listings/tour-guides"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tour Guides</a></li>
                                                    <li><a href="../../../listings/travel-agencies"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Travel Agencies</a></li>
                                                    <li><a href="../../../listings/tourist-attractions"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Tourist Attractions</a></li>
                                                    <li><a href="../../../events"><i class="fa fa-angle-double-right" aria-hidden="true"></i> Events</a></li>
                                                </ul>
                                            </li>
                                            <li><a href="../../../blogs">Blogs</a></li>
                                            <li><a href="../../../about-us">About Us</a></li>
                                            <li><a href="../../../contact-us">contact Us</a></li>
                                        </ul>
                                        <div class="menu-right-option pull-right">
                                            <div class="cart-option">
                                                <div class="cart-icon">
                                                    <i class="fa fa-door-open" aria-hidden="true"></i>
                                                </div>
                                                <div class="cart-dropdown-menu">
                                                    <div class="cart-items">
                                                        <div class="cart-img">
                                                            <i class="fa fa-briefcase"></i>
                                                        </div>
                                                        <div class="cart-content">
                                                            <h6><a href="../../../businesses">For businesses</a></h6>
                                                        </div>
                                                        <div class="cart-btn">
                                                            <a href="../../../businesses"><i class="fa fa-angle-right" aria-hidden="true"></i></a>
                                                        </div>
                                                        <div class="clr"></div>
                                                    </div>
                                                    <div class="cart-items">
                                                        <div class="cart-img">
                                                            <i class="fa fa-car"></i>
                                                        </div>
                                                        <div class="cart-content">
                                                            <h6><a href="../../../travelers">For Travelers</a></h6>
                                                        </div>
                                                        <div class="cart-btn">
                                                            <a href="../../../travelers"><i class="fa fa-angle-right" aria-hidden="true"></i></a>
                                                        </div>
                                                        <div class="clr"></div>
                                                    </div>
                                                    <div class="checkout-btn">
                                                        <a href="../../../add-listing" class="btn btn-default"><i class="fa fa-circle-plus"></i>&nbsp; Add Listing</a>
                                                    </div>
                                                </div>
                                            </div>

                                            <div class="search-box">
                                                <i class="fa fa-search first_click" aria-hidden="true" style="display: block;"></i>
                                                <i class="fa fa-times second_click" aria-hidden="true" style="display: none;"></i>
                                            </div>
                                            <div class="donate-option">
                                                <a href="../../../add-listing">Add Listing &nbsp;&nbsp;<i class="fa fa-caret-right float-bounce-right" aria-hidden="true"></i></a>
                                            </div>
                                            <div class="search-box-text">
                                                <form action="../../../search/index.php" method="POST">
                                                    <input type="search" name="valueToSearch" id="all-search" placeholder="Search Here" required>
                                                    <input type="submit" name="search" class="username">
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </header>

        <!-- Start Page Header Section -->
        <section class="bg-page-header">
            <div class="page-header-overlay">
                <div class="container">
                    <div class="row">
                        <div class="page-header">
                            <div class="page-title">
                                <h2>Assign Listing</h2>
                            </div>
                            <!-- .page-title -->
                            <div class="page-header-content">
                                <ol class="breadcrumb">
                                    <li>Final Step</li>
                                </ol>
                            </div>
                            <!-- .page-header-content -->
                        </div>
                        <!-- .page-header -->
                    </div>
                    <!-- .row -->
                </div>
                <!-- .container -->
            </div>
            <!-- .page-header-overlay -->
        </section>


<div class="session_handler">
<?php
        if(isset($_SESSION['error'])){
          echo "<div class='alert alert-danger text-center'>
            <button class='close'>&times;</button>
            ".$_SESSION['error']."
          </div>";
          unset($_SESSION['error']);
        }
        if(isset($_SESSION['success'])){
          echo "<div class='alert alert-success text-center'>
            <button class='close'>&times;</button>
            ".$_SESSION['success']."
          </div>";
          unset($_SESSION['success']);
        }
      ?>
</div>


        <!-- Start Section -->

    <div align="center" class="popup">

<?php

        $sql = "SELECT * FROM listings WHERE cat='Hospitality Facility' AND url='$url' OR cat='Tourist Attraction' AND url='$url' OR cat='Important Stakeholder' AND url='$url' OR cat='Tour Guide' AND url='$url' ORDER BY id DESC";

    //use for MySQLi-OOP
    $query = $conn->query($sql);
    while($row = $query->fetch_assoc()){

      echo '<img src="../../../admin/listings/images/'.$row["image"].'" alt="'.$row["title"].'">';

      echo '<h3>'.$row["title"].' <span>'.$row["cat"].'</span></h3>';

      if ($row["cat"]=='Hospitality Facility') {
      echo '<p>Assign your listings below to their designated criterias.</p>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Hotel&url='.$row["url"].'" class="popup-link">Hotel</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Motel&url='.$row["url"].'" class="popup-link">Motel</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Lodge&url='.$row["url"].'" class="popup-link">Lodge</a>';
      echo '<a href="add/1/?id='.$row["id"].'&sub_type=Restaurant&url='.$row["url"].'" class="popup-link">Restaurant</a>';
      echo '<a href="add/1/?id='.$row["id"].'&sub_type=Night Club&url='.$row["url"].'" class="popup-link">Night Club</a>';
      echo "<hr>";
      }

      if ($row["cat"]=='Tourist Attraction') {
      echo '<p>Assign your listings below to their designated criterias.</p>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=National Park&url='.$row["url"].'" class="popup-link">National Parks</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Game Reserve&url='.$row["url"].'" class="popup-link">Game Reserves</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Eco&url='.$row["url"].'" class="popup-link">Eco</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Cultural&url='.$row["url"].'" class="popup-link">Cultural</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Religious&url='.$row["url"].'" class="popup-link">Religious</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Birding&url='.$row["url"].'" class="popup-link">Birding</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Waters&url='.$row["url"].'" class="popup-link">Waters</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Mountains&url='.$row["url"].'" class="popup-link">Mountains</a>';
      echo '<a href="add/1/?id='.$row["id"].'&sub_type=Antiquity&url='.$row["url"].'" class="popup-link">Antiquity</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Other&url='.$row["url"].'" class="popup-link">Others</a>';
      echo "<hr>";
      }

      if ($row["cat"]=='Important Stakeholder') {
      echo '<p>Assign your listings below to their designated criterias.</p>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Ministry&url='.$row["url"].'" class="popup-link">Ministry</a>';
      echo '<a href="1/?id='.$row["id"].'&sub_type=Regulator&url='.$row["url"].'" class="popup-link">Regulator</a>';
      echo "<hr>";
      }

      if ($row["cat"]=='Tour Guide') {
      echo '<p>Kindly assign your gender</p>';
      echo '<a href="2/?id='.$row["id"].'&gender=Male&url='.$row["url"].'" class="popup-link">Male</a>';
      echo '<a href="2/?id='.$row["id"].'&gender=Female&url='.$row["url"].'" class="popup-link">Female</a>';
      echo '<a href="2/?id='.$row["id"].'&gender=None&url='.$row["url"].'" class="popup-link">None</a>';
      echo "<hr>";
      }

  }

?>
</div>
        
        <!-- End Section -->


        <!-- Start Footer Section -->
        <footer>

            <div class="bg-footer-bottom">
                <div class="container">
                    <div class="row">
                        <div class="footer-bottom">
                    <div class="row">
                            <div class="col-lg-4 col-sm-4 col-12">
                                <ul class="social-icon-rounded">
                                <li><a href="#"><i class="fab fa-facebook" title="Facebook"></i></a></li>
                                <li><a href="#"><i class="fab fa-instagram" title="Instagram"></i></a></li>
                                <li><a href="#"><i class="fab fa-x-twitter" title="Twitter"></i></a></li>
                                <li><a href="#"><i class="fab fa-youtube-play" title="YouTube"></i></a></li>
                                </ul>
                            </div>
                            <!-- .social-box -->
                            <div class="col-lg-4 col-sm-4 col-12">
                                <p class="text-center"><a href="#">Tourism Fraternity</a> &copy; <script>document.write(new Date().getFullYear());</script>, All Rights Reserved.</p>
                            </div>
                            <!-- .copyright-txt -->
                            <div class="col-lg-4 col-sm-4 col-12">
                                <p style="font-size: 12px;color: #777;text-align: right;">Powered By <a href="#!" style="color: #777;">Custom Assist Inc<span class="flash">.</span></a></p>
                            </div>
                            <!-- .copyright-txt -->
                        </div>

                        </div>
                        <!-- .footer-bottom -->
                    </div>
                    <!-- .row -->
                </div>
                <!-- .container -->
            </div>
            <!-- .bg-footer-bottom -->

        </footer>
        <!-- End Footer Section -->


        <!-- Start Scrolling -->
        <div class="scroll-img"><i class="fa fa-angle-up" aria-hidden="true"></i></div>
        <!-- End Scrolling -->
    </div>

    <script type="text/javascript" src="../../../assets/js/jquery-2.2.3.min.js"></script>
    <script type="text/javascript" src="../../../assets/js/bootstrap.min.js"></script>
    <script type="text/javascript" src="../../../assets/js/jquery.easing.1.3.js"></script>
    <script type="text/javascript" src="../../../assets/js/jquery.waypoints.min.js"></script>
    <script type="text/javascript" src="../../../assets/js/jquery.counterup.min.js"></script>
    <script type="text/javascript" src="../../../assets/js/swiper.min.js"></script>
    <script type="text/javascript" src="../../../assets/js/plugins.isotope.js"></script>
    <script type="text/javascript" src="../../../assets/js/isotope.pkgd.min.js"></script>
    <script type="text/javascript" src="../../../assets/js/lightcase.js"></script>
    <script type="text/javascript" src="../../../assets/js/jquery.nstSlider.js"></script>
    <script type="text/javascript" src="../../../assets/js/jquery.flexslider.js"></script>
    <script type="text/javascript" src="../../../assets/js/custom.isotope.js"></script>
    <script type="text/javascript" src="../../../assets/js/custom.map.js"></script>
    <script type="text/javascript" src="../../../assets/js/custom.js"></script>

        <script src="../../../admin/js/datatable/jquery.dataTables.min.js"></script>
        <script src="../../../admin/js/datatable/dataTable.bootstrap.min.js"></script>



<script>
$(document).ready(function(){
  //inialize datatable
    $('#myTable').DataTable();

    //hide alert
    $(document).on('click', '.close', function(){
      $('.alert').hide();
    })
});
</script>


</body>

</html>