问题:
我想通过使用jQuery将链接属性中的值传递给PHP / SQL查询.
<a data-toggle="modal" href="#myModal" id="1"><i class="pull-right icon-eye-open"></i>HTML</a>
<div id="myModal" class="modal hide fade"> <div class="modal-header"> <button class="close" data-dismiss="modal">×</button> <h3>Title</h3> </div> <div class="modal-body"> <?PHP $query = "SELECT * FROM table WHERE id = ID FROM JQUERY HERE"; $result = MysqL_query($query) or die ('Error (' . MysqL_errno() . ') ' . MysqL_error()); ?> </div> <div class="modal-footer"> <a href="#" class="btn btn-info" data-dismiss="modal" >Close</a> </div> </div>
场景:
当用户单击具有data-toggle =“modal”的链接元素时,jQuery应该使用id属性(在这种情况下为1)的值,并将其发送到SQL查询,以便SQL查询将看起来像:
$query = "SELECT * FROM table WHERE id = 1";
jQuery代码:
$("a[data-toggle=modal]").click(function(){ var essay_id = $(this).attr('id'); //Find $essay set it to essay_id in PHP //Alternatively create a $_SESSION['EID'] here });
题:
这里是解决方案,
<a href="#" id="1" class="push">click</a>
在你的模态身上使用一个div,就像这样
<div class="modal-body"> <div class="something" style="display:none;"> // here you can show your output dynamically </div> </div>
现在把数据放入带有ajax调用的.something中.please检查http://api.jquery.com/jQuery.ajax/了解更多关于jquery ajax的信息.
$(function(){ $('.push').click(function(){ var essay_id = $(this).attr('id'); $.ajax({ type : 'post',url : 'your_url.PHP',// in here you should put your query data : 'post_id='+ essay_id,// here you pass your id via ajax . // in PHP you should use $_POST['post_id'] to get this value success : function(r) { // now you can show output in your modal $('#mymodal').show(); // put your modal id $('.something').show().html(r); } }); }); });