我有一个使用while循环创建的按钮.所以while循环为
mysql表中的每一行创建一个表行.
@H_403_14@
如果,我告诉你了.
我有一行代码用于按钮,它为表的每一行再次创建,每个按钮具有基于该记录的id的不同值.
$order .= '<td><a href="#myModal" class="btn btn-default btn-small" id="custId" data-toggle="modal" data-id="'.$row['ID'].'">Edit</a></td>';
问题是我想使用$row [‘ID’]并以模态查看它,所以我可以使用MysqLi查询检索具有相同ID的记录.
这是模态的代码.
<div class="modal fade" id="myModal" role="dialog"> <div class="modal-dialog"> <!-- Modal content--> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title">Edit Data</h4> </div> <div class="modal-body"> i want to save the id in a variable here so i can use it in a PHP script for this modal </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> </div> </div> </div> </div>
带有$row [‘ID’]的模态触发按钮
$order .= '<td><a href="#myModal" class="btn btn-default btn-small" id="custId" data-toggle="modal" data-id="'.$row['ID'].'">Edit</a></td>';
使用Ajax方法获取$row [‘ID’]值的Bootstrap Modal事件
$(document).ready(function(){ $('#myModal').on('show.bs.modal',function (e) { var rowid = $(e.relatedTarget).data('id'); $.ajax({ type : 'post',url : 'fetch_record.PHP',//Here you will fetch records data : 'rowid='+ rowid,//Pass $id success : function(data){ $('.fetched-data').html(data);//Show fetched data from database } }); }); });
模态HTML
<div class="modal fade" id="myModal" role="dialog"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal">×</button> <h4 class="modal-title">Edit Data</h4> </div> <div class="modal-body"> <div class="fetched-data"></div> //Here Will show the Data </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> </div> </div> </div> </div>
最后创建fetch_record.PHP,检索记录并以模态显示
<?PHP //Include database connection if($_POST['rowid']) { $id = $_POST['rowid']; //escape string // Run the Query // Fetch Records // Echo the data you want to show in modal } ?>