javascript - 从两个查询中检索数组以进行 ajax 调用

Question

我的 DBMS (sql server 2012) 中有两个表:pointsBadgeTable 和 EmployeeTable。

我已经使用下面的查询进行了下面的 ajax 调用，并且能够成功检索数组。

<?php
session_start();
$servername = "abc";
$connectioninfo = array(
    'Database' => 'novemberLastWeek'
);
$conn = sqlsrv_connect($servername, $connectioninfo);
if (!$conn) {
    echo 'connection failure';
    die(print_r(sqlsrv_errors() , TRUE));
}

if(isset($_POST['id']) && is_numeric($_POST['id'])){
  $q1 = "select * from pointsBadgeTable WHERE EmployeeID = '".$_POST['id']."' and WeekNumber='week51' order by pointsRewarded desc";
  // and convert it to JSON like your script above so your javascript does the rest.
  // _+_______________________________________________________________________________--

  if(($stmt = sqlsrv_query($conn, $q1)) != false){
    do {
      while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
        $result[] = $row;
      }
    } while (sqlsrv_next_result($stmt));
    sqlsrv_free_stmt($stmt);
    sqlsrv_close($conn); //Close the connnectiokn first// find the code and paste it in there
    echo json_encode($result);
  } else {
    die(print_r(sqlsrv_errors(), true)); //try
  }
} else {
header($_SERVER['SERVER_PROTOCOL'] . ' 500 Internal Server Error', true, 500);
}

?>

现在我有来自同一个数据库中的另一个表的另一个查询:

select * from EmployeeTable;

ajax调用:

$('.leaderboard li').one('click', function () {
   $.ajax({
     url: "../popupData/dataWeekly.php", 
     type: "POST",
     data: {id:$(this).find('.parent-div').data('id')},
     success: function(data){
      console.log(data);
      data = JSON.parse(data);
      $('#popup').fadeIn();
      $('#managerid').text('Reporting Manager: ' + data[0].ReportingManager);
      $('#popup-name').text('Name: ' + data[0].EmployeeName);
      $('#weeklypoints').text('Recent Weekly Points :'  + data[0].pointsRewarded +' ' +"(" +data[0].WeekNumber+")");
      $('#weeklyrank').text('Recent Weekly Rank :'  + data[0].rank +' ' +"(" +data[0].WeekNumber+")");

      //$('#comment').text('Comment weekly: ' + data[0].Comment);

       $('#gold').text(' ' +  data[0].Gold);
       $('#Silver').text(' ' +  data[0].silver);
       $('#Bronze').text(' ' +  data[0].bronze);

       // etc ..
     },
     error: function(){
       alert('failed, possible script does not exist');
     }
   });
 });

我如何在上述 PHP 中包含这两个查询并将查询中的全部信息提取到单个数组中。

请帮忙。

Answer 1

您可以嵌套 AJAX 请求:

$.get("url1.php").done(function(data1){
    $.get("url2.php").done(function(data2){
      // Do whatever you want
    });
});