php - 如何在没有服务器错误的情况下将数据表用于 jquery？

问题描述

编辑：错别字已删除，数据表库正在工作并应用于表格，但是在将窗口缩放到移动尺寸时，响应式扩展（现在添加了 cdn）不起作用。

我是数据表的初学者，我正在尝试转换我的表，以便它可以响应。最初我收到一个错误，这意味着我必须添加 thead 和 tbody 标签，但是现在我收到了一个内部服务器错误。

<?php
   if(!$_SESSION['loggedin']){
       //User is not logged in
       echo "<h1>Access Denied</h1>";
       echo "<script> window.location.assign('index.php?p=login'); </script>";
       exit;
   }
?>

<div class="card container mt-5">
   <div class="card-body">
       <br><h1 id="RemoveScorecard">Your scorecards:</h1>

       <ul id="scoreTable">
       <?php
           
        echo "<table id='scorecards' border='1' style='width:90%;'>
               <thead>
                   <tr>
                       <th>Scorecard <br>(click number to delete scorecard)</th>
                       <th>Hole 1</th>
                       <th>Hole 2</th>
                       <th>Hole 3</th>
                       <th>Hole 4</th>
                       <th>Hole 5</th>
                       <th>Hole 6</th>
                       <th>Hole 7</th>
                       <th>Hole 8</th>
                       <th>Hole 9</th>
                       <th>Hole 10</th>
                       <th>Hole 11</th>
                       <th>Hole 12</th>
                       <th>Hole 13</th>
                       <th>Hole 14</th>
                       <th>Hole 15</th>
                       <th>Hole 16</th>
                       <th>Hole 17</th>
                       <th>Hole 18</th>
                       <th>Account number</th>
                       <th>Delete?</th>
                   </tr>
               </thead>";
           
       $query = "SELECT * FROM scorecards WHERE user_id = :userid";
       $result = $DBH->prepare($query);
       $result->bindParam(':userid', $_SESSION['userData']['user_id']);
       $result->execute();            
           
       while($row = $result->fetch(PDO::FETCH_ASSOC)) {
               echo "<tbody>";
                   echo "<tr>";
                       echo "<td  style='text-align:center;'>" . $row['scorecard_id']. "</td>";
                       echo "<td>" . $row['place_1_name']. "</td>";
                       echo "<td>" . $row['place_2_name']. "</td>";
                       echo "<td>" . $row['place_3_name']. "</td>";
                       echo "<td>" . $row['place_4_name']. "</td>";
                       echo "<td>" . $row['place_5_name']. "</td>";
                       echo "<td>" . $row['place_6_name']. "</td>";
                       echo "<td>" . $row['place_7_name']. "</td>";
                       echo "<td>" . $row['place_8_name']. "</td>";
                       echo "<td>" . $row['place_9_name']. "</td>";
                       echo "<td>" . $row['place_10_name']. "</td>";
                       echo "<td>" . $row['place_11_name']. "</td>";
                       echo "<td>" . $row['place_12_name']. "</td>";
                       echo "<td>" . $row['place_13_name']. "</td>";
                       echo "<td>" . $row['place_14_name']. "</td>";
                       echo "<td>" . $row['place_15_name']. "</td>";
                       echo "<td>" . $row['place_16_name']. "</td>";
                       echo "<td>" . $row['place_17_name']. "</td>";
                       echo "<td>" . $row['place_18_name']. "</td>";
                       echo "<td>" . $row['user_id']. "</td>";
                       echo "<td>Delete</td>";
                   echo "</tr>";
               echo "</tbody>";
   }
           echo "</table>";
       
       ?>
       </ul>

   </div>
</div>

<script>
   $('#scorecards').DataTable({
              responsive: true
       });
</script>

<script src="./js/remove.js"></script>

<a href="index.php">Back to homepage</a>

如果这有帮助的话，它由 plesk 托管，尽管错误日志文件没有显示任何内容。

我正在使用 php 模板作为标头，其中包括用于数据表的 cdn。

谢谢你的帮助！

标签： phpjquerydatatables

php - 如何在没有服务器错误的情况下将数据表用于 jquery？

问题描述

解决方案

推荐阅读