如何从Wordpress数据库中获取数组值get_results

问题描述

尝试从我的mysql查询(在Wordpress代码段内)回显数组值

Trying to echo the array value from my mysql query (inside Wordpress snippet)

function get_customer_gain() {
  global $wpdb;
  $users = $wpdb->get_results( "SELECT SUM(wp_wpdatatable_1.payback) FROM wp_wpdatatable_1");
  foreach( $users as $user ) {
    echo $user;
  }
}
add_shortcode('customer_gain', 'get_customer_gain');

我的var_dump是:array(1){[0] => object(stdClass)#3098(1){["SUM(wp_wpdatatable_1.payback)"] => string(6)"183320"}}

my var_dump is:array(1) { [0]=> object(stdClass)#3098 (1) { ["SUM(wp_wpdatatable_1.payback)"]=> string(6) "183320" } }

所以基本上我试图回传那个183320号

So basically im trying to echo that 183320 number

任何指导将不胜感激.

谢谢

推荐答案

您必须使用正确的语法 $ wpdb-> get_results($ query，$ type_of_result);

You have to use the correct syntax $wpdb->get_results( $query, $type_of_result);

在此处

编辑说明:

$users = $wpdb->get_results( "SELECT SUM(wp_wpdatatable_1.payback) as sumed FROM wp_wpdatatable_1", ARRAY_A);

array_a 将重建关联数组，而默认情况下它将作为导致问题的对象返回

The array_a will retur associative array while by default it returns as object that cause problem

这篇关于如何从Wordpress数据库中获取数组值get_results的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！