W3cubDocs

/WordPress

WP_Rewrite::page_uri_index()

Retrieves all page and attachments for pages URIs.

Description

The attachments are for those that have pages as parents and will be retrieved.

Return

(array) Array of page URIs as first element and attachment URIs as second element.

Source

File: wp-includes/class-wp-rewrite.php 

public function page_uri_index() {
		global $wpdb;

		// Get pages in order of hierarchy, i.e. children after parents.
		$pages = $wpdb->get_results( "SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_type = 'page' AND post_status != 'auto-draft'" );
		$posts = get_page_hierarchy( $pages );

		// If we have no pages get out quick.
		if ( ! $posts ) {
			return array( array(), array() );
		}

		// Now reverse it, because we need parents after children for rewrite rules to work properly.
		$posts = array_reverse( $posts, true );

		$page_uris            = array();
		$page_attachment_uris = array();

		foreach ( $posts as $id => $post ) {
			// URL => page name.
			$uri         = get_page_uri( $id );
			$attachments = $wpdb->get_results( $wpdb->prepare( "SELECT ID, post_name, post_parent FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent = %d", $id ) );
			if ( ! empty( $attachments ) ) {
				foreach ( $attachments as $attachment ) {
					$attach_uri                          = get_page_uri( $attachment->ID );
					$page_attachment_uris[ $attach_uri ] = $attachment->ID;
				}
			}

			$page_uris[ $uri ] = $id;
		}

		return array( $page_uris, $page_attachment_uris );
	}

Uses

Uses Description
wp-includes/post.php: get_page_hierarchy()

Order the pages with children under parents in a flat list.
wp-includes/post.php: get_page_uri()

Build the URI path for a page.
wp-includes/wp-db.php: wpdb::get_results()

Retrieves an entire SQL result set from the database (i.e., many rows).
wp-includes/wp-db.php: wpdb::prepare()

Prepares a SQL query for safe execution.

Changelog

Version Description
2.5.0 Introduced.

© 2003–2019 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/classes/wp_rewrite/page_uri_index