MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.83
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0750) :  /home2/imyrqtmy/public_html/leadriding/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/public_html/leadriding/search1.php
<?php

extract($_POST);

// print_r($_POST);
 @$seval = $_POST['ser'];

$l = explode(',', $seval);
// $numbers_array = preg_split("/[\s,]+/", $seval);

// $l = array_filter($numbers_array);


// print_r($l);
?>

<!DOCTYPE html>

<html lang="en">



<?php include 'include/head.php'; 


$sl1 = "SELECT * FROM `tbl_sub_category` where id='$cate'";
                                                $sls1 = mysqli_query($con, $sl1) or die(mysqli_error($con));
                                                $sls_s1 = mysqli_fetch_assoc($sls1); 

?>

<style type="text/css">

		.breadcrumb-bar {

    background-image: url(Admin/subcategories/<?php echo $sls_s1['banner']; ?>);

        background-size: 100% 100%;

        height: 260px;

}

.t-t{

	background-color: #fff;

    margin-top: 101px;

    font-size: 23px;

    color: #000;

    font-weight: 500;

    opacity: 0.6;

}

.t-t:hover{

	background-color: #fff;

	

	    color: #000;

}



@media only screen and (max-width: 767.98px) {





.t-t {

  background-color: #fff;

  margin-top: 173px;

  font-size: 27px;

  color: #000;

  font-weight: 500;

  float: left;

  opacity: 0.6;

}

}

</style>

<body>



	

	<div class="main-wrapper">

	

		<!-- Header -->

		<?php include 'include/header.php'; ?>

		<!-- /Header -->

		

		

		<div class="bg-img">

			<img src="assets/img/bg/work-bg-03.png" alt="img" class="bgimg1">

			<img src="assets/img/bg/work-bg-03.png" alt="img" class="bgimg2">

			<img src="assets/img/bg/feature-bg-03.png" alt="img" class="bgimg3">

		</div>

		

		<!-- Breadcrumb -->

		<div class="breadcrumb-bar">

			<div class="container">

				<div class="row">

					<div class="col-md-12 col-12">

						<!-- <h2 class="breadcrumb-title">Category Name</h2> -->

						<!-- <nav aria-label="breadcrumb" class="page-breadcrumb">

							<ol class="breadcrumb">

								<li class="breadcrumb-item"><a href="index.php">Home</a></li>

								<li class="breadcrumb-item active" aria-current="page">Category Name</li>

							</ol>

						</nav> -->

					</div>



					<div class="col-md-4">

						<span class="item-cat t-t"><?php echo $sls_s1['name']; ?></span>

					</div>

				</div>

			</div>

		</div>

		<!-- /Breadcrumb -->	

		

		<div class="content ">

			<div class="container">

				

				<div class="row">

					<div class="col-md-1"></div>

					<div class="col-md-10">

						<!-- Booking Lis t -->

					

						<!-- /Booking List -->

						

						<!-- Booking List -->
						
							<?php
							
							// $i=0;
// 							$sqls = "select * from tbl_vendore  where(";
//  foreach($l as $val)
// {
                                                   
                                                        


// if($i==0) {
//                  $sqls.=" (`address` LIKE '%$val%' OR `city` LIKE '%$val%')   ";
//             }
//           else {
//               $sqls.=" or (`address` LIKE '%$val%' OR `city` LIKE '%$val%')  ";
//           }
          
// $i++;
// }          
//              $sr =  "$sqls) and status='1' and FIND_IN_SET('$cate', sub_categorie) ORDER BY RAND() ";
		
$sqls = "select * from tbl_vendore  where(";
 foreach($l as $val)
{
                                                   
                                                        


if($i==0) {
                 $sqls.=" (`working_area` LIKE '%$val%' )   ";
            }
          else {
              $sqls.=" or (`working_area` LIKE '%$val%' )  ";
          }
          
$i++;
}          
             $sr =  "$sqls) and status='1' and FIND_IN_SET('$cate', sub_categorie) ORDER BY RAND() ";
							
							
                                                $count = 1;
                                                // $sc3 = "SELECT * FROM `tbl_vendore` where (`address` LIKE '%$val%' OR `city` LIKE '%$val%') and status='1' and  sub_categorie='$cate' ";
                                                $scs3 = mysqli_query($con, $sr) or die(mysqli_error($con));
                                                $rows = mysqli_num_rows($scs3);
                                                 if($rows>0)
                                                {
                                                  while ($scs_c3 = mysqli_fetch_assoc($scs3)){ 
                                                   
                                                   
                                                    
                                                    ?>

						<div class="booking-list">

							<div class="booking-widget">

								<div class="booking-img">

									<a href="provider-details.php?id=<?php echo $scs_c3['id']; ?>&subid=<?php echo $cate; ?>">

										<img src="vendor/<?php echo $scs_c3['profile_photo']; ?>" alt="User Image" style="height:160px;">

									</a>

									

								</div>

								<div class="booking-det-info ">

									<h3>

										<a href="provider-details.php?id=<?php echo $scs_c3['id']; ?>&subid=<?php echo $cate; ?>"><?php echo $scs_c3['cname']; ?></a>&nbsp; <img src="assets/img/verified_2x.gif" style="height: 35px;">

									</h3>

									<ul class="booking-details">

									<li><span class="book-item">Location</span> : <?php echo $scs_c3['working_area']; ?></li>

										<li>

											<span class="book-item">Timings</span> : <?php echo $scs_c3['time']; ?>

										</li>

										<!-- <li><span class="book-item">Amount</span> : $50.00 <span class="badge-grey">COD</span></li> -->

										

										<li>

											<span class="book-item">Services</span> : 

                                            <?php 
                                            
                                            $sc = $scs_c3['sub_categorie'];

										$shapse = explode(",", $sc);
							            $p = 0;
								        $r = count($shapse);
								
								            
										    for ($x = 0; $x <= $r; $x++) {
										        if($p <= '0'){
										    
										    $v = $shapse[$x];
										    $sl = "SELECT * FROM `tbl_sub_category` where id='$v'";
                                                $sls = mysqli_query($con, $sl) or die(mysqli_error($con));
                                                $sls_s = mysqli_fetch_assoc($sls); 
										    ?>
                                            
											<p><?php echo $sls_s['name']; ?>
											
											<?php
											if($x >= '1'){
											    echo '...';
											}?>
											</p>

										
											<?php  } else { } 
											$p++;
											 } ?>

										</li>

										<li>

										<a href="tel:<?php echo $scs_c3['phone']; ?>" class="btn btn-primary"><i class="fa fa-phone" aria-hidden="true"></i> <?php echo $scs_c3['phone']; ?> </a>

										<a href="https://api.whatsapp.com/send?phone=<?php echo $scs_c3['wh_no']; ?>&amp;text=Hello, I saw your profile on leadriding.com.  I want to talk about your service..." class="btn btn-success"><i class="fa fa-whatsapp" aria-hidden="true"></i> Whatsapp</a>

										</li>

									</ul>

								</div>

							</div>

							<div class="booking-action">

							    							    

                                

								<!-- <a href="javascript:void(0);" class="btn btn-primary"><i class="fa fa-phone" aria-hidden="true"></i>  +91-*******</a>

								<a href="javascript:void(0);" class="btn btn-success"><i class="fa fa-whatsapp" aria-hidden="true"></i> Whatsapp</a> -->

								<!-- <a href="javascript:void(0);" class="btn btn-secondary" data-bs-toggle="modal" data-bs-target="#add-review"><i class="feather-plus-circle"></i> Get a Quote</a> -->

								<div class="view-action mob_action">

								    <div class="crown" style="text-align: center;">

								                                            <img src="assets/img/crown.png" style="height: 35px;">



								    </div>

									<div class="rating">

										<i class="fas fa-star filled"></i>

										<i class="fas fa-star filled"></i>

										<i class="fas fa-star filled"></i>

										<i class="fas fa-star filled"></i>

										<i class="fas fa-star filled"></i>

									</div>

									<a href="provider-details.php" class="view-btn">View Details</a>

								</div>

							</div>

						</div>
						
						<?php }   
						                        }
						                        else{ ?>
						                        
						                        <p style="text-align: center;background: #E31E24;color: #fff;">No Vendor Found</p>
						                        
						                        <?php } ?>
						                        

						<!-- /Booking List -->

						

						<!-- Booking List -->

						<!--<div class="booking-list">-->

						<!--	<div class="booking-widget">-->

						<!--		<div class="booking-img">-->

						<!--			<a href="provider-details.php">-->

						<!--				<img src="assets/img/services/service-07.jpg" alt="User Image">-->

						<!--			</a>-->

						<!--			<div class="fav-item">-->

						<!--				<a href="javascript:void(0)" class="fav-icon">-->

						<!--					<i class="feather-heart"></i>-->

						<!--				</a>-->

						<!--			</div>-->

						<!--		</div>-->

						<!--		<div class="booking-det-info">-->

						<!--			<h3>-->

						<!--				<a href="provider-details.php">Vendor2</a>-->

						<!--			</h3>-->

						<!--			<ul class="booking-details">-->

						<!--				<li>-->

						<!--					<span class="book-item">Booking Date</span> : 27 Sep 2022, 17:00-18:00-->

						<!--				</li>-->

						<!--				<li><span class="book-item">Amount</span> : $50.00 <span class="badge-grey">COD</span></li>-->

						<!--				<li><span class="book-item">Location</span> : Washington, DC, USA</li>-->

						<!--				<li>-->

						<!--					<span class="book-item">Customer</span> : -->

						<!--					<div class="user-book">-->

						<!--						<div class="avatar avatar-xs">-->

						<!--							<img class="avatar-img rounded-circle" alt="User Image" src="assets/img/profiles/avatar-06.jpg">-->

						<!--						</div>-->

						<!--						Quentin-->

						<!--					</div>-->

						<!--					<p><a href="https://html.truelysell.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="e28b8c848da29397878c968b8ccc818d8f">[email&#160;protected]</a></p>-->

						<!--					<p>+1 601-810-9218</p>-->

						<!--				</li>-->

						<!--			</ul>-->

						<!--		</div>-->

						<!--	</div>-->

						<!--	<div class="booking-action">-->

						<!--		<a href="provider-chat.html" class="btn btn-primary"><i class="feather-message-square"></i> Chat</a>-->

						<!--		<a href="javascript:void(0);" class="btn btn-secondary">Cancel</a>-->

						<!--	</div>-->

						<!--</div>-->

						<!-- /Booking List -->

						

						<!-- Booking List -->

						<!--<div class="booking-list">-->

						<!--	<div class="booking-widget">-->

						<!--		<div class="booking-img">-->

						<!--			<a href="provider-details.php">-->

						<!--				<img src="assets/img/services/service-13.jpg" alt="User Image">-->

						<!--			</a>-->

						<!--			<div class="fav-item">-->

						<!--				<a href="javascript:void(0)" class="fav-icon">-->

						<!--					<i class="feather-heart"></i>-->

						<!--				</a>-->

						<!--			</div>-->

						<!--		</div>-->

						<!--		<div class="booking-det-info">-->

						<!--			<h3>-->

						<!--				<a href="provider-details.php">Vendor3</a> -->

						<!--			</h3>-->

						<!--			<ul class="booking-details">-->

						<!--				<li>-->

						<!--					<span class="book-item">Booking Date</span> : 27 Sep 2022, 17:00-18:00-->

						<!--				</li>-->

						<!--				<li><span class="book-item">Amount</span> : $375.00 <span class="badge-grey">COD</span></li>-->

						<!--				<li><span class="book-item">Location</span> : Virginia, USA</li>-->

						<!--				<li>-->

						<!--					<span class="book-item">Customer</span> : -->

						<!--					<div class="user-book">-->

						<!--						<div class="avatar avatar-xs">-->

						<!--							<img class="avatar-img rounded-circle" alt="User Image" src="assets/img/profiles/avatar-02.jpg">-->

						<!--						</div>-->

						<!--						Johnson-->

						<!--					</div>-->

						<!--					<p><a href="https://html.truelysell.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="82ebece4edc2e8edeaecf1edecace1edef">[email&#160;protected]</a></p>-->

						<!--					<p>+1 312-328-3970</p>-->

						<!--				</li>-->

						<!--			</ul>-->

						<!--		</div>-->

						<!--	</div>-->

						<!--	<div class="booking-action">-->

						<!--		<a href="provider-chat.html" class="btn btn-primary"><i class="feather-message-square"></i> Chat</a>-->

						<!--		<a href="javascript:void(0);" class="btn btn-secondary">Cancel</a>-->

						<!--	</div>-->

						<!--</div>-->

						<!-- /Booking List -->

						

						<!-- Booking List -->

					

						<!-- /Booking List -->

					</div>

					<div class="col-md-1"></div>

				</div>

				<?php include 'include/banner.php'; ?>

				<!-- Pagination -->

				

				<!-- /Pagination -->

				<div class="row">

					<div class="col-md-1"></div>

					<div class="col-md-10">

						<!-- Booking List -->

					

						<!-- /Booking List -->

						

						<!-- Booking List -->

					

						<!-- /Booking List -->

						

						<!-- Booking List -->

						

						<!-- /Booking List -->

						

						<!-- Booking List -->

					

						<!-- /Booking List -->

						

						<!-- Booking List -->

					

						<!-- /Booking List -->

					</div>

					<div class="col-md-1"></div>

				</div>

				

			</div>			

		</div>

		

		<!-- Footer -->

		<?php include 'include/footer.php'; ?>

		<!-- /Footer -->

		

		<!-- Cursor -->

		<div class="mouse-cursor cursor-outer"></div>

		<div class="mouse-cursor cursor-inner"></div>

		<!-- /Cursor -->

		

	</div>

	

	<!-- jQuery -->

	<script data-cfasync="false" src="../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script><script src="assets/js/jquery-3.6.1.min.js"></script>



	<!-- Bootstrap Core JS -->

	<script src="assets/js/bootstrap.bundle.min.js"></script>



	<!-- Fearther JS -->

	<script src="assets/js/feather.min.js"></script>



	<!-- Sticky Sidebar JS -->

	<script src="assets/plugins/theia-sticky-sidebar/ResizeSensor.js"></script>

	<script src="assets/plugins/theia-sticky-sidebar/theia-sticky-sidebar.js"></script>



	<!-- Rangeslider JS -->

	<script src="assets/plugins/ion-rangeslider/js/ion.rangeSlider.min.js"></script>

	<script src="assets/plugins/ion-rangeslider/js/custom-rangeslider.js"></script>



	<!-- Select2 JS -->

	<script src="assets/plugins/select2/js/select2.min.js"></script>

	<script src="assets/plugins/aos/aos.js"></script>

	

	<!-- Owl Carousel JS -->

	<script src="assets/js/owl.carousel.min.js"></script>

	

		<script src="assets/js/slick.js"></script>





	<!-- Custom JS -->

	<script src="assets/js/script.js"></script>

	  <script  src="https://maps.googleapis.com/maps/api/js?v=3.exp&libraries=places&key=AIzaSyB0F4Yf0ERMSt5OwSDyxHezMyLC9aeMM7E"></script>

	<script src="assets/js/location.js"></script>

</body>

</html>

MMCT - 2023