为了便于示例，我假设您已将相关表复制到WordPress DB，并将其命名wp_my_xtra_table 它包含3列（id、num\\u val、str\\u val）。

function wpse106832_shortcode_demo( $atts ) {
    global $wpdb;

    extract( shortcode_atts( array(
        \'id\' => 1
    ), $atts ) );

    $table_row = $wpdb->get_row(
        \'SELECT * \' .
        \'FROM \' . $wpdb->prefix . \'my_xtra_table \' .
        \'WHERE id = \' . $id, ARRAY_A
    );

    if ( ! empty( $table_row ) ) {
        return \'<table><tr>\' .
                 \'<th>ID</th>\' .
                 \'<th>Numeric Value</th>\' .
                 \'<th>String Value</th>\' .
             \'</tr>\' .
             \'<tr>\' .
                 \'<td>\' . $table_row[\'id\'] . \'</td>\' .
                 \'<td>\' . $table_row[\'num_val\'] . \'</td>\' .
                 \'<td>\' . $table_row[\'str_val\'] . \'</td>\' .
             \'</tr></table>\';
    } else {
        return \'<p>Nothing found.</p>\';
    }
}
add_shortcode( \'wpse106832\', \'wpse106832_shortcode_demo\' );

Related Reading