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:
- History of page, interval of years
- Pass PHP variable to javascript
- Is it possible to stop selected plugins from loading on certain template pages?
- Creating a default Custom Post Template that a Theme can override
- WooCommerce – Load Templates From Plugin For All Template Files
- How to override normal WordPress search in Buddypress? [closed]
- Search and replace text across all posts
- dynamic page not indexed
- How can I add a custom header to a custom template in a plugin without using the theme folders
- How to get posts by content?
- Problem with Search Results in WP (not displaying the full posts)
- Template plugin for blog posts? [closed]
- Custom url structure for custom template
- Developer plugin to echo template names/filepaths [closed]
- How do I make a wordpress plugin with menu item etc
- do_shortcode() doesn’t work if shortcode contained in variable, works if shortcode passed as string
- Get image URL from media library in input
- taxonomy_template filter do not loads custom taxonomy template properly
- Automatically adding category filter based on search string
- Override comments.php template with plugin
- How to enqueue a theme style-sheet to my admin settings page?
- What causes an Unexpected HTTP Error within install plugins?
- Woocommerce email template customization [closed]
- How to get the HTML until ?
- More than one text-domain is being used because of the included templates for plugins
- Can we use a webservice with WordPress?
- Search is not working on plugin directory
- WP Post Template – Templates in own folder
- Register Page Template from Plugin
- Search Everything plugin integration
- AJAX search posts and pages
- (FES EDD) New vendor submission page is blank
- Search for categories
- Use of Templates in a Plugin
- Add comments for template variables
- Render custom php template into string
- How to use get_template part in the plugin?
- Template filter for custom taxonomy terms
- how to force tag page layout to use same as search layout?
- Calling the_excerpt from inside a plugin template file
- Best practice for including plugin output in a template without using shortcode?
- Integrate Algolia to WordPress site
- WordPress as template engine
- How to multiply a post to test internal search results?
- Default taxonomy template in plugin, override in theme
- Woocommerce Backend Search by Title and SKU
- Opening a JQuery modal window on click of a button with a JQuery plugin
- Search by Attachment ID
- Custom search search does not work?
- Pagination shows Same posts
- Creating a search form and displaying results
- Custom form not showing in correct place on page
- How do I show content from a plugin using the template the site is currently working with?
- Woocommerce – Change Variable Product Add to Cart to behave like external product using Custom Field (link) [closed]
- Is it save to replace with in WordPress search form
- Multiple Post Thumbnails Plugin – Need help with code
- Wp-minify doesn’t seem to minify my JS code
- use EDD Content Restriction for restricting php in template
- Pass PHP variable to javascript
- Best approach to make all tags searchable by the wordpress search function
- How can I disable an attribute from a Gutenberg block included in a template via InnerBlocks?
- How to turn my WordPress site into a ready to deploy template?
- How to add the search page link to the anchor tag?
- how to display a template.php in a shortcode
- Enqueue css to a third-party plugin template
- the_posts_pagination() not working if I add wp_head() to header.php
- How to hide an option from dropdown in filter module
- WP search box on page not finding .PDF files
- Search results to point to specific section?
- Search in WordPress
- How to add post title to custom php?
- How to access Post Archive created by Elementor?
- Content disappears when searching with Search & Filter plugin
- Programmatically generate new pages for a site based on page template and content elements accessed via DB
- Accounting for search terms that may include a space, using SearchWP
- How to change the deafult template in WordPress plugin
- how to add navigation icons in specific template?
- WordPress arrows dissapeared strange signs
- multiple string replace of post’s content for large data
- How can I make the search bar in my wordpress site search all of the pages rather than just the blog posts?
- Why is WP template_include overwritting all templates rather than specified page?
- How to order users alphabetically by name? in plugin UPME
- Add “selected” class to custom taxonomy dropdown search
- Differentiate attachment pages in search results
- show Visual form builder in the front end
- Fake Single WordPress Post (Page) Loop
- how to sort results by last day update at search result in plugin installer?
- WordPress multisite haml templates
- How to make plugin work in each template in wordpress
- Strange Search Query Appearing on Google Index – “/?q=Save+Us+From+Berlusconi”
- [Custom field template plugin] Upload limited to 20 inputs file
- Make a Custom template for a specific category in wordpress
- WP Customer Reviews call short code on another page [closed]
- WordPress show different custom post type
- Template library for WordPress [closed]
- How to display content depending on the Woocommerce Product Category
- How to make a Template page to show the information of different things Shop and Product page?
- How to provide page_template path in custom plugin using WordPress
- Cannot register a block in my Twig-based theme using Timber for WP
- How to set an exact search box in tablepress plug-in