Okay
  Public Ticket #1221262
create table with php input file
Closed

Comments

  •  2
    wouterdeprez started the conversation

    Hi,

    i'm creating some tables through php input files. This file needs to access some data of the current logged in user to create the corresponding output.

    (We tried to work to read from session but that didn't work)

    But then we read that it would also be possible to use placeholders in the url ("it is allowed to use placeholders (variables) in URLs. Read about placeholders here.") with would be a great solution to this problem.

    So we tried this: http://sdtevents.be/wp-content/mu-plugins/includes/SDTTeamPromoTracker.php?user_id=%CURRENT_USER_ID%

    but %CURRENT_USER_ID% is just treated as a string and sent as is (so not translated to the user id).

    Are we doing something wrong here? Also were would it be possible to set the %VAR% placeholders for the php input file?

    thanks a lot!


    best regards

    wouter


  •  1,846
    Miloš replied

    Hi Wouter,
    Thank you for your purchase.

    No, you are not doing anything wrong.

    Sorry to disappoint you but unfortunately this functionality to use placeholders with php serialized array is not available at the moment.
    We have some plans to implement this feature for future version but for now it is not possible.

    Sorry for any inconvenience and thank you for understanding.

    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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

  •  2
    wouterdeprez replied

    Hi

    thanks for your reply. Anyway we need to find a temporary workaround then as this functionality is very important for our application..

    I tried it this way: when user clicks a button on a page, an ajax call is triggered. A timestamp coupled on the userid is stored in the database, then a new generated datatable is send back to the page through this: echo do_shortcode( '[wpdatatable id=25]' ); The php file that renders the serialized data for the table recovers the user login through the timestamp in the database so that the table can be generated with user specific data. So far, so good,

    BUT while the echo do_shortcode sends a bunch of the datatable html back to the page (after the ajax request), the table doesn't render at all (same shortcode 'hardcoded' in the page does render the table perfectly when page loads).

    We really need to get this dynamically generated datatable to work, why does the table does not render correctly after being received through ajax request?

    If you have other ideas to make this work, of course this would be welcome as well!

    thanks in advance for your input!!

    best regards

    wouter

  •  2
    wouterdeprez replied

    Hi, as addition to the question below:

    The ajax request does render the table, but not the table_wrapper, which basically makes the table useless. Additionally, the css display property of the table is automatically set to none..

    We also tried through a jquery load (as described in previous reply, to dynamically (re)generate the table through php file). It loads the table from another page. When user selects some parameters and clicks button, the jquery reloads this other 'hidden' page and 'imports' the div where the table is in the current page. But same problem here, only the table renders without the wrapper. So only <table id="table_1" class="scroll display etc..

    So please can you help us to create a workaround for this problem. Maybe we can adapt some code in the plugin file so the php file table generating does accept parameters? I would think that this should be possible without too much hassle and only a slight code change?

    Anyway, your help here is much appreciated!

    thanks

    best regards wouter






  •  1,846
    Miloš replied

    Hi Wouter,

    This functionality is high on our priority list for future updates.
    Due to our support and company policy unfortunately I am not allowed to give that custom solutions to customers and it would be not fair to other customers that have similar request that one are not covered in the included support for the plugin.
    Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code.
    As you're developing some custom solution if you need our assistance we can offer you our paid customization service.

    Sorry again and thank you for understanding. 

    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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

  •  2
    wouterdeprez replied

    Hi,

    ok I understand.

    How much would this custom solution cost (so that table generation from php file accepts parameters)?

    And how long would it take?

    thanks


  •  1,846
    Miloš replied

    Hi Wouter,

    I will need to forward this to my developers so as soon as I have an answer I will get back to you.


    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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

  • Henkwp replied

    Uhm Wouter and Bogdan If you still havent solved your issue

    we actual solved the issue you just have to apply

    $url = self::applyPlaceholders($url);

    on line 60 in the function  curlGetData

    so that the function applyPlaceholders gets activated and then the strings get turned into the actual var or function you want to have.

    Best regards.