Answers

• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  June 2014

  I don't see any code that will trigger the delete? What activates it?

  Editor has delete row abilities and PHP libraries for the server-side if you are interested.

  Allan
• HollowPantera Posts: 6Questions: 2Answers: 0

  June 2014 edited June 2014

  Dear Allan:

  I have a code that removes fine, and the table refreshes me, and sends me to the first page, but the code works better than I had.

  Now I want to do is add an id to each TR making a ajax call to the file where I have the records, because currently I do everything in the same file.

  The first question I asked was about that, but I could not make it work.

  This the code that I have so far (sorry for posting it here, but I can not edit the topic):

  What I want to achieve:

  <tbody>
  <tr id="delete-1">
  <td>1</td>
  <td>Milk</td>
  <td>1.000</td>
  </tr>
  <tr id="delete-2">
  <td>2</td>
  <td>Cheese</td>
  <td>2.000</td>
  </tr>
  </tbody>

  JS Code:

  <script type="text/javascript" charset="utf-8">
    $(document).ready(function() {
  
      var table = $("#example");
      var oTable = table.dataTable({
        "language": {
                    "url": "lenguaje.json"
                    }
  
      });
  
      $(document).on("click", ".delete", function() {
          var confirmmssg  = confirm("¿Delete This?");
          if(confirmmssg ){
              var celeb_id = $(this).attr("id").replace("delete-", "");
              var parent = $("#"+celeb_id);
              var row = $(this).closest("tr").get(0);
              $.ajax({
                type: "get",
                url: "deleteRecord.php?id="+celeb_id,
                data: "",
                success: function() {
                    $(parent).fadeOut(200,function() {
                      $(parent).remove();
                        oTable.fnDeleteRow(oTable.fnGetPosition(row));
                      });
                }
              });
            }
      });
    });
  
  </script>
  

  HTML Code:

            <table id="example">
                <thead>
                    <tr>
                        <th class="text-center">ID</th>
                        <th class="text-center">Name</th>
                        <th class="text-center">Age</th>
                        <th class="text-center">Action (Delete or Edit)</th>
                    </tr>
                </thead>
                <tbody>
                  <?php
  
                      $cn = mysql_connect("localhost","root");
                      $db = mysql_select_db("dbsys",$cn);
                      $sql = mysql_query("SELECT * FROM users",$cn);
  
                      while($row = mysql_fetch_array($sql)){?>
                        <tr id="<?php echo $row[0]?>">
                          <td><?php echo $row[0] ?></td>
                          <td><?php echo $row[1] ?></td>
                          <td><?php echo $row[2] ?></td>
                          <td><a href="javascript:;" id="delete-<?php echo urlencode($row[0]);?>" class="delete">Delete</a></td>
                        </tr>
  
                    <?php  }
  
                  ?>
                </tbody>
            </table>
  

  PHP code (This code do not use it, because I do not call this file with ajax, and still failed to make every TR have your ID):

  $cn = mysql_connect("localhost","root");
  $db = mysql_select_db("dbsys",$cn);
  $sql = mysql_query("SELECT * FROM users",$cn);
  @mysql_query("SET-UTF8");
  
  $first = 0; 
  $json = '{"aaData":[';
  
  function deleteProducto($parametro){
  
      $eliminar = "<a href='javascript:;' id='delete-".$parametro."' class='delete'>Borrar</a>";
      return $eliminar;
  
  }
  
   while ($row = mysql_fetch_array($sql))
   {
  
      if ($first++) $json .=',';
      $json .= '{"DT_RowId":"row_'.$row[0].'" ,';
      $json .= '"cod":"'.$row[0].'", ';
      $json .= '"nom":"'.utf8_encode($row[2]).'",';
      $json .= '"val":"'.$row[4].'",';
      $json .= '"acc":"'.deleteProducto($row[0]).'"}';
  
  }
  
  $json .= ']}';
  print $json; 
  

  Waiting for help. Greetings friends.
• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  June 2014 Answer ✓

  If you are going to Ajax load the data after a delete, I would suggest to ajax load it in the first instance - see this example.

  Allan
• HollowPantera Posts: 6Questions: 2Answers: 0

  June 2014

  Dear Allan, I make the call records via Ajax.

  To assign an ID to each TR using this code:

         "fnCreatedRow": function (nRow, aData, iDataIndex) {
             $ (nRow) attr ('id', aData [0]).;
         }
  

  And I worked excellent. At last I can do what I want.
  Too bad the refresh takes me to the first page.

  Very grateful for all your help Allan, now only remains to refresh the page where I am.

  Greetings from Chile.