$wpdb->get_results: WordPress Database Query Function | Guide & Example

The \$wpdb->get_results method is used to retrieve an array of results from a database query. It is part of the WordPress database class (\$wpdb) and is typically used to interact with the WordPress database.

Here is an example of how to use \$wpdb->get_results:

global \$wpdb;

\$results = \$wpdb->get_results(
    "SELECT * FROM wp_posts WHERE post_status = 'publish' LIMIT 10"
);

foreach (\$results as \$result) {
    // Process each result
    echo \$result->post_title;
}

In this example, we are retrieving the titles of the 10 most recent published posts from the WordPress database using an SQL query. The \$results variable will hold an array of objects, with each object representing a post. We can then loop through the results and access the properties of each post object, such as post_title.