dow72046
2016-05-13 20:11
浏览 61

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

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.

图片转代码服务由CSDN问答提供 功能建议

我目前有以下功能:

  function renderDataTable(  serviceUrl)
 {
 var $ dataTable = $('#example1')。DataTable({
“ajax”:serviceUrl 
}); 
}; 
   
  
 

当页面准备好后,我用它来发送url来设置表:

  renderDataTable('api / qnams_all.php');  // api / qnams_all.php是serviceUrl 
   
 
 

我正在尝试将一些值发送到PHP脚本并返回用户输入的记录:

  $('#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'); 
 //我也尝试这样做↓↓
 // renderDataTable('api / qnams_test.php'+ data); 
 //不成功
})  ; 
}); 
   
 
 

在上面的$ .post中,我将参数发送到不同的URL。 我想将URL返回到 renderDataTable(serviceUrl)中的serviceUrl,以便数据刷新新记录。

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douanrang4728 2016-05-13 20:26
    已采纳

    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]);
           }
        }
     }
    
    已采纳该答案
    打赏 评论

相关推荐 更多相似问题