Function Reference: autocompleters_near
Summary
This function has not been documented yet.
Source File
autocompleters_near() is located in geodir_advance_search_filters/geodirectory_advance_search_function.php [Line: 2056]
Source Code
function autocompleters_near() { global $wpdb; //print_r($_REQUEST);exit; if (!defined('POST_LOCATION_TABLE')){return;} $search = isset($_GET['q']) ? $_GET['q'] : ''; if(!$search){return;} $loc_list = array(); $countries = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".POST_LOCATION_TABLE." WHERE country like %s GROUP BY country LIMIT 3", array($search.'%') ) ); if(!empty($countries)){ foreach($countries as $country){ echo $country->country." (Country) |".$country->country."|".$country->location_id."|1 n"; } } $regions = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".POST_LOCATION_TABLE." WHERE region like %s GROUP BY region LIMIT 3", array($search.'%') ) ); //print_r($regions); if(!empty($regions)){ foreach($regions as $region){ echo $region->region." (Region) |".$region->region."|".$region->location_id."|2 n"; } } $cities = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".POST_LOCATION_TABLE." WHERE city like %s GROUP BY city LIMIT 3", array($search.'%') ) ); if(!empty($cities)){ foreach($cities as $city){ echo $city->city." (City) |".$city->city."|".$city->location_id."|3 n"; } } exit; //print_r($countries);exit; if(strlen($search)){ switch($results){ case 1: $words1 = $wpdb->get_results( $wpdb->prepare( "SELECT concat( name, '|', sum( count ) ) name, sum( count ) cnt FROM ".$wpdb->prefix."terms t, ".$wpdb->prefix."term_taxonomy tt WHERE t.term_id = tt.term_id AND t.name LIKE %s AND tt.taxonomy in (".$geodir_terms_autocomplete.") GROUP BY t.term_id ORDER BY cnt DESC", array($search.'%') ) ); $words2 = $wpdb->get_results( $wpdb->prepare( "SELECT post_title as name FROM $wpdb->posts where post_status='publish' and post_type in (".$gt_posttypes_autocomplete.") and post_date < '".current_time('mysql')."' and post_title LIKE %s ORDER BY post_title", array('%'.$search.'%') ) ); $words = array_merge((array)$words1 ,(array)$words2 ); asort($words); break; } foreach ($words as $word){ if($results > 0){ $id = isset($word->ID) ? $word->ID : ''; echo $word->name."|".get_permalink($id)."n"; }else{ echo $word->name."n"; } } } }