如何将表中选定的行 ID 提供给我的模型？

Question

好吧，我实际上不知道问题出在哪里，但是我的模态没有获得我选择的行的 ID。

我的模态需要获取所选行的描述。因此，如果您在我的表中选择第 2 行，您需要在我的数据库中获取 ID 2 的描述。

<tr data-toggle='modal' value=".$row["ID"]." data-target='#myModal' id=".$row["ID"].">

                                     <td>" . $row["ID"]. "</td>

                                     <td>" . $row["Name"]. " </td>

                                     <td>" . $row["Category"]. " </td>

                                     <td>" . $row["Skill"]. " </td>

                                     <td>" . $row["CareerCompetence"]. " </td>

                                     <td>" . $row["DateAdded"]. " </td>

                                     <td>" . $row["EmailUploader"]. " </td> 

                                     <td> ";

                                     ?>

                           <div class="modal fade" id="myModal" role="dialog">

                             <div class="modal-dialog">

                               <!-- Modal content-->

                               <div class="modal-content">

                                 <div class="modal-header">

                                   <?php

                                   $sql2 = "SELECT * FROM class where ID='".$row['ID']."'";

                                   $result2 = $con->query($sql2);

                                   while($row2 = $result2->fetch_assoc()) {

                                     ?>

                                   <h4 class="modal-title"><?php echo $row2["Name"]; ?></h4>

                                 </div>

                                 <div class="modal-body">

                                   <p><?php echo $row2['Descriptie'];?></p>

                                   <p><?php echo $row2['FileName'];?></p>

                                 </div>

                                 <div class="modal-footer">

                                   <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

                                 </div>

                               </div>

Answer 1

好的，现在我的一个朋友通过在我的 tr 中添加一键解决了这个问题。如果你现在点击表格中的一行，你会看到一个带有该行描述的弹出窗口。下表代码：// Head of the table<thead>&nbsp; &nbsp; <tr>&nbsp; &nbsp;<th>ID</th>&nbsp; &nbsp;<th>Name</th>&nbsp; &nbsp;<th>category</th>&nbsp; &nbsp;<th>Skills</th>&nbsp; &nbsp;<th>competenties</th>&nbsp; &nbsp;<th>date added</th>&nbsp; &nbsp;<th>Email uploader</th>&nbsp; &nbsp;<th>Visable</th>&nbsp; &nbsp;<th>Approve</th>&nbsp; &nbsp;<th>Disapprove</th></tr></thead>// Data of the table&nbsp;$data = "<p>".$row['Descriptie']."</p>"; //data is the Description of the row you send it to your modal by using \"OpenModalWith('$data')"&nbsp;<tr onclick=\"OpenModalWith('$data', '".$row["Name"]."');\" data-toggle='modal' value=".$row["ID"]." data-target='#myModal' id=".$row["ID"].">&nbsp;<td>" . $row["ID"]. "</td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td>" . $row["Name"]. " </td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td>" . $row["Category"]. " </td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td>" . $Skill. " </td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td>" . $Competences. " </td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td>" . $row["DateAdded"]. " </td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td>" . $row["EmailUploader"]. " </td>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <td> ";这是模态（ row['description'] 是该行的描述）：&nbsp;<div class="modal fade" id="myModal" role="dialog">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="modal-dialog">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <!-- Modal content-->&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="modal-content">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="modal-header">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <h4 class="modal-title"></h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="modal-body">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <p><?php echo $row2['Descriptie'];?></p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="modal-footer">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>在我的 javascript 代码中，他说获取 elementbyID 因此，例如 myModal（myModal 是我的模态 ID）function OpenModalWith(content, title){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; modal = document.getElementById("myModal");&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; modaltitle = modal.getElementsByClassName("modal-title")[0];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; modalbody = modal.getElementsByClassName("modal-body")[0];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; modalbody.innerHTML = content;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; modaltitle.innerHTML = title;&nbsp; &nbsp; &nbsp; }