PHP Showing A Sum Result of a Column Value

Question

I am trying to show a sum result of a column name ref_com from wp_users table in my wordpress site.For this I have written following code but it is showing an Array text as output value.What's wrong I am doing? Below is my code

<?php 
     $result=$wpdb->get_results("SELECT sum(ref_com) as result FROM ".$wpdb->prefix."users WHERE referredby = '$username'");  
     echo $result; 
?>

You have an sql injection vulnerability.

RAZERZ
– RAZERZ

2017-12-15 08:03:24 +00:00
Commented Dec 15, 2017 at 8:03 — RAZERZ
– RAZERZ, Commented Dec 15, 2017 at 8:03
how can i avoid this

Mithu
– Mithu

2017-12-15 08:10:41 +00:00
Commented Dec 15, 2017 at 8:10 — Mithu
– Mithu, Commented Dec 15, 2017 at 8:10

riza · Accepted Answer · 2017-12-15 04:17:13Z

2

The get_results function by default returns array of row objects. So if you just directly do echo $result it will print Array. Try to do echo $result[0]->result instead.

answered Dec 15, 2017 at 4:17

riza

6916 silver badges10 bronze badges

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

Comments

Arun Kumaresh · Accepted Answer · 2017-12-15 04:13:23Z

1

loop through the array and echo the result

foreach($result as $r){

 echo $r->result;

}

answered Dec 15, 2017 at 4:13

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

Collectives™ on Stack Overflow

PHP Showing A Sum Result of a Column Value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related