dqy1265 2014-04-16 16:27
浏览 46
已采纳

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

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'

  • 写回答

2条回答 默认 最新

  • dpylt7626401 2014-04-16 16:38
    关注

    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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?