php - 单击编辑按钮在 Bootstrap 模式中显示特定行数据

Question

我是编程新手，正在尝试实现 Bootstrap 模式以将 mysql 表中的行数据显示到模式窗口中。

我已经尝试通过链接在 stackoverflow 上找到的解决方案“从 mysql 表中提取信息以 Bootstrap 模式进行编辑”。但是无法显示带有 $row['SFID'] 的特定行。

我可以拉取表格数据，但是当我点击任何行前面的编辑​​按钮时，它总是显示最后一行的 id

并且不在模态编辑数据的输入框中显示数据？？？。

我到现在为止，请帮助我。

<table class="table table-bordered" width="100%">
    <thead>
        <tr>
            <th>SFID</th>
            <th>Company</th>
            <th>Product</th>
            <th>Product Line</th>
            <th>Dealer Class</th>
            <th>Status</th>
        </tr>
    </thead>
    <?php
        $query = "SELECT * FROM tblcustomer";
        $stmt = $db->prepare($query);
        $stmt->execute();

        foreach ($stmt as $row): ?>
            <tr>
    <?php $rowID = $row['SFID']; ?>

                <td><?php echo $row['SFID']; ?></td>
                <td><?php echo $row['CompanyName']; ?></td>
                <td><?php echo $row['Product']; ?></td>
                <td><?php echo $row['ProductLine']; ?></td>
                <td><?php echo $row['DealerClass']; ?></td>
                <td><?php echo $row['RequestStatus']; ?></td>
                <td style="text-align: center">
                    <div class="btn-toolbar">
                        <div class="btn-group">
                            <a class="btn btn-danger" href="#delModal"  data-toggle="modal"><i class="icon-trash icon-white"></i> Delete</a>

            <?php echo "<a class='btn update' href='#editModal' data-sfid='".$row['SFID']."' role='button' data-toggle='modal'>Edit</a>"; ?>
 </div>
                    </div>
                </td>
             </tr>
     <?php endforeach; ?>
 </table>

---

     <div id="editModal" class="modal hide fade in" style="display: none; ">
 <div class="modal-header">
    <a class="close" data-dismiss="modal">×</a>
    <h3>Edit Customer Details</h3>
</div>
 <div>
<form class="contact">
   <fieldset>
    <div class="modal-body">
        <?php echo $row['SFID']; ?> 
        <ul class="nav nav-list">
        <li class="nav-header">SFID</li>
        <li><input class="input-xlarge" type="text" name="mysfid" id="mysfid"></li>
        <!--<li class="nav-header">Company</li>
        <li><input class="input-xlarge" value=" " type="text" name="mycompany"></li>
        <li class="nav-header">Dealer Class</li>
        <li><input class="input-xlarge" value=" " type="text" name="mydealerclass"></li> -->
        </ul> 
     </div>
    </fieldset>
</form>
 </div>
 <div class="modal-footer">
    <button class="btn btn-success" id="submit">Approved</button>
      <a href="#" class="btn" data-dismiss="modal">Close</a>
 </div>
</div>

---

  <script>
    $(document).ready(function(){
    $('a.edit').click(function(){
    var sfid = $(this).data('sfid');
    var company = $(this).data('company');
    var dealerclass = $(this).data('dealerclass');    

    $('#mysfid').val(sfid);
    $('#mycompany').val(company);
    $('#mydealerclass').val(dealerclass);
    });

    });
    </script>

感谢您的帮助。

Answer 1

<table class="table table-bordered" width="100%">
    <thead>
        <tr>
            <th>SFID</th>
            <th>Company</th>
            <th>Product</th>
            <th>Product Line</th>
            <th>Dealer Class</th>
            <th>Status</th>
        </tr>
    </thead>
    <?php
        $query = "SELECT * FROM tblcustomer";
        $result = mysql_query($query);
        $i=1;
        while($row = mysql_fetch_assoc($result))
        {
    ?>
            <tr>
    <?php $rowID = $row['SFID']; ?>

                <td><?php echo $row['SFID']; ?></td>
                <td><?php echo $row['CompanyName']; ?></td>
                <td><?php echo $row['Product']; ?></td>
                <td><?php echo $row['ProductLine']; ?></td>
                <td><?php echo $row['DealerClass']; ?></td>
                <td><?php echo $row['RequestStatus']; ?></td>
                <td style="text-align: center">
                    <div class="btn-toolbar">
                        <div class="btn-group">
                            <a class="btn btn-danger" href="#delModal"  data-toggle="modal"><i class="icon-trash icon-white"></i> Delete</a>

                            <a class="btn update" href="#editModal<?php echo$i?>" data-sfid='"<?php echo $row['SFID'];?>"' data-toggle="modal">Edit</a>
                            <!--Yor Edit Modal Goes Here-->
                            <div id="editModal<?php echo $i; ?>" class="modal hide fade in" role="dialog" ria-labelledby="myModalLabel" aria-hidden="true">
                             <div class="modal-header">
                                <a class="close" data-dismiss="modal">×</a>
                                <h3>Edit Customer Details</h3>
                            </div>
                             <div>
                            <form class="contact">
                               <fieldset>
                                <div class="modal-body">
                                    <?php echo $row['SFID']; ?> 
                                    <ul class="nav nav-list">
                                    <li class="nav-header">SFID</li>
                                    <li><input class="input-xlarge" type="text" name="mysfid" id="mysfid"></li>
                                    <!--<li class="nav-header">Company</li>
                                    <li><input class="input-xlarge" value=" " type="text" name="mycompany"></li>
                                    <li class="nav-header">Dealer Class</li>
                                    <li><input class="input-xlarge" value=" " type="text" name="mydealerclass"></li> -->
                                    </ul> 
                                 </div>
                                </fieldset>
                            </form>
                             </div>
                             <div class="modal-footer">
                                <button class="btn btn-success" id="submit">Approved</button>
                                  <a href="#" class="btn" data-dismiss="modal">Close</a>
                             </div>
                            </div>

                             </div>
                    </div>
                </td>
             </tr>
     <?php $i++; } ?>
 </table>