Okay
  Public Ticket #2828728
Embedding links within table results
Closed

Comments

  • Todd started the conversation

    My customer has asked whether or not we can have an embedded URL within the result set of the wpDataTable plugin.  

    I currently return data like this:

    Rank Name Points

    1 John Doe 150

    2 Jane Smith 125

    I'd like the Name to be a hyperlink to a new query, and with any luck a dynamic sql that would take as a parameter the name, pass it to a new SQL query and display a second table.

    Anyone ever done something like this?

  •  2,507
    Aleksandar replied

    Hello Todd

    I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.

    New tables can't be created dynamically, so what you're asking for to achieve can't be done. 

    You can use dynamic placeholders, though. Please take a look.

    You can create a table with a query like this:

    SELECT user_id, user_name, user_address,
    CONCAT('<a href="http:/yoursite.com/your_custom_page?user_id=',user_id,'">Details</a>') AS Details
    FROM your_table_name

    Then, on your_custom_page you will insert a shortcode of the table ID that you need, with a placeholder like this:

    [wpdatatable id=1 var1=1]

    The second table would be created from a query like this:

    SELECT * FROM second_table WHERE user_id = %VAR1%

    After that, you can use a hook for dynamic placeholders:

    function updateVAR1($tableID){  global $wdtVar1;
          //check is set GET parametar user_id
        if(isset($_GET['user_id'])){
            //get value from form fieald
            $wdtVar1 = $_GET['user_id'];
        }
      }
    add_action('wpdatatables_before_get_table_metadata', 'updateVAR1');

    I hope this helps.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables