Adding Duplicate Data Alert Message

thebumba0712

Hello,
I want to know how to make a pop up error message ('duplicate error') after after attempting to add a data with id that is already existing in the datatable. The script I created is already blocking data for being duplicated because I'm using a primary key in sql. I just need an error message to notify that there's already an existing id in the datatable.

colin

Is this using Editor?

If so, you could validate that the key is unique - please see the example in this section of the manual.

If not, you would scan the data before adding the row, something like:

    table.rows(function(idx) {
        if (table.row(idx).key === newKey) {
            // show error
        }
    });

Colin

thebumba0712

$(document).on('submit', '#addEmp', function(e) {
  e.preventDefault();
  var empid = $('#addEmpidField').val();
  var lastname = $('#addLastnameField').val();
  var firstname = $('#addFirstnameField').val();
  var middlename = $('#addMiddlenameField').val();
  if (empid != '' && lastname != '' && firstname != '' && middlename != ''){
    $.ajax({
      url: "add_emp.php",
      type: "post",
      data: {
        empid: empid,
        lastname: lastname,
        firstname: firstname,
        middlename: middlename
      },
      success: function(data) {
        var json = JSON.parse(data);
        var status = json.status;
        if (status == 'true') {
          mytable = $('#empList').DataTable();
          mytable.draw();
          alert('success');
          $('#addEmpidField').val('');
          $('#addLastnameField').val('');
          $('#addFirstnameField').val('');
          $('#addMiddlenameField').val('');
          $('#addEmpModal').modal('hide');

        } else {
          alert('failed');
        }
      }
    });
  } else {
    alert('Fill all the required fields');
  }
});

thebumba0712

I'm sorry I have trouble understanding validation, should I validate outside the function or add else if condition and include row count

colin

It would be worth looking at Editor - as all these conditions are handled there.

Colin