Retrieving widget data with MySQL query in WordPress

2 comments

1. You can pull all of the information about a type of widget from the database like so:

   $text_widgets = get_option( 'widget_text' );
   

   There’s no need to use mySQL to get this. This will return an array of all the stored widgets of the type ‘text’. Then you can loop through this array and do stuff with the internal properties of each like so:

   foreach ( $text_widgets as $widget ) {
       extract( $widget );
       // now you have variables: $mainItem, $leftOne, $leftTwo, etc.
       // do something with variables  
   }
   

   Or, if you already know the ID’s of the widgets you want to interact with, you can access the properties like this:

   $mainItem = $text_widgets[17]['mainItem'];
   

   Log in to Reply

2. Try below code snippet. It return the array of all widgets stored data.

   //  1. Initialize variables
   $data = '';
   $all_stored_widgets = array();
   
   //  2. Get all widgets using - `$GLOBALS['wp_widget_factory']`
   $all_widgets = $GLOBALS['wp_widget_factory'];
   foreach ($all_widgets->widgets as $w => $value) {
   
       $widget_data = get_option( 'widget_' . $value->id_base );
   
       foreach ($widget_data as $k => $v) {
           if( is_numeric( $k ) ) {
               $data['id'] = "{$value->id_base}-{$k}";
               $data['options'] = $v;
               $all_widgets_css[$value->id_base][] = $data;
           }
       }
   }
   
   // 3. Output:
   echo '<pre>';
   print_r( $all_stored_widgets );
   echo '</pre>';
   

   Output:

   

   Log in to Reply