jarvis Posted September 24, 2020 Share Posted September 24, 2020 Hi All, I use a jQuery datatable to display information from a search. The results are posted back via Ajax to a default table placeholder like so: <table id="example" class="table table-striped table-responsive hide-me" style="width:100%"> <thead> <tr> <th>Sponsor</th> <th>Nationality</th> <th>Sector</th> <th>Team Sponsored</th> <th>Sport</th> </tr> </thead> <tfoot> <tr> <th>Sponsor</th> <th>Nationality</th> <th>Sector</th> <th>Team Sponsored</th> <th>Sport</th> </tr> </tfoot> </table> This is handled by the following: $(document).on('click', '.taxonomy-sponsor-link', function(){ var action = 'get_sponsors_by_taxonomy'; var id = $(this).data('id'); var tax = $(this).data('tax'); //alert('action: '+action+' tax: '+tax+' id: '+id); //assing the datatable call to a variable let example = $('#example').DataTable({ "destroy": true, "responsive":{//this is usefull if you want to use a full responsive datatable just add the responsive css from dataTables.net "details": { renderer: function ( api, rowIdx, columns ) { var data = $.map( columns, function ( col, i ) { return col.hidden ? '<tr data-dt-row="'+col.rowIndex+'" data-dt-column="'+col.columnIndex+'">'+ '<td>'+col.title+':'+'</td> '+ '<td>'+col.data+'</td>'+ '</tr>' : ''; } ).join(''); return data ?$('<table/>').append( data ) :false; } } }, "autoWidth": false,//fix Bootstrap 4 glitch "ajax": { method :"POST", url : '<?php echo admin_url('admin-ajax.php');?>', data : {action:action,tax:tax,id:id,}, }, "columns": [ {"data": "sponsor"}, {"data": "nationality"}, {"data": "sector"}, {"data": "team_sponsored"}, {"data": "sport"} ], "columnDefs": [ { //"className": "dt-center", "targets": "_all" "className": "", "targets": "_all" } ] }); example.on( 'xhr', function ( e, settings, json ) {// check is the response is not null and show the table if (json != null) { $('#example').removeClass("hide-me",""); } } ); }); And my PHP gathers the data and passes it back via: echo json_encode($json); What I'd like to do, is also pass 1 other value from the results but not in the table. So wanted to use something like: <div id="search-results-header"></div> After an bit of searching, I can see you can alter the json_encode to be an array, so something like: echo json_encode(array( 'example' => $json, 'search-results-header' => $search )); However, I then can't work out whether: a) This is correct b) How I adjust the above call to output the table results AND the additional parameter. I wonder if someone would be kind enough to please assist? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/ Share on other sites More sharing options...
requinix Posted September 24, 2020 Share Posted September 24, 2020 44 minutes ago, jarvis said: What I'd like to do, is also pass 1 other value from the results but not in the table. So wanted to use something like: <div id="search-results-header"></div> What? Do you want to add that markup to the page? Or are you trying to return a value from PHP that should be inserted into that DIV which is already written on the page? Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581544 Share on other sites More sharing options...
jarvis Posted September 24, 2020 Author Share Posted September 24, 2020 @requinix I was going aiming to to insert it into that div. So table content goes to table and additional info to here. Or is it better to do it another way? Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581545 Share on other sites More sharing options...
requinix Posted September 24, 2020 Share Posted September 24, 2020 So what you need is to be able to customize how the DataTable does the AJAX request, right? You can perform the actual request yourself, then give the DataTable just the "example" data while you borrow the "search-results-header" data for something else. When in doubt, check the documentation. Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581546 Share on other sites More sharing options...
jarvis Posted September 24, 2020 Author Share Posted September 24, 2020 Thanks @requinix When I previously tried ajaxifying the content, the search on the table didn't work. The code above worked and still enables the search functionality I just can't quite see how to do/integrate the other part Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581547 Share on other sites More sharing options...
requinix Posted September 24, 2020 Share Posted September 24, 2020 The thing you pass as the "ajax" value needs to be a function. It take a few arguments, as seen in the documentation, and when it's done it uses the callback function it received. What code do you have trying to do that? What do you expect to happen when you view the table and what actually happens? Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581552 Share on other sites More sharing options...
jarvis Posted September 25, 2020 Author Share Posted September 25, 2020 Hi @requinix I tried to adjust example.on( 'xhr', function ( e, settings, json ) {// check is the response is not null and show the table if (json != null) { $('#example').removeClass("hide-me",""); jQuery(".search-results-header").html(data); } } ); I also tried adding d.search-results-header = $('#search-results-header').val(); Into the render part of the code I'll be honest, I'm struggling to make sense of it, hence turning to this forum for assistance. I'd previously read the link you sent and struggled to make sense of it. I also Google'd for examples, hence basing my code on someone else's example and adapting to my requirements. Less than ideal I know but got my code working. A lot of examples I found were using GET whereas I needed POST. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581558 Share on other sites More sharing options...
requinix Posted September 25, 2020 Share Posted September 25, 2020 Not the xhr event. I said "ajax". As in what I linked to in the documentation. As in "ajax": { method :"POST", url : '<?php echo admin_url('admin-ajax.php');?>', data : {action:action,tax:tax,id:id,}, }, that. Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581561 Share on other sites More sharing options...
jarvis Posted September 25, 2020 Author Share Posted September 25, 2020 I see what you're saying but I'm still at a loss, I can see the docs but I cannot fathom how to do what I need "ajax": { "method" :"POST", "url" : '<?php echo admin_url('admin-ajax.php');?>', "data": function ( d ) { return $.extend( {action:action,tax:tax,id:id}, d, { "searchResultsHeader": $('.search-results-header').val() } ); } } ?? Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581562 Share on other sites More sharing options...
requinix Posted September 25, 2020 Share Posted September 25, 2020 Seems like you're kinda just guessing. Quote As a function, making the Ajax call is left up to yourself allowing complete control of the Ajax request. Indeed, if desired, a method other than Ajax could be used to obtain the required data, such as Web storage or a Firebase database. When the data has been obtained from the data source, the second parameter (callback here) should be called with a single parameter passed in - the data to use to draw the table. If you make the "ajax" a function instead of an object, then you can do whatever you want. Like make your own AJAX request. When you do that, you'll get back the information that the DataTable wants as well as the header string thing. Put the header string thing into your header element thing, then use the "callback" to hand the table data off for processing. Quote Link to comment https://forums.phpfreaks.com/topic/311516-ajax-post-data-to-jquery-datatable-and-return-another-value/#findComment-1581564 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.