Robert Strobel

Thanks a lot Kiran. Much appreciated.

We have different titles and different meta tags plus different images per category, they do not all follow a format like the defaults…

Thanks a bunch Stiofan!!

Here’s the code I used for any users who may have same query I had:

global $wpdb, $plugin_prefix;
	$existing = $wpdb->get_results($wpdb->prepare(
				"SELECT * FROM {$wpdb->posts} p JOIN " . ($plugin_prefix . 'gd_customdir_detail') . " gd ON gd.post_id=p.ID WHERE gd.geodir_test_val=%d LIMIT 1",
				array(1000)
			));//works

We’re set now. Thanks for the help again.

What would the rest api URL be for filtering the listing by custom field?

Thanks Alex.

I tried this simple query to retrieve listings by custom field value. Since I first need the $post_id to use geodir_get_post_info() or _get_post_meta() —

$existing = (new WP_Query(array(
		"meta_query"	=> array(
			array(
				"key"	=> "geodir_test_val",
				"value"	=> "100",
				// 'compare' => 'IN'
			)
		)
	)))->posts;

However this returns an empty array, however there is a listing with the custom field value “100” as I created it manually to test with.

Much thanks for info so far. It has been helpful and insightful.

My use case is:
We have a variable called

$testvalue = "testval";

We want to use this $testvalue to update geo directory listings that have a custom field “Test Val” as the same value a this variable $testvalue
Also, we want to be updating other custom fields within the geodir_save_listing() call

The goal is to insert a record if it does not already exist with the custom field as $testvalue and if it exists, then update instead

Thanks

FYI i found the following code that helped me with taxonomy usage for caegories..

pasting for anyone else who may read with the same need..

function geodir_taxonomy_breadcrumb() {
	
	$term = get_term_by( 'slug', get_query_var( 'term' ), get_query_var( 'taxonomy' ) );
 	$parent = $term->parent;
	
	while ($parent):
		$parents[] = $parent;
		$new_parent = get_term_by( 'id', $parent, get_query_var( 'taxonomy' ));
		$parent = $new_parent->parent;
	endwhile;
	
	if(!empty($parents)):
		$parents = array_reverse($parents);
		 
		foreach ($parents as $parent):
			$item = get_term_by( 'id', $parent, get_query_var( 'taxonomy' ));
			$url = get_term_link( $item, get_query_var( 'taxonomy' ) ); 
			echo '<li> > <a href="'.$url.'">'.$item->name.'</a></li>';
		endforeach;

	endif;
	 
	echo '<li> > '.$term->name.'</li>';
}