自定义小部件内的WordPress MySQL查询

Question

I followed guidance from here on creating a Widget in WordPress, they say to create a plugin widget which I have done and it does display Hello World as expected.

But now I want to run a mysqli query inside this widget. I can't find anywhere to supply information on this as I know the query I want to run is

SELECT * FROM wp_posts WHERE post_type = 'facts'

Answer 1

You can use $wpdb by defining global inside your widget function,It has an instance of mysql connection

class YourWidget extends WP_Widget
{
   function widget($args, $instance)
    {
    global   $wpdb;
      $Results = $wpdb->get_results("SELECT * FROM wp_posts
       WHERE post_type = 'facts' AND post_status='publish'");
      var_dump($Results); /* to see what you got from query */
    }

}

Reference wpdb