PHP-CodeIgniter：如何通过Javascript删除相应的html表行值

Question

In my codeigniter project i'm using a Table in which it is dynamically generated by Ajax. on the each row there is a button to Delete the corresponding row from Html Table and Mysql table too.

i tried it already. and i get the code to remove Html table row , and it follows

$(document).on('click', '#deleteRow', function() {
 
     $(this).parent().parent().remove();
 
});

and it worked. but i want to delete that corresponding row from Mysql too. so first of all , it needs to be pass the corresponding row informations from javascript. then pass this to the Controller via URL.?

window.location.href = "<?php echo base_url("settings/remove_company"); ?>?id="+current;

How i get corresponding row informations such as company_id, lic_id (field names of html table).? any help would be greatly appreciated .

Answer 1

Add attributes to the <tr>

<tr data-companyId="<?php echo $companyId;?>" data-licId="<?php echo $licId;?>">

In your jQuery, get those attributes on click of delete link:

$(document).on('click', '#deleteRow', function() {     
  var companyId = $(this).parent().parent().attr('data-companyId');
  var licId = $(this).parent().parent().attr('data-licId');
  $(this).parent().parent().remove();
});

Even, you can do object caching (using variable instead of object to improve performance.

$(document).on('click', '#deleteRow', function() {
  var obj = $(this).parent().parent();
  var companyId = obj.attr('data-companyId');
  var licId = obj.attr('data-licId');
obj.remove();
});