toString(); $nik = trim(mysqli_real_escape_string($con, $_POST['nik'])); $nama = trim(mysqli_real_escape_string($con, $_POST['nama'])); $jk = trim(mysqli_real_escape_string($con, $_POST['jk'])); $dep = trim(mysqli_real_escape_string($con, $_POST['dep'])); $jabatan = trim(mysqli_real_escape_string($con, $_POST['jabatan'])); $email = trim(mysqli_real_escape_string($con, $_POST['email'])); $telp = trim(mysqli_real_escape_string($con, $_POST['telp'])); $uuid = substr($uuid, 0, 5); $sql_cek_identitas = mysqli_query($con, "SELECT * FROM tb_nama WHERE nik = '$nik'") or die(mysqli_error($con)); if (mysqli_num_rows($sql_cek_identitas) > 0) { echo ""; } else { mysqli_query($con, "INSERT INTO tb_nama (id_karyawan, nik, nama_karyawan, jenis_kelamin, dep, jabatan, email, no_telp) VALUES ('$uuid','$nik', '$nama', '$jk', '$dep','$jabatan','$email','$telp')") or die(mysqli_error($con)); echo ""; } } else if (isset($_POST['edit'])) { $id = $_POST['id']; $nik = trim(mysqli_real_escape_string($con, $_POST['nik'])); $nama = trim(mysqli_real_escape_string($con, $_POST['nama'])); $jk = trim(mysqli_real_escape_string($con, $_POST['jk'])); $dep = trim(mysqli_real_escape_string($con, $_POST['dep'])); $jabatan = trim(mysqli_real_escape_string($con, $_POST['jabatan'])); $email = trim(mysqli_real_escape_string($con, $_POST['email'])); $telp = trim(mysqli_real_escape_string($con, $_POST['telp'])); $sql_cek_identitas = mysqli_query($con, "SELECT * FROM tb_nama WHERE nik = '$nik' AND id_karyawan != '$id'") or die(mysqli_error($con)); if (mysqli_num_rows($sql_cek_identitas) > 0) { echo ""; } else { mysqli_query($con, "UPDATE tb_nama SET nik = '$nik', nama_karyawan = '$nama', jenis_kelamin = '$jk', dep = '$dep', jabatan ='$jabatan', email = '$email', no_telp = '$telp' WHERE id_karyawan = '$id'") or die(mysqli_error($con)); echo ""; } }