Dynamically load information to Twitter Bootstrap modal

javascript, jquery, mysql, php, sql

Solution

here is the solution ,

<a href="#" id="1" class="push">click</a>

use a div on your modal body , like this

    <div class="modal-body">  

             <div class="something" style="display:none;">
                    // here you can show your output dynamically 
             </div>
    </div>

now put data into the `.something` with ajax calling .please check http://api.jquery.com/jQuery.ajax/ to know more about 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);
           }
    });


});

   });

Problem

Problem: I would like to transfer by using jQuery a value in an link-attribute to PHP/SQL query. HTML code: ``` <a data-toggle="modal" href="#myModal" id="1"><i class="pull-right icon-eye-open"></i>HTML</a> ``` PHP code: ``` <div id="myModal" class="modal hide fade"> <div class="modal-header"> <button class="close" data-dismiss="modal">&times;</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> ``` Scenario: When the user clicks the link-element that has data-toggle="modal" then jQuery should take the value of the id-attribute (which is 1 in this case) and send it to the SQL-query so that the SQL query would look like: ``` $query = "SELECT * FROM table WHERE id = 1"; ``` jQuery code: ``` $("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 }); ``` Question: How do I use jQuery to set a variable ($essay) in PHP? or how can I create a session variable in PHP through jQuery?

Original source