wpdb::get_results() WordPress Method

	public function get_results( $query = null, $output = OBJECT ) {
		$this->func_call = "\$db->get_results(\"$query\", $output)";

		if ( $query ) {
			if ( $this->check_current_query && $this->check_safe_collation( $query ) ) {
				$this->check_current_query = false;
			}

			$this->query( $query );
		} else {
			return null;
		}

		$new_array = array();
		if ( OBJECT === $output ) {
			// Return an integer-keyed array of row objects.
			return $this->last_result;
		} elseif ( OBJECT_K === $output ) {
			// Return an array of row objects with keys from column 1.
			// (Duplicates are discarded.)
			if ( $this->last_result ) {
				foreach ( $this->last_result as $row ) {
					$var_by_ref = get_object_vars( $row );
					$key        = array_shift( $var_by_ref );
					if ( ! isset( $new_array[ $key ] ) ) {
						$new_array[ $key ] = $row;
					}
				}
			}
			return $new_array;
		} elseif ( ARRAY_A === $output || ARRAY_N === $output ) {
			// Return an integer-keyed array of...
			if ( $this->last_result ) {
				foreach ( (array) $this->last_result as $row ) {
					if ( ARRAY_N === $output ) {
						// ...integer-keyed row arrays.
						$new_array[] = array_values( get_object_vars( $row ) );
					} else {
						// ...column name-keyed row arrays.
						$new_array[] = get_object_vars( $row );
					}
				}
			}
			return $new_array;
		} elseif ( strtoupper( $output ) === OBJECT ) {
			// Back compat for OBJECT being previously case-insensitive.
			return $this->last_result;
		}
		return null;
	}
Uses	Description
wp-includes/wp-db.php:wpdb::check_safe_collation()	Checks if the query is accessing a collation considered safe on the current version of MySQL.
wp-includes/wp-db.php:wpdb::query()	Performs a database query, using current database connection.
Used By	Description
wp-admin/includes/class-wp-debug-data.php:WP_Debug_Data::get_database_size()	Fetch the total size of all the database tables for the active database user.
wp-includes/ms-site.php:wp_is_site_initialized()	Checks whether a site is initialized.
wp-admin/includes/class-wp-privacy-requests-table.php:WP_Privacy_Requests_Table::get_request_counts()	Count number of requests for each status.
wp-includes/taxonomy.php:has_term_meta()	Gets all meta data, including meta IDs, for the given term ID.
wp-includes/class-wp-term-query.php:WP_Term_Query::get_terms()	Retrieves the query results.
wp-includes/taxonomy.php:_prime_term_caches()	Adds any terms from the given IDs to the cache that do not already exist in cache.
wp-includes/ms-network.php:_prime_network_caches()	Adds any networks from the given IDs to the cache that do not already exist in cache.
wp-includes/ms-site.php:_prime_site_caches()	Adds any sites from the given IDs to the cache that do not already exist in cache.
wp-admin/includes/export.php:wxr_term_meta()	Output term meta XML tags for a given term object.
wp-includes/class-wp-term.php:WP_Term::get_instance()	Retrieve WP_Term instance.
wp-includes/comment.php:_prime_comment_caches()	Adds any comments from the given IDs to the cache that do not already exist in cache.
wp-includes/taxonomy.php:_wp_batch_split_terms()	Splits a batch of shared taxonomy terms.
wp-includes/wp-db.php:wpdb::get_table_charset()	Retrieves the character set for the given table.
wp-admin/includes/upgrade.php:maybe_convert_table_to_utf8mb4()	If a table only contains utf8 or utf8mb4 columns, convert it to utf8mb4.
wp-includes/media.php:attachment_url_to_postid()	Tries to convert an attachment URL into a post ID.
wp-admin/install-helper.php:check_column()	Checks that database table column matches the criteria.
wp-admin/export.php:export_date_options()	Create the date options fields for exporting a given post type.
wp-admin/includes/export.php:export_wp()	Generates the WXR export file for download.
wp-admin/includes/export.php:wxr_authors_list()	Output list of authors with posts
wp-admin/includes/deprecated.php:get_editable_authors()	Gets author users who can edit posts.
wp-admin/includes/deprecated.php:get_others_unpublished_posts()	Retrieves editable posts from other users.
wp-admin/includes/class-wp-list-table.php:WP_List_Table::months_dropdown()	Displays a dropdown for filtering items in the list table by month.
wp-admin/includes/upgrade.php:pre_schema_upgrade()	Runs before the schema is upgraded.
wp-admin/includes/upgrade.php:upgrade_network()	Executes network-level upgrade routines.
wp-admin/includes/upgrade.php:get_alloptions_110()	Retrieve all options as it was for 1.2.
wp-admin/includes/upgrade.php:dbDelta()	Modifies the database based on specified SQL statements.
wp-admin/includes/user.php:get_users_drafts()	Retrieve the user’s drafts.
wp-admin/includes/template.php:parent_dropdown()	Prints out option HTML elements for the page parents drop-down.
wp-admin/includes/media.php:media_upload_library_form()	Outputs the legacy media upload form for the media library.
wp-admin/includes/post.php:has_meta()	Returns meta data for the given post ID.
wp-admin/includes/post.php:bulk_edit_posts()	Processes the post data for the bulk editing of posts.
wp-admin/includes/class-wp-importer.php:WP_Importer::get_imported_comments()	Set array with imported comments from WordPress database
wp-admin/includes/class-wp-importer.php:WP_Importer::get_imported_posts()	Returns array with imported permalinks from WordPress database
wp-admin/includes/class-wp-importer.php:WP_Importer::count_imported_posts()	Return count of imported permalinks from WordPress database
wp-admin/includes/comment.php:get_pending_comments_num()	Get the number of pending comments on a post or posts
wp-includes/pluggable.php:cache_users()	Retrieve info for user lists to prevent multiple queries by get_userdata()
wp-includes/general-template.php:wp_get_archives()	Display archive links based on type and format.
wp-includes/general-template.php:get_calendar()	Display calendar with days that have posts as links.
wp-includes/deprecated.php:get_users_of_blog()	Get users for the site.
wp-includes/class-wp-query.php:WP_Query::get_posts()	Retrieves an array of posts based on query variables.
wp-includes/functions.php:wp_scheduled_delete()	Permanently delete comments or posts of any type that have held a status of ‘trash’ for the number of days defined in EMPTY_TRASH_DAYS.
wp-includes/functions.php:is_blog_installed()	Determines whether WordPress is already installed.
wp-includes/taxonomy.php:_pad_term_counts()	Adds count of children to parent count.
wp-includes/taxonomy.php:clean_term_cache()	Removes all of the term IDs from the cache.
wp-includes/taxonomy.php:wp_delete_term()	Removes a term from the database.
wp-includes/option.php:wp_load_alloptions()	Loads and caches all autoloaded options, if available or all options.
wp-includes/option.php:wp_load_core_site_options()	Loads and caches certain often requested site options if is_multisite() and a persistent cache is not being used.
wp-includes/class-wp-user-query.php:WP_User_Query::query()	Executes the query, with the current variables.
wp-includes/user.php:count_many_users_posts()	Gets the number of posts written by a list of users.
wp-includes/media.php:wp_enqueue_media()	Enqueues all scripts, styles, settings, and templates necessary to use all media JS APIs.
wp-includes/post.php:_prime_post_caches()	Adds any posts from the given IDs to the cache that do not already exist in cache.
wp-includes/post.php:get_page_by_path()	Retrieves a page given its path.
wp-includes/post.php:get_pages()	Retrieve an array of pages (or hierarchical post type items).
wp-includes/post.php:wp_delete_post()	Trash or delete a post or page.
wp-includes/post.php:wp_trash_post_comments()	Moves comments for a post to the Trash.
wp-includes/post.php:wp_count_posts()	Count number of posts of a post type and if user has permissions to view.
wp-includes/post.php:wp_count_attachments()	Count number of attachments for the mime type(s).
wp-includes/class-wp-rewrite.php:WP_Rewrite::page_uri_index()	Retrieves all page and attachments for pages URIs.
wp-includes/canonical.php:redirect_canonical()	Redirects incoming links to the proper URL based on the site url.
wp-includes/revision.php:wp_get_post_autosave()	Retrieve the autosaved data of the specified post.
wp-includes/ms-deprecated.php:install_blog()	Install an empty blog.
wp-includes/ms-deprecated.php:get_admin_users_for_domain()	Get the admin for a domain/path combination.
wp-includes/bookmark.php:get_bookmarks()	Retrieves the list of bookmarks
wp-includes/ms-deprecated.php:get_blog_list()	Deprecated functionality to retrieve a list of all sites.
wp-includes/author-template.php:wp_list_authors()	Lists all the authors of the site, with several options available.
wp-includes/ms-blogs.php:get_last_updated()	Get a list of most recently updated blogs.
wp-includes/class-wp-xmlrpc-server.php:wp_xmlrpc_server::mt_getTrackbackPings()	Retrieve trackbacks sent to a given post.
wp-includes/class-wp-xmlrpc-server.php:wp_xmlrpc_server::pingback_ping()	Retrieves a pingback and registers it.
wp-includes/class-wp-xmlrpc-server.php:wp_xmlrpc_server::pingback_extensions_getPingbacks()	Retrieve array of URLs that pingbacked the given URL.
wp-includes/class-wp-xmlrpc-server.php:wp_xmlrpc_server::attach_uploads()	Attach upload to a post.
wp-includes/class-wp-xmlrpc-server.php:wp_xmlrpc_server::wp_getPageList()	Retrieve page list.
wp-includes/meta.php:update_meta_cache()	Updates the metadata cache for the specified objects.