jQuery DataTable返回带有数据的PHP脚本

Question

I currently have this function below:

 function renderDataTable(serviceUrl)
 {
   var $dataTable = $('#example1').DataTable({
     "ajax": serviceUrl
   });
 };

When the page is ready, I use this to send the url to set the table:

 renderDataTable('api/qnams_all.php');  // api/qnams_all.php is the serviceUrl

I'm trying to send some values to a PHP script and return the records entered by the user:

 $('#searchSubmit').on('click', function (){
   var searchbooking = $('#searchbooking').val();
   var searchquote = $('#searchquote').val();

   $.post('api/qnams_test.php', {searchbooking: searchbooking, searchquote: searchquote}, function(data)
   {
     renderDataTable('api/qnams_test.php');
     // I tried to do this as well ↓↓
     // renderDataTable('api/qnams_test.php' + data);
     // not successful
   });
 });

In the above $.post, I am sending the parameters to a different URL. I want to return the URL to the serviceUrl in renderDataTable(serviceUrl) so that the data refreshes with the new records.

Answer 1

The function in your post is a promise function on success of the post. so what ever you echo in your php script is going to be in the "data" that is the argument to the function. Try the following and see what exactly you're getting. Then use it as needed.

$.post('api/qnams_test.php', {
    searchbooking: searchbooking
    , searchquote: searchquote}
    , function(data) {
         console.log(data);
         renderDataTable(d)
    });

 function renderDataTable(d){
    for(item in d){
       if (d.hasOwnProperty(item)) {
         console.log("Key is " + item + ", value is" + d[item]);
       }
    }
 }