Custom query loop using $wpdb

[pixite]

Hi,

Is it possible to do a custom query loop with $wpdb?

I am hoping to use the below code in the query and use meta fields to populate the content.

global $wpdb;

$table_name = $wpdb->prefix . 'wpsr_reviews';

$results = $wpdb->get_results( "SELECT reviewer_name, reviewer_url, reviewer_text, review_time, rating FROM $table_name WHERE reviewer_text IS NOT NULL AND rating = 5" );

foreach ($results as $result) {
    echo 'Reviewer Name: ' . $result->reviewer_name . '<br>';
    echo 'Reviewer URL: ' . $result->reviewer_url . '<br>';
    echo 'Reviewer Text: ' . $result->reviewer_text . '<br>';
    echo 'Review Time: ' . $result->review_time . '<br>';
    echo 'Rating: ' . $result->rating . '<br><br>';
}

[aslotta]

Absolutely. See the following hooks:

1. Filter: bricks/setup/control_options – Bricks Academy
2. Filter: bricks/query/run – Bricks Academy
3. Filter: bricks/query/loop_object – Bricks Academy

And / Or a complete example:

Is there a way to use an Array for a Query Loop

You could set up a custom query like this: add_filter( 'bricks/setup/control_options', function( $control_options ) { $control_options['queryTypes']['my_query_type'] = esc_html__( 'My Query Type', 'my-plugin' ); return $control_options; } ); add_filter( 'bricks/query/run', function( $results, $query_obj ) { if ( $query_obj->object_type !== 'my_query_type' ) { return $results; } return [ [ 'name' => 'Bob', 'phone' => '1234567' …

[pixite]

Thank you!

I made a gist of my code that I think is right, it appears to be working.

https://gist.github.com/liamhiggins22/ac937f3e4839a20a58d1abf4cd64353b