 |
| Pass id value from a href to bootstrap modal php |
aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<button type="button" class="close"
data-dismiss="modal">
<span aria-hidden="true">×</span>
<span class="sr-only">Close</span>
</button>
<h4 class="modal-title" id="myModalLabel">
Edit CONSULTANTS
</h4>
</div>
<!-- Modal Body -->
<div class="modal-body">
<div class="fetched-data"></div>
</div>
</div>
</div>
</div>
<!-- End Modal -->
Javascript
<script>
$(document).ready(function(){
$('#myModalNorm1').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
}
});
});
});
</script>
fetch_record.php
<?php include 'include/config.php';
if($_REQUEST['rowid']) {
$con_id = $_REQUEST['rowid']; //escape string
$sql_content1="select * from list_of_consultants where consultants_id='$con_id'";
$sql_content_res1=mysql_query($sql_content1);
$content_data=mysql_fetch_array($sql_content_res1);
echo "<form method='POST'>
<div class='form-group'>
<label for='exampleInputEmail1'>Consultants Name</label>
<input type='text' class='form-control'
id='exampleInputEmail1' name='conname' value='".$content_data['consultants_name']."' placeholder='Consultants Name'/>
</div>
<div class='form-group'>
<label for='exampleInputEmail1'>Address(Title)</label>
<input type='text' class='form-control'
id='exampleInputEmail1' name='addtitle' value='".$content_data['consultants_address_title']." ' placeholder='Address(Title)'/>
</div>
<div class='form-group'>
<label for='exampleInputEmail1'>Address</label>
<textarea placeholder='Address' name='address' class='form-control'>".$content_data['consultants_address']."</textarea>
</div>
<div class='form-group'>
<label for='exampleInputEmail1'>Telephone No</label>
<input type='text' class='form-control'
id='exampleInputEmail1' name='telno' value='".$content_data['consultants_telephone']."' placeholder='Telephone No'/>
</div>
<div class='form-group'>
<label for='exampleInputEmail1'>Residence No</label>
<input type='text' class='form-control'
id='exampleInputEmail1' name='resino' value='".$content_data['consultants_recedence']."' placeholder='Residence No'/>
</div>
<input type='hidden' name='c_id' value='".$content_data['consultants_id']."'/>
<input type='submit' class='btn btn-primary' name='consult_update' value='Update'/>
<button type='button' class='btn btn-default'
data-dismiss='modal'>
Close
</button>
</form>";
}
?>
EmoticonEmoticon