Re: [Jason] Search problem

Sat, 25 Aug 2012 10:40:38 -0700

Hi,

this work pretty fine, thanks. I have another question, how can i echo the search query(s) on results.php page i saw on multisearch some like

but this not work for me. How can i do that.

Cheers

Re: [Jason] Search problem

Tue, 07 Aug 2012 15:29:10 -0700

Hi,

with this code:

$where = "";   
     
  if (is_array(@$_REQUEST['oblast_grad'])) {   
     
    $where .= "("; 
    foreach ($_REQUEST['oblast_grad'] as $oblast_grad) {   
      $where .= " oblast_grad LIKE '%\t".mysql_escape($oblast_grad)."\t%' OR";   
    }   
       
    $where = rtrim($where, "OR") . ")";   
  }  
    
  if (is_array(@$_REQUEST['vid_na_imota'])) {   
     
    if ($where) { $where .= " AND "; } 
     
    $where .= "("; 
     
    foreach ($_REQUEST['vid_na_imota'] as $vid_na_imota) {   
      $where .= " vid_na_imota LIKE '%\t".mysql_escape($vid_na_imota)."\t%' OR";   
    }   
       
    $where = rtrim($where, "OR") .")"; 
     
  }  
   
 list($imotiRecords, $imotiMetaData) = getRecords(array(    
    'tableName'  =>  'imoti',    
    'orderBy'    =>   mysql_escape(@$_REQUEST['orderBy']),    
    'perPage'    =>  '2',   
    'where'      =>  $where,   
  )); $where = "";   
     
  if (is_array(@$_REQUEST['oblast_grad'])) {   
       
    foreach ($_REQUEST['oblast_grad'] as $oblast_grad) {   
      $where .= " oblast_grad LIKE '%\t".mysql_escape($oblast_grad)."\t%' OR";   
    }   
       
    $where = rtrim($where, "OR");   
  }  
    
  if (is_array(@$_REQUEST['vid_na_imota'])) {   
       
    foreach ($_REQUEST['vid_na_imota'] as $vid_na_imota) {   
      $where .= " vid_na_imota LIKE '%\t".mysql_escape($vid_na_imota)."\t%' OR";   
    }   
       
    $where = rtrim($where, "OR");   
  }  
   
   
 list($imotiRecords, $imotiMetaData) = getRecords(array(    
    'tableName'  =>  'imoti',    
    'orderBy'    =>   mysql_escape(@$_REQUEST['orderBy']),    
    'perPage'    =>  '2',   
    'where'      =>  $where, 
'debugSql' => true,  
  ));

the output:

SELECT SQL_CALC_FOUND_ROWS `imoti`.* FROM `cms_imoti` as `imoti` WHERE ( oblast_grad LIKE '% Troshevo %' OR oblast_grad LIKE '% Mladost %' vid_na_imota LIKE '% 1-room %' OR vid_na_imota LIKE '% 2-rooms %' ) LIMIT 2
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vid_na_imota LIKE '% 1-room %' OR vid_na_imota LIKE '% 2-rooms %' ) LIMIT 2' at line 3

Cheers

Re: [honolulu] Search problem

Tue, 07 Aug 2012 04:44:01 -0700

Hi,

is it possible in CMS builder to search in 2 or 3 multi value fields in the same time for example If i want to find 1 and 2 bedroom flat in Acton and Chelsie(London) and i give 120000 punds max price. This is my case, and should i use some real estate script which can do that?

Cheers

Re: [Jason] Search problem

Mon, 06 Aug 2012 14:34:03 -0700

Hi Jason,

i try your code, but i doesn`t work it show some:

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vid_na_imota LIKE '% 1-ÑÑ‚Ð°ÐµÐ½ %' ) LIMIT 2' at line 3.

This search thing is very important for the site, because it is based ot this search to find property that match their criteria for example from 2 different areas by 2 different types of homes in one town.

Cheers

Re: [honolulu] Search problem

Mon, 06 Aug 2012 10:38:49 -0700

Someone?

Re: [Jason] Search problem

Sat, 04 Aug 2012 16:14:12 -0700

Hi,

i try this, but it does not work:

two fields(multi values)
1 - oblast_grad
2 - vid_na_imota

  $where = ""; 
   
  if (is_array(@$_REQUEST['oblast_grad'])) { 
     
    foreach ($_REQUEST['oblast_grad'] as $oblast_grad) { 
      $where .= " oblast_grad LIKE '%\t".mysql_escape($oblast_grad)."\t%' OR"; 
    } 
     
    $where = rtrim($where, "OR"); 
  }
  
  if (is_array(@$_REQUEST['vid_na_imota'])) { 
     
    foreach ($_REQUEST['vid_na_imota'] as $vid_na_imota) { 
      $where .= " vid_na_imota LIKE '%\t".mysql_escape($vid_na_imota)."\t%' OR"; 
    } 
     
    $where = rtrim($where, "OR"); 
  }
 
 
 list($imotiRecords, $imotiMetaData) = getRecords(array(  
    'tableName'  =>  'imoti',  
    'orderBy'    =>   mysql_escape(@$_REQUEST['orderBy']),  
    'perPage'    =>  '2', 
    'where'      =>  $where, 
  ));

and search form:




Вид на имота


Квартал/Район

when chooce 1 option from vid_na_imota and 1 option from oblast_grad it does not do the search correct. Maybe my code is wrong :(

Re: [Jason] Search problem

Fri, 03 Aug 2012 03:17:48 -0700

Ok that works like a charm, but only for this multivalue field. How can i combine to search on some others multi value fields. I mean real estate have type like: house, flat etc. They have to be multi choice too in search form. Like i said there will be a lot of options for one property so if I know how to add some option to be searchable in where clause it will be great for advanced search to build it on my own.

Cheers

Re: [Jason] Search problem

Tue, 31 Jul 2012 14:47:19 -0700

It is multi value list. The table 'imoti' will have more other fields like is it for rent or buy, price and others, but for now my problem is with this. I make search form which give results with min and max price :) if i combine some advanced search for all fields it will be great.

Search problem

Tue, 31 Jul 2012 06:16:39 -0700

Hi to all, i have a little problem with custom search form and result page. Here is it:

I have table for Real Estate properties called 'imoti':

Search index code head:



  require_once "/some-path/lib/viewer_functions.php";

  list($imotiRecords, $imotiMetaData) = getRecords(array(
    'tableName'   => 'imoti',
  ));
  

?>

Body form code:

The result page - result-nov-search.php:

Head:



  require_once "/some-path/lib/viewer_functions.php";

  list($imotiRecords, $imotiMetaData) = getRecords(array(
    'tableName'   => 'imoti',
	'orderBy' => mysql_escape(@$_REQUEST['orderBy']),
        'perPage'     => '2',
  ));

?>

List:

Real Estate - List Page Viewer

    
      Record Number: 

      Name: 

      Price: 

      State: 

      _link : 


      

    

    
      No records were found!

The thing is when choose 1 options (Трошево) from oblast_grad select, it shows all listing, not only form Трошево for example. When you choose 2 options it is the same - all listings. Is my code wrong or ... ?

In URL - result-nov-search.php?oblast_grad[]=Трошево

The result page have to show the listings form 1 option if the user select 1 or 2,3 options at the same time if he search for properties in 2,3 states.

Thanks for help in advanced :)

Cheers