douchan7552
2017-04-24 22:03
浏览 16
已采纳

在wordpress页面上使用SQL

Using a plugin I'm able to use PHP on page by using [insert_php] as a tag however, whenever I try using SQL it doesn't seem to work. I tried using:

global $wpdb;
$prepared = $wpdb->get_row(
    "SELECT SiteID, SiteName
    FROM $wpdb->Site
        WHERE SiteID = 1");

echo $prepared->SiteName;
echo "test";

All I'm getting is test on the page and I've tested to see if my sql statement was at fault and it seems to be working fine so I'm guessing there's an issue with $wpdb or the way I'm outputting the data.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • douya1248 2017-04-24 22:35
    已采纳

    WordPress.org has a lot of detailed information in their reference.

    I think attempting to refer to $wpdb->Site is a likely suspect for why your code is not working. You will need to know the exact fields in the table to pull your information.

    Here is a reference for the wp_site table. I think you're actually looking for the 'domain' field, not 'sitename'.

    点赞 打赏 评论
  • drgaeqdqiiyg14608 2017-04-25 03:19

    Try replacing $wpdb->Site with the actual name of the table. I also get errors like that at first since $wpdb->table_name only works with the default wp tables.

    EDIT It should be something like this: SELECT SiteID, SiteName FROM Site WHERE SiteID = 1

    点赞 打赏 评论

相关推荐 更多相似问题