search with multiple fields in php

<?php
  include_once('common/header.php');

$search='';   
$search=$_REQUEST['search'];
$category=$_REQUEST['category'];
$location=$_REQUEST['location'];

//$sql1="SELECT `listing`.*, listing_category.cat_id, listing_category.categoryslug from `listing` left join listing_category on listing.category_id=listing_category.cat_id WHERE listing.listing_title LIKE '%".$search."%' AND listing_category.categoryslug LIKE '%".$category."%' AND listing.business_address LIKE '%".$location."%' order by listing.date_added DESC";

$sql1="SELECT `listing`.*, listing_category.cat_id, listing_category.categoryslug from `listing` left join listing_category on listing.category_id=listing_category.cat_id WHERE listing.listing_title LIKE '%".$search."%' AND listing_category.categoryslug LIKE '%".$category."%' AND (listing.business_address LIKE '%".$location."%' OR listing.city LIKE '%".$location."%') order by listing.date_added DESC";



$r_query = mysqli_query($con,$sql1);

$num_row=mysqli_num_rows($r_query);

if($num_row > 0)
{
while ($row = mysqli_fetch_array($r_query)){ 
echo $row['listing_title'];
echo '<br>';
 
}
}
else
{
  echo 'No Records Found';
}
?>

Comments

Post a Comment

Popular posts from this blog

dynamic create multiple ckeditor onclick event using jquery

<!DOCTYPE html> <html> <head> <title>New Ckeditor Instance Dynamically</title> <script type="text/javascript" src="ckeditor_3.5/ckeditor/ckeditor.js"></script> <script type="text/javascript" src="scripts/jquery-1.4.4.js"></script> <script type="text/javascript" src="ckeditor_3.5/ckeditor/adapters/jquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $('.jquery_ckeditor').ckeditor(); }); </script> <script> function newCkeditor(){ $('<div><textarea><\/textarea><\/div>') .appendTo('#body').find('textarea').ckeditor(); } function clicked(){ for ( instance in CKEDITOR.instances ){ alert("ckeditor values : " + CKEDITOR.instances[instance].getData()); } } </script> </head> <body...
Read more

get lat and long from city name using jquery

<html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>     <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false"></script> </head> <body>    <?php $city='indore'; ?>     <input id="btn" type="button" value="search for miami coordinates" />     <input type="hidden" class="cityName" name="cityName" value="<?php echo $city; ?>" />     <script> jQuery(document).ready(function($){ var cityName=$('.cityName').val();             var geocoder =  new google.maps.Geocoder();     geocoder.geocode( { 'address': cityName}, function(results, status) {           if (status == google.maps.GeocoderStatus.OK) {             alert("location : " + results[0].geometry.location.lat() +...
Read more

membership registration and login system in php

<?php include_once('header.php'); ?> <?php ob_start(); $message=''; $message1=''; $error=''; $firstnameError=''; $lastnameError=''; $usernameError=''; $emailError=''; $phoneError=''; $passwordError=''; $firstname = $lastname = $username =  $password = $phone = $email = ''; if(isset($_POST['membership_registration'])) { $status=0; $date_added = date('Y-m-d H:i:s'); if(!empty($_POST['membership_firstname']))   {     $firstname = mysqli_real_escape_string($con, $_POST['membership_firstname']);   }   else   {     $firstnameError='First Name is Required';   }   if(!empty($_POST['membership_lastname']))   {     $lastname = mysqli_real_escape_string($con, $_POST['membership_lastname']);   }   else   {     $lastnameError='Last Name is Required';   } if(!empty($_POST['membership_usern...
Read more