In Oxygen's Facebook group, a user wrote:

Hey guys, I am working on a real estate website with oxygen. I think I finally cracked the problem on integrating an MLS® feed into an oxygen site. I need a hand with one thing.


I need some code that will query the database to get the unique listing ID and insert that into a shortcode. That way I can display the data in a custom oxygen template.

This tutorial provides the steps to

  1. use $wpdb Object's get_var function to retrieve the value of a ListingID column in the rps_property (name without the prefix) table for the current post (a CPT entry)
  2. show how to run a shortcode using the above string as the value of listing_id parameter in Oxygen's Code Block
  3. define a custom shortcode that outputs the value of ListingID for the current post.

Code Block Component

In the Template that applies to single entries, add the following in the PHP & HTML section:

global $wpdb, $table_prefix;

$listingid = $wpdb->get_var( 'SELECT ListingID FROM ' . $table_prefix . 'rps_property WHERE PostID = ' . get_the_ID() );

echo do_shortcode( '[rps-listing-data listing_id="' . $listingid . '" key=StreetAddress]' );

Sample shortcode output:

[rps-listing-data listing_id=889371854720  key=StreetAddress]

Shortcode Component

If you prefer using a shortcode instead,

a) Install and activate Code Snippets plugin

b) Add a new Snippet.

Title: [Shortcode] Run [rps-listing-data] shortcode for the current listing


add_shortcode( 'my-rps-listing-data', function () {
	global $wpdb, $table_prefix;

	$listingid = $wpdb->get_var( 'SELECT ListingID FROM ' . $table_prefix . 'rps_property WHERE PostID = ' . get_the_ID() );

	return do_shortcode( '[rps-listing-data listing_id="' . $listingid . '" key=StreetAddress]' );
} );

c) In the Template that applies to single entries, use this shortcode in a Shortcode component:



Need help implementing a tutorial in your site or want to hire me for custom work?


Find the article helpful and wish to donate?



You need to be logged in to view and post comments.
Not a member yet? Join here.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram
%d bloggers like this: