在wordpress自定义表中使用get_resutl时出错 - error using get_resutls in wordpress custom table

error using get_resutls in wordpress custom table

我正在尝试根据当前登录的用户显示Appname和AppId列。

global $wpdb;
global $current_user;
get_currentuserinfo();
$UserId= $current_user->ID;

$siteAppIds = $wpdb->get_results($wpdb->prepare("SELECT AppID, AppNames FROM       
   app_BasicInfo WHERE WpUserId =$UserId, ARRAY_A") );

foreach ( $siteAppIds as $siteAppId) {
echo  $siteAppId-> AppNames;
}

你知道我在这里做错了什么吗？

您正在使用ARRAY_A并像object一样进行回显，

$siteAppIds = $wpdb->get_results($wpdb->prepare("SELECT AppID, AppNames FROM       
             app_BasicInfo WHERE WpUserId =$UserId, ARRAY_A") );
foreach ( $siteAppIds as $siteAppId) {
   echo  $siteAppId['AppNames'];
}

或

$siteAppIds = $wpdb->get_results($wpdb->prepare("SELECT AppID, AppNames FROM       
             app_BasicInfo WHERE WpUserId =$UserId, OBJECT") );
foreach ( $siteAppIds as $siteAppId) {
   echo  $siteAppId->AppNames;
}

阅读WPDB文档