单击datatable记录时仅显示第一条记录

k5ifujac  于 2021-09-29  发布在  Java
关注(0)|答案(1)|浏览(285)

当我将记录保存在表中时,它会成功地工作。
当更改预订号码并集中精力时,它也会起作用。
但当点击票号时,它只选择第一条记录,不适用于其他记录。在哪里解决问题

  1. <script>
  2. $(function() {
  3. $("#BookingNo").on("focusout", function() {
  4. $.ajax({
  5. url: "ticket-booking-status.php",
  6. type: "POST",
  7. data: {
  8. BookingNo: $("#BookingNo").val()
  9. },
  10. success: function(data) {
  11. $("#txtShowData").html(data);
  12. }
  13. });
  14. });
  15. $("#SaveTicketBooking").on("click", function() {
  16. $.ajax({
  17. url: "ticketbooking-insert.php",
  18. type: "POST",
  19. data: {
  20. SaveTicketBooking: "SaveTicketBooking",
  21. BookingNo: $('#BookingNo').val(),
  22. TicketNo: $('#TicketNo').val()
  23. },
  24. success: function(data) {
  25. $("#txtSaveTicketBooking").html(data);
  26. }
  27. });
  28. });
  29. });
  30. </script>
  31. <div class="row">
  32. <form onsubmit="return false" method="POST" class="form-horizontal" enctype="multipart/form-data">
  33. <div class="col-lg-3 col-md-3 col-sm-3">
  34. <label class="control-label" for="BookingNo">Booking No</label>
  35. <input id="BookingNo" name="BookingNo" class="form-control" type="text" placeholder="" style="width: 100%;" value="<?php echo $BookingNo; ?>" autofocus required />
  36. </div>
  37. <div class="col-lg-3 col-md-3 col-sm-3">
  38. <label class="control-label" for="TicketNo">Ticket No</label>
  39. <input type="text" id="TicketNo" name="TicketNo" class="form-control input-md" maxlength="16" pattern=".{11,}" required />
  40. </div>
  41. <div class="col-lg-3 col-md-3 col-sm-3">
  42. <label class="control-label">&nbsp;</label>
  43. <input type="submit" id="SaveTicketBooking" name="SaveTicketBooking" value="Save Booking" class="btn btn-save btn-block">
  44. </div>
  45. </form>
  46. </div>
  47. <div id="txtSaveTicketBooking"></div>
  48. <div id="txtShowData"></div>
  49. <script>
  50. $(function() {
  51. $("#EditTicketBookingShow").on("click", function() {
  52. $.ajax({
  53. url: "ticket-booking-edit.php",
  54. type: "POST",
  55. data: {
  56. EditTicketBookingShow: "EditTicketBookingShow",
  57. SrNoShow: $("#SrNoShow").val(),
  58. TicketNoShow: $("#TicketNoShow").val(),
  59. BookingNoShow: $("#BookingNoShow").val()
  60. },
  61. success: function(data) {
  62. $("#txtEditData").html(data);
  63. }
  64. });
  65. });
  66. });
  67. </script>
  68. <?php if (isset($_POST['BookingNo'])) { $BookingNo = $_POST['BookingNo']; } ?>
  69. <?php
  70. $sql = "Select * from tblTicketBooking Where BookingNo = '$BookingNo' Order By SrNo";
  71. $stmt=sqlsrv_query($conn, $sql);
  72. ?>
  73. <div style="overflow-x: auto;">
  74. <table id="viewreport" class="display" style="font-size:small">
  75. <thead>
  76. <tr>
  77. <th></th>
  78. <th>Ticket</th>
  79. </tr>
  80. </thead>
  81. <tbody>
  82. <?php
  83. while($r=sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))
  84. {
  85. $BookingNo = $r['BookingNo'];
  86. $TicketNo = $r['TicketNo']; ?>
  87. <tr>
  88. <td>
  89. <form onsubmit="return false" method="post" class="form-horizontal" enctype="multipart/form-data">
  90. <input id="SrNoShow" name="SrNoShow" type="hidden" value="<?php echo $r['SrNo']; ?>">
  91. <input id="BookingNoShow" name="BookingNoShow" type="hidden" value="<?php echo $BookingNo; ?>">
  92. <input id="TicketNoShow" name="TicketNoShow" type="hidden" value="<?php echo $TicketNo; ?>">
  93. <input type="submit" id="EditTicketBookingShow" name="EditTicketBookingShow" value="EDIT" class="btn btn-warning btn-xs">
  94. </form>
  95. </td>
  96. <td>
  97. <?php echo $TicketNo; ?>
  98. </td>
  99. </tr>
  100. <?php } ?>
  101. </tbody>
  102. </table>
  103. </div>
  104. <script type="text/javascript">
  105. $('#viewreport').removeClass('display').addClass('table table-bordered');
  106. </script>
  107. if (isset($_POST['EditTicketBookingShow']))
  108. {
  109. $BookingNo = $_POST['BookingNoShow'];
  110. $SrNo = $_POST['SrNoShow'];
  111. $TicketNo = $_POST['TicketNoShow'];
  112. $getTicket = "Select * From tblTicketBooking Where TicketNo = '$TicketNo'"; $stmtTicket = sqlsrv_query($conn, $getTicket);
  113. $rowTicket = sqlsrv_fetch_array($stmtTicket, SQLSRV_FETCH_ASSOC); ?>
  114. <script>
  115. document.getElementById("BookingNo").value = '<?php echo $rowTicket['
  116. BookingNo '] ?>';
  117. document.getElementById("TicketNo").value = '<?php echo $rowTicket['
  118. TicketNo '] ?>';
  119. </script>
  120. <?php } ?>
knsnq2tg

knsnq2tg1#

我认为您必须创建一个简单的编辑页面,例如,在编辑页面上使用get方法获取值,并像where booking no=“123”那样获取/更新
表代码

  1. <tbody>
  2. <?php
  3. while($r=sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))
  4. {
  5. $BookingNo = $r['BookingNo'];
  6. $TicketNo = $r['TicketNo'];
  7. echo '<tr>
  8. <td>1</td> <td>2nd text</td> <td><a href="edit-booking.php?'.$BookingNo.'">Edit</a></td>
  9. </tr>';
  10. }
  11. ?>

相关问题