Hosting Forums Market
Osclass

Query Items (custom listings select)

Displaying Specific Listings Using osc_query_item()

Osclass provides a powerful function osc_query_item($params) that allows developers to filter and display listings dynamically based on various criteria. This function supports **multiple filtering options** and can be used to fine-tune the selection of listings displayed on a page.

Filtering listings can be useful for custom sections like:

  • Showing listings from a specific country, region or city
  • Displaying premium listings only
  • Filtering listings based on category or author
  • Showing only listings with images
  • Applying price-based filters
  • Sorting and limiting results per page

How to Use osc_query_item()

The function accepts a string or an array of parameters to filter the listings based on specific criteria. The returned listings can then be displayed using Osclass template functions.

Filtering by a Single Parameter

To retrieve all listings from a specific region (e.g., Madrid), use:

<?php osc_query_item("region_name=Madrid"); ?>

Filtering by Multiple Parameters

To retrieve listings based on **multiple** conditions, pass an array of filters:

<?php
osc_query_item(array(
    "category_name" => "cars,houses",
    "city_name" => "Madrid",
    "premium" => "1"
));
?>

In the above example, the function will return listings from Madrid, limited to cars and houses, and only those marked as premium.

Available Filtering Parameters

Osclass allows filtering listings using the following parameters:

Parameter Description
author Filters listings by user ID
author_email Filters listings by user email
country / country_name Filters by country ID or name
region / region_name Filters by region ID or name
city / city_name Filters by city ID or name
city_area / city_area_name Filters by city area ID or name
category / category_name Filters by category ID or name
premium Shows only premium listings (1 = Yes, 0 = No)
with_picture Shows only listings with images (1 = Yes, 0 = No)
max_price Filters listings with price below a certain value
min_price Filters listings with price above a certain value
zip Filters listings by ZIP code
condition Filters listings by item condition
item_condition Filters listings based on predefined item condition values
locale Filters listings by user locale
results_per_page Defines the number of results per page
page Specifies the pagination page number
offset Skips a specified number of results
order Defines sorting order, e.g., order=price,DESC

Displaying Filtered Listings

Once the function has retrieved the listings, you can display them using Osclass template functions.

<?php if (osc_count_custom_items() == 0) { ?>
    <p class="empty"><?php _e('No Listings', 'modern'); ?></p>
<?php } else { ?>
    <table border="0" cellspacing="0">
        <tbody>
            <?php while (osc_has_custom_items()) { ?>
                <tr class="<?php echo (osc_item_is_premium() ? ' premium' : ''); ?>">
                    <td class="photo">
                        <a href="<?php echo osc_item_url(); ?>">
                            <img src="<?php echo osc_resource_thumbnail_url(); ?>" width="75" height="56" alt="<?php echo osc_item_title(); ?>" />
                        </a>
                    </td>
                    <td class="text">
                        <h3><a href="<?php echo osc_item_url(); ?>"><?php echo osc_item_title(); ?></a></h3>
                        <p><?php echo osc_item_formated_price(); ?> - <?php echo osc_item_city(); ?> (<?php echo osc_item_region(); ?>) - <?php echo osc_format_date(osc_item_pub_date()); ?></p>
                        <p><?php echo osc_highlight(strip_tags(osc_item_description())); ?></p>
                    </td>
                </tr>
            <?php } ?>
        </tbody>
    </table>
<?php } ?>

Conclusion

The osc_query_item() function is a highly flexible method for retrieving Osclass listings dynamically. It supports multiple filtering parameters, sorting options, and pagination, making it an essential tool for customizing how listings are displayed on your site.