Placing a widget with $wpdb query

Placing widgets via a MySQL or something MySQL abstracted via the global variable $wpdb that is an instance of the WPDB class is not trivial.

That’s not because MySQL is something complicated or because $wpdb is useless at all but this has do something with the way the widget configuration is stored inside the mysql database options tables.

But there is always a work around. The nature of the widget configuration is stored inside the mysql database options tables. Just read the widgets configuration out of the option (get_option), edit it as you wish (use var_dump to inspect how that array is used) and then store it back into mysql via update_option.

That done you should be able to edit this “via mysql” (e.g. in the database) while making the settings of your wish.

This is quite a quick answer but it probably solves your issue.

Related Posts:

  1. Where is the content of widgets stored in mysql table
  2. Return only Count from a wp_query request?
  3. Multipart/formatted MySQL query problem
  4. Is It Possible to Restore Accidentally Deleted Widgets?
  5. How to execute SQL SELECT query and see the results?
  6. WordPress widget new instance creates content duplicates
  7. Why is variable not working on custom sql query using wpdb?
  8. Advanced SELECT query with condtional statements
  9. Global $wpdb is not showing correct data with function call
  10. Query in query for Widget
  11. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  12. wpdb COALESCE won’t work
  13. Insert widgets into loop/custom query at every nth position
  14. Custom WordPress Table wpdb
  15. Best practice to limit results in get_row()?
  16. Get posts from category with custom query
  17. Query Column of Specific ID from Database Table
  18. Valid SQL query return empty
  19. mysql query – how to escape apostrophe?
  20. Select two value from meta key and post meta
  21. Updating with $qpdb->query() always returns 0 rows affected
  22. WordPress Insert not working with ajax
  23. How to return count of custom post type posts with a specific custom field value via $wpdb?
  24. WordPress Mysql query and Duplicate
  25. accessing wordpress serialized data outside wp
  26. Help with Related Posts Function
  27. Creating a widget that displays the content of a page
  28. Delete oldest wordpress post (SQL query)
  29. WordPress Database Query works in phpMyAdmin but not in the code
  30. Reload widget with AJAX
  31. Function returning queried meta value based on current post ID
  32. Mysql query and odd results
  33. Using wpdb to connect to a separate database
  34. Programmatically add widgets to sidebars
  35. wpdb->insert multiple record at once
  36. Get Widget Instance inside Widget
  37. Add the sidebar/widget editor to the post edit screen?
  38. WP_Widget deprecated error in WordPress V4.3
  39. What is the quickest way to make a widget?
  40. Remove before_widget / after_widget content from Wp_Widget_Text
  41. Search and replace text across all posts
  42. wpdb Custom Meta Data with 2 conditions
  43. Big side banners
  44. Custom $wpdb Query for Custom Post Type by Category
  45. Can’t pass table to $wpdb->prepare
  46. Need help adding additional controls to a custom widget Part 2
  47. How to add the widgets manually to the sidebar?
  48. How to check if widget has automatic title
  49. Are database queries created using WordPress filters protected from SQL injection?
  50. When you register a sidebar in WordPress, is it possible to choose in what order it appears in the admin
  51. Moving comments section to left of content (Twenty Thirteen)
  52. Custom Tag Cloud widget missing tags
  53. How the widget can be run by shortcode
  54. add widgets to dashboard for easy access for clients?
  55. How to add new sidebar widget area to child theme?
  56. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  57. Disallow categories from this MySQL query
  58. Uses Cases for the Calendar Widget
  59. WordPress database error – Error in SQL syntax – I can’t identify any error?
  60. Widgets missing after update
  61. Help with custom widget options! (saving checkbox option)
  62. How to filter products using filter products by attribute widget and OR logic between different product attribute types?
  63. $wpdb->replace: WHERE?
  64. wp_get_attachment_image() not displaying post images even though wp_get_attachment_url() echo correct urls
  65. what is the best way to add things to a side bar
  66. Disable a plugin’s widget
  67. how to insert missing tags into the posts through mySQL?
  68. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  69. How do I prepare strings for insertions as values into a MySQL table?
  70. Multiple rows of footer widget areas
  71. How to insert dash (-) into database using wpdb and new_to_publish hook?
  72. Escape HTML on WP input
  73. how can i display all youtube videos from a users youtube account
  74. Link a widget or find the php that creates the widgets
  75. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  76. Add a widget to a static front page
  77. Problem with WP_Query loop and search term
  78. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  79. How to decorate WP_Widget_Text?
  80. After adding widget the style is messing up
  81. Should I Use only wpdb Class to Write Custom Queries?
  82. CONCAT_WS in custom sql query
  83. Where to add a widget class?
  84. Does current page contain widget or sidebar
  85. Paginate recent posts widget
  86. Widget front-end fails to echo as expected from checkbox
  87. Adding Widgets to Reactor Theme (based on Foundation 4)
  88. MySQL database migration to WordPress
  89. Help me tidy up my widget code
  90. Neaten content — different widget or CSS change?
  91. Custom widget breaking widget section in admin menu
  92. How to reference same column name but different table in custom db query
  93. Retrieving custom field array value through db query
  94. Unique widget id in sidebar
  95. Taxonomies not showing in WP Dashboard Right Now widget
  96. trying to Change to wp_register_sidebar_widget
  97. How to delete Jetpack Widgets from the Widgets page in admin panel [closed]
  98. Query Concatenation
  99. Widget does not work with WooCommerce enabled
  100. How can I add a toggle element into an image box element? [closed]