短码中的SQL查询不起作用

我有一张定制的桌子\'wp-products\' 在WordPress中包含以下字段

id (primary key)  e.g 1
make              e.g. ford
model             e.g. mustang
price             e.g. 17500.00

id (primary key)  e.g 2
make              e.g. dodge
model             e.g. pheonix
price             e.g. 77500.00

我想做的是创建一个短代码，例如。[product_price id=2] 返回与此表中id号2关联的价格值，例如。77500.00. 我尝试了几种方法，最后得到了这个（下面）我把这个代码放进去了functions.php

function product_price_func( $atts ) {
    global $wpdb;
    $output = \'\';
    $product_id = \'\';

    $atts = shortcode_atts(
    array(
      \'id\' => \'no id found\',
    ), $atts, \'product_price\' );

    $product_id = $atts[\'id\'];


    $product_price = $wpdb->get_results("SELECT price FROM wp-products WHERE id={$product_id}", ARRAY_A);

    foreach ( $product_price as $the_price ) 
    {   
      $output = $the_price->price;
    }
    return "Product Price: $" . $output;
}
add_shortcode( \'product_price\', \'product_price_func\' );

但是，这将返回一个空结果。我已经检查过了id 正确，但无法获取查询以返回与id=2.

function product_price_func( $atts ) { global $wpdb;

$table_name = $wpdb->prefix . \'products\';

$atts = shortcode_atts(
array(
  \'id\' => \'no id found\',
), $atts, \'product_price\' );

$product_id = $atts[\'id\'];

$product_price = $wpdb->get_results("SELECT price FROM " . $table_name ." WHERE id={$product_id}", ARRAY_A);

foreach ( $product_price as $the_price ) 
  { 
    $output = $the_price[\'price\'];
  }

return "Product Price: $" . $output;

} add_shortcode( \'product_price\', \'product_price_func\' );

小码农CODE

相关推荐

OOP and WordPress shortcode