WordPress Search on Multiple wp sites

You’ll need to have a look at the posts_clauses filter. There’re more specialised filters as well like posts_where, but you’ll finally end up using the all in one filter.

Then you can inspect the outcome using the 'posts_selection' hook right below that, or the posts_results filter a bit later on.

There’s as well the posts_search filter as searches use a bit different SQL strings.

The final result can be inspected using $wpdb->last_query, or in case of an error using $wpdb->last_error.

If a user is logged in and should be able to search all the blogs he’s registered to, get_blogs_of_user() might be an option. Retrieving a general list of all blogs isn’t hard as well.

Related Posts:

  1. Creating search form for custom database table
  2. Search through custom post type and custom fields takes 5 minutes
  3. Customise search form in the Widget
  4. Comment filtering (search)
  5. Combine multiple words in custom meta search query
  6. Custom search page and search by title, content and tag
  7. Search a post using the date it was posted
  8. Setting custom search engine indexing for a “dynamic WordPress page” with htaccess
  9. Custom URL going to 404
  10. Search result page redirect ex.com/?s=searchterms to ex.com/searchterms
  11. Hi, I wanted to make custom search with multiple fields
  12. Steps for custom data retrieval
  13. Custom search to display results within same page
  14. Search widget will search everything in the site, how to limit to only search gallery name
  15. How to hook up search results page to a back-end page?
  16. Admin search post meta
  17. Add a searchbox to the body of a page
  18. Custom Search on Custom Page while preserving the main search function
  19. Custom Loop Query For Search Page
  20. Search URL parameters query [duplicate]
  21. Applying WP-cli Search & Replace to Static SQL Dump File
  22. How to create custom search page
  23. Custom Same Page Search
  24. How to Add Additional Search Button?
  25. How to Clear Empty Search values?
  26. WP Search Form Query: Add Author’s posts into search query
  27. WordPress search on a custom table
  28. Adding overlay search to wordpress using add action/filter
  29. Allow WP users to sort search result on a videos site
  30. WP_User_Query Search Multiple Keywords from a Multi-Select Field?
  31. Custom dropdown search form that allows users to select option B based from Option 1
  32. Custom search results
  33. WordPress custom search – pagination
  34. Creating a search with tag variable also added for more detailed results
  35. What shortcode should I use for
  36. Two searchforms with different categories/posts per page
  37. Search a meta field for a value in all posts
  38. Custom search by several options send on form not works
  39. Search results load individual post in slide out div
  40. Custom Search Results Page
  41. Create a custom search for Estate Agency WordPress site
  42. How can I make a search term redirect to a page
  43. Sort Search Results in Order of/by Character @ count (9) of post(s) title. (Ocean-WP theme)
  44. Show total sales for each products on search results page Woocommerce
  45. Custom Search on media files PDF images pages posts
  46. What Is The Use Of map_meta_cap Filter?
  47. How to *remove* a parent theme page template from a child theme?
  48. How to disable page delete
  49. Need logged in users returing to site redirected to a separate page
  50. Widgets vs. Theme Mods
  51. Adding an email column to a Custom Post Types Admin Screen?
  52. Print shortcode in custom action hook not where the shortcode is entered
  53. simple expandable vertical menu, java script problem
  54. sanitize attachment filename
  55. Best way to integrate an existing PHP application into WordPress
  56. wp_query ‘s’ parameter does not work with custom post type
  57. How do I add a new template to my site
  58. Adding code to child’s theme css and php cannot override certain elements
  59. Woocommerce custom search
  60. How can I use a Tiny MCE editor in my custom Gutenberg block?
  61. Changing settings of WooCommerce
  62. How can I stop access of unregistered user in wp-content/uploads directory without using .htaccess file?
  63. wp_customize set_transient except during preview
  64. How do you add a table to a site?
  65. how to make a custom field readonly or disabled by user role?
  66. How to make wordpress use a non-wordpress users table?
  67. WooCommerce custom billing fields on email address
  68. Is there a straight-forward way to provide a meta description tag via Yoast SEO, programmatically, without relying on the admin panel?
  69. Restrict content access to logged in users
  70. Make tag archive display post are ordered by post format
  71. Custom Form not generating URL
  72. How to move meta information in TwentyTwelve’s single post template?
  73. WordPress Command Question
  74. getting a 404 page for all pages except home. possibly permalinks
  75. How do I create a Custom Post Box that Connects Different Posts Together
  76. Pull Latest Forum Posts within WordPress
  77. saving the widgets position after drag and drop
  78. Google calendar in wordpress showing events
  79. Custom menu not showing even though it shows as being registered?
  80. Open login logo URL in new tab
  81. Multisite with subdirectories, and a WordPress installation in a custom folder
  82. Display all subterms of a custom taxonomy filtered by parent terms
  83. Delete a column in edit.php generated with a plugin
  84. Migrating my site to a new domain does not keep any changes made in customizer
  85. how to add custom html and css to wordpress
  86. How to use the same custom page template to iframe multiple urls with entry of new url entered from backend
  87. Unhook a function within a class in the child theme
  88. Where to put coding a validation script for store? [duplicate]
  89. How to define active widget with js in a customizer
  90. where can i find the login page in wordpress and add my header to it
  91. Class .current-menu-item in custom menu Walker
  92. Add several fields from different tables to post, fields per post are in same row of table
  93. Custom folder structure and problem with 3rd party services
  94. How to strip thumb from widget
  95. Issue with WordPress native theme customizer function and jquery ui tabs
  96. add custom css on all page exept of one
  97. Typing and seeing math equations on WordPress site
  98. Upgrade to 3.1.1 Fails
  99. Very Simple Geo targeting
  100. Consolidate ‘add-to-cart’ buttons into one ‘add-all-to-cart’ button