I am looking for how to pull the Post ID from a currently active page in Wordpress using Shortcode to apply in a dynamic filter

Question

I am using Shortcode in Wordpress also using Ninja Tables. The code is pulling from a Google Spreadsheet managed by a non-developer admin person. Generally easy. I am looking to embed this in a template rather installing the shortcode manually on all posts.

Following is the shortcode snippit I am using:

[ninja_tables id="446" search=0 filter="1100" filter_column="Filter4" columns="name,address,city,website,facebook"]

I am looking for a way that the shortcode can use a variable in place of the filter value of "1100" so that it automatically fills that with the post ID of the current post. This eliminates the need to hand key the short code on the post. I would then manually add the post ID into the spreadsheet which is far easier to maintain.

I have found references to PHP programming but am not a PHP developer and not trying to get so deep into development solutions. Hoping for a simpler solution with possible variables that can read page details into the shortcode.

Answer 1

Add this to your functions.php file:

function ninja_table_by_post_id() {
    $post_id = get_the_ID();

    $shortcode = '[ninja_tables id="446" search=0 filter="' . $post_id . '" filter_column="Filter4" columns="name,address,city,website,facebook"]';

    return do_shortcode($shortcode);
}
add_shortcode('current_post_table', 'ninja_table_by_post_id');

This code creates a new shortcode called [current_post_table] that when inserted into any post/page it'll render a table filtered out by the current post ID.

Usage:

<?php echo do_shortcode('[current_post_table]'); ?>

Answer 2

If you want to put this in a template (a .php file on the server, e.g. page.php), you can use this PHP snippet:

<?php
     $page_id = get_queried_object_id();
     echo do_shortcode('[ninja_tables id="446" search=0 filter="' . $page_id . '" filter_column="Filter4" columns="name,address,city,website,facebook"]');
?>

You can pass the $page_id into the shortcode within a do_shortcode function.

This would be placed in a PHP template or even potentially a global PHP/Code snippet if you're using some sort of page builder.

If you want an All-in-One solution that uses a new shortcode that can just be placed anywhere, Edward Avalos's answer would work great