Is there any simple wordpress search template that works with existing searchforms?

Widget content is stored in the $wpdb->options table as serialized data. You can search that with SQL because to SQL serialized data is just a string. 

SELECT option_value FROM {$wpdb->options} WHERE meta_value LIKE "something"

But…

  • The table is not indexed for that kind of search
  • Searching serialized data is dicey anyway
  • And I have no idea how you are going to associate the widgets with
    the pages. That does no happen by default and you have not answered
    my question about that point.

Put together you aren’t going to have a very efficient query and once you jump through hoops to associate the widgets and pages/posts it is going to be even less efficient still.

Sorry, but the decision to build the site the way you have was badly flawed.

Related Posts:

  1. History of page, interval of years
  2. Create custom page templates with plugins?
  3. Consuming an external API in WordPress?
  4. Is there a WordPress plugin that registers a plugin file as a custom page template?
  5. Ways to have multiple front-page.php templates that can be swapped out?
  6. How to make search engine index PDF files? [closed]
  7. How can I have two different urls for the same page that load two different templates?
  8. Page Templates from plugin not working after upgrading WP to 4.7 or upper version
  9. Custom Taxonomy in plugin and template
  10. How would implement StackExchange ‘Questions with similar titles’ for the FAQ on my wordpress site
  11. How can I add a custom header to a custom template in a plugin without using the theme folders
  12. WP-PageNavi plugin doesn’t work with multiple pages of search results
  13. Use touch_time() on front-end form via plugin
  14. how to redirect to my template
  15. Template for custom post type shows all posts instead of just one
  16. Custom url structure for custom template
  17. Creating a wordpress plugin where users can override templates
  18. How to improve WordPress search
  19. do_shortcode() doesn’t work if shortcode contained in variable, works if shortcode passed as string
  20. How do I add advanced custom fields / meta fields to Elasticsearch? [closed]
  21. plugin to search entire posts, blogs, forum, users [closed]
  22. Plugin shortcode won’t work on a custom template file [closed]
  23. How can I reuse the WordPress search form for a custom plugin / widget?
  24. How to Include a Loop Template File in a Plugin
  25. What is the best way to mimic a search query within a plugin
  26. Can we use a webservice with WordPress?
  27. Is there a way I can find wordpress posts that don’t contain a word?
  28. List Category Posts rewrite necessitates rewrite of customised templates
  29. WordPress comments not appearing in blog posts, likely because of Redux template. Could I fix this with a plugin that adds a comment form as a block? [closed]
  30. (FES EDD) New vendor submission page is blank
  31. Plugin-generated pages use Not Found or Pages Archive templates?
  32. How to display (plugin?) output on a single page (not a widget, probably not a short code) – template, plugin, combination?
  33. Advanced Custom Field DatePicker [closed]
  34. Use of Templates in a Plugin
  35. Perform internal redirect in WordPress?
  36. AJAX search as you type? [duplicate]
  37. WooCommerce search products between price range using WP_Query
  38. Is there any hook for theme activation ? or something similar?
  39. changing posts layout in ultimate member profile plugin
  40. How can I use a file in my plugin as a replacement for single.php on custom-post-type query?
  41. Timber – Twig post.content returns null can’t create ACF Gutenberg blocks
  42. Send admin an email when a user’s search has no results
  43. Where to find the code used to render a page that has a shortcode and a template defined?
  44. How do I override plugin templates and stylesheets?
  45. How to set “split_on_numerics” to false in ElasticSearch mapping using ElasticPress? (for proper SKU search in WooCommerce) [closed]
  46. Plugin Admin Menu Boiler Plate
  47. How to use template inside plugin shortcode with variables for big HTML code
  48. Search and Filter Plugin – How to disable redirection
  49. WordPress Multi-Step Product Search
  50. Should meta boxes for specific pages be save in their own plugins?
  51. Call a function for social sharing
  52. Ajax Call in page theme not working?
  53. Prevent plug-in scripts on a specific template?
  54. Pull comments from one page/post into another page/post?
  55. Show Homepage (only) Hits Count
  56. How to call php file in theme directory from plugin
  57. WordPress search shows protected content
  58. How to search post titles with whole words only, but not the exact word only?
  59. RSS feeds for specific topics
  60. WoCommerce Cart is not showing pricing
  61. WC Fix Attributes – ‘Add New’ Not Searchable/Delayed
  62. Mobile Menu and Mobile Sidebar missing
  63. How to check if short code is present in template?
  64. WordPress hierarchy clarification, does post_type_archive take precedence over taxonomy-term archive?
  65. What are the disadvantages of using template_redirect for restrictions
  66. How to prevent redoing get_posts queries and make results available to other scripts?
  67. Call function with button and return response
  68. Change Jobs for WordPress templates
  69. how to do Thematic like this website using wordpress?
  70. How to exclude a part of a page in search results
  71. Template conflict with WC Payment Method
  72. Why is WP template_include overwritting all templates rather than specified page?
  73. How to add HTML to a template only when user is logged out/ not registered
  74. How to make wp multisite subdomain exist search
  75. Remove Url Parameter WordPress
  76. How can I remove this sidebar from my Search Results page?
  77. Adding a custom page template to a plugin generated page
  78. Include post_date in search
  79. How to echo a plugin’s function into a template?
  80. How to add dynamic content to posts page, archive, taxonomies, search, author, etc?
  81. WP plugin calls for custom pages
  82. custom template only for content
  83. How to hook into search results template or query?
  84. Convert HTML5/CSS3 site to WordPress Theme (need a lot of plugins) or just use the API?
  85. WordPress Search return wrong results
  86. Extend WordPress Search
  87. Jigoshop search taxonomy
  88. Dave’s WordPress Live Search only works when logged in as admin
  89. wordpress Search function is not working
  90. Multi-step, live updating search
  91. Display HTML5 jQuery Audio Player On Front Page
  92. Divi Template A Few Questions
  93. My Blog page ( posts page ) theme isn’t changing with the new theme [closed]
  94. Is there a plugin or another way that can help me find out the underlying files of a page/post? [closed]
  95. LiteSpeed cache image Optimization
  96. I want to create a search option for CPT using plugin. The search options should search for categories and tags
  97. Plugin for better Backend Search? [closed]
  98. Load a custom post type template.html from a plugin
  99. How do I apply different block supports to different parts of my custom block?
  100. Is there potential plugin incompatibility if theme has no header.php and footer.php?