如何以模态传递当前行值? [英] How to pass current row value in modal?
问题描述
我在桌子上执行PHP CRUD操作.当我单击编辑按钮而不是将其带到新页面时,我想以模式显示值.我希望值以模态的形式显示.我创建了一个模式,但是我无法想到一种逻辑来传递单击编辑按钮的行的值.任何帮助将不胜感激.
I am perfoming PHP CRUD operations on a table. When i click the edit button rather then taking it to a new page i want to show the values in a modal. I want the value's to be displayed in the modal's form. I have created a modal but i am unable to think of an logic to pass the values of the row in which the edit button was clicked. Any help would be highly appreciated.
表格:
<table class="table datatable-basic table-bordered table-hover">
<thead>
<tr class='active'>
<th><b>S.No.</b></th>
<th><b>Name</b></th>
<th><b>Mobile Number</b></th>
<th><b>Password</b></th>
<th><b>Actions</b></th>
</tr>
</thead>
<tbody>
<?php
$sql="SELECT * from users ORDER BY name ASC" ;
$c = 1;
$results = $result->query($sql);
while($row = $results->fetch_assoc())
{
echo '<tr style="font-weight:normal;">';
echo "<td>$c</td>";
echo "<td>{$row['name']}</td>";
echo "<td>{$row['username']}</td>";
echo "<td>{$row['pass']}</td>";
echo "<td class='text-center'><ul class='icons-list'><a href='#' style='color:#000;'><i class='icon-pencil5' data-toggle='modal' data-target='#modal_edit'
data-popup='tooltip' title='Edit' data-container='body'></i></a>
<a href='delete.php?teacherid={$row['username']}' style='color:#000;'><i class='icon-cross2' data-popup='tooltip' title='Delete'
data-container='body'></i></a></ul></td>";
echo '</tr>';
++$c;
}
?>
</tbody>
</table>
我的模式是这样的:-
<div id="modal_edit" class="modal fade" style="font-weight: normal;">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h5 class="modal-title">Add Teacher</h5>
</div>
<form action="" method="POST">
<div class="modal-body">
<div class="form-group">
<div class="row">
<div class="col-sm-6">
<label>Full Name</label>
<input type="text" name="fullname" class="form-control" required>
</div>
<div class="col-sm-6">
<label>Mobile Number</label>
<input type="text" name="mobno" class="form-control" required>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-sm-6">
<label>Password</label>
<input type="password" name="password" class="form-control" required>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-link" data-dismiss="modal">Close</button>
<button type="submit" name="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
</div>
</div>
推荐答案
<?php
.
.
echo "<td class='text-center'>
<ul class='icons-list'>
<a href='#modal_edit' class='modalButton' style='color:#000;' data-teacherid='{$row['username']}' data-toggle='modal' data-target='#modal_edit' data-popup='tooltip' title='Edit' data-container='body'>
<i class='icon-pencil5'></i>
</a>";
echo "<a href='delete.php?teacherid={$row['username']}' style='color:#000;'><i class='icon-cross2' data-popup='tooltip' title='Delete'
data-container='body'></i></a></ul></td>";
echo '</tr>';
++$c;
}
?>
将此代码放在同一页中的某个位置.
Place this code somewhere, but in the same page.
<div id="modal_edit" class="modal fade" style="font-weight: normal;">
<div class="modal-dialog">
<div class="modal-content">
</div>
</div>
</div>
JS
<script>
$('.modalButton').click(function(){
var teacherid = $(this).attr('data-teacherid');
$.ajax({url:"ajax_modal_edit.php?teacherid="+teacherid,cache:false,success:function(result){
$(".modal-content").html(result);
}});
});
</script>
创建页面名称 ajax_modal_edit.php (如果您要更改此页面名称.也请更改<script></script>
标记.两者都相关.)
Create a page name ajax_modal_edit.php (If you are looking to change this page name. Change in <script></script>
tag too. Both are related.)
ajax_modal_edit.php
<?php
$teacherid = $_GET['teacherid'];
// Use this `$teacherid` in query to get all required/appropriate field
?>
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h5 class="modal-title">Add Teacher <?php echo $teacherid;?></h5>
</div>
<form action="" method="POST">
<div class="modal-body">
<div class="form-group">
<div class="row">
<div class="col-sm-6">
<label>Full Name</label>
<input type="text" name="fullname" class="form-control" required>
</div>
<div class="col-sm-6">
<label>Mobile Number</label>
<input type="text" name="mobno" class="form-control" required>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-sm-6">
<label>Password</label>
<input type="password" name="password" class="form-control" required>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-link" data-dismiss="modal">Close</button>
<button type="submit" name="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
有关更多信息,请检查传递数据通过Modal Bootstrap并获取php变量?
For more info, check Passing data via Modal Bootstrap and getting php variable?
这篇关于如何以模态传递当前行值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!