How do I run a mysql query in wordpress?

Question

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'

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.

Narek · Accepted Answer · 2013-11-25 06:20:58Z

30

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

Read this.

edited Nov 25, 2013 at 6:20

answered Nov 25, 2013 at 6:01

Narek

3,8235 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

user3030176 Over a year ago

That article talks about making a plugin. I don't want to make a plugin just add some lines of code that will make the result appear on a page or post. I use the plugin Allow PHP in Post and Pages to add the php query code into. Is there another/easier way?

Narek Over a year ago

You can try add global $wpdb; before query code. It need to help, but I didn't try. I updated the code.

user3030176 Over a year ago

This is what shows up on the page when I enter your code above into the "add php plugin": Array ( [0] => stdClass Object ( [umeta_id] => 38 [user_id] => 1 [meta_key] => points [meta_value] => 1 ) [1] => stdClass Object ( [umeta_id] => 39 [user_id] => 1 [meta_key] => points [meta_value] => 100 ) [2] => stdClass Object ( [umeta_id] => 40 [user_id] => 1 [meta_key] => points [meta_value] => 66 ) [3] => stdClass Object ( [umeta_id] => 41 [user_id] => 1 [meta_key] => points [meta_value] => 32 ) etc...

user3030176 Over a year ago

I want to be able to add all the values up. I'm guessing I use Select SUM * From... When I do, I just get: array ( ) on my page

user3030176 Over a year ago

ok I got pretty close. I used: global $wpdb; $result = $wpdb->get_results( "SELECT SUM(meta_value) FROM wp_usermeta WHERE meta_key = 'points' AND user_id = '1'"); print_r($result); and got: Array ( [0] => stdClass Object ( [SUM(meta_value)] => 615 ) ) I just want the number 615. How do I get ride of the other stuff on that line.

|

jaydeep namera · Accepted Answer · 2013-11-25 06:01:43Z

2

Use following code.....

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

It will return array as result.

answered Nov 25, 2013 at 6:01

jaydeep namera

1,0748 silver badges15 bronze badges

2 Comments

user3030176 Over a year ago

where can I even type this in though? I have a plugin called "Allow PHP in Post and Pages" and I tried the code there. This is the error it gives me: Fatal error: Call to a member function get_results() on a non-object in /homepages/8/d195441424/htdocs/test/wp-content/plugins/allow-php-in-posts-and-pages/allowphp.php(373) : eval()'d code on line 2

user3030176 Over a year ago

I'm not sure what that means.

Amit Maraiya · Accepted Answer · 2023-06-06 08:34:03Z

1

You should try following code :

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

Hope it will helpful.

edited Jun 6, 2023 at 8:34

answered Feb 3, 2022 at 7:05

Amit Maraiya

1,2502 gold badges15 silver badges27 bronze badges

2 Comments

Diego Betto Over a year ago

usually the prefix already contains the trailing _

Amit Maraiya Over a year ago

@DiegoBetto you are right, let me update the answer.

Collectives™ on Stack Overflow

How do I run a mysql query in wordpress?

3 Answers 3

11 Comments

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

11 Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related