如何在Wordpress中运行mysql查询? [英] How do I run a mysql query in wordpress?

问题描述

此查询有效，并返回我想要在MySQL中得到的结果，但是如何在Wordpress中使它工作呢?

This query works and returns the results that I want in MySQL but how do I get this to work in wordpress?

SELECT * FROM `wp_usermeta` WHERE `meta_key` = 'points' AND `user_id` = '1'

我希望能够看到用户1赢得的所有积分".我需要能够在wordpress的帖子和页面上显示该积分.

I want to be able to see all the 'points' earned by user 1. I need to be able to display this on posts and pages in wordpress.

推荐答案

global $wpdb;    
$result = $wpdb->get_results( "SELECT * FROM wp_usermeta WHERE meta_key = 'points' AND user_id = '1'");
print_r($result);

阅读此.

这篇关于如何在Wordpress中运行mysql查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！