0) { echo ""; } if ($ukuran_file <= 5000000) { if ($tipe_file == "image/jpeg" || $tipe_file == "image/png") { $upload = move_uploaded_file($sumber, "img/" . $gambar); mysqli_query($con, "INSERT INTO tb_peripheral (id_peripheral, kd_peripheral, nama_karyawan, nama_brg, dep, merk, type, gambar, tanggal, keterangan) VALUES ('$id_peripheral','$kd_peripheral', '$nama_karyawan', '$nama_brg','$dep','$merk', '$type', '$gambar', '$tanggal', '$ket')") or die(mysqli_error($con)); echo ""; } else { echo ""; } } else { echo ""; } } else if (isset($_POST['edit'])) { $id = $_POST['id']; $kd_peripheral = trim(mysqli_real_escape_string($con, $_POST['kd_peripheral'])); $nama_karyawan = trim(mysqli_real_escape_string($con, $_POST['nama_karyawan'])); $nama_brg = trim(mysqli_real_escape_string($con, $_POST['nama_brg'])); $dep = trim(mysqli_real_escape_string($con, $_POST['nama_karyawan'])); $merk = trim(mysqli_real_escape_string($con, $_POST['merk'])); $type = trim(mysqli_real_escape_string($con, $_POST['type'])); $tanggal = trim(mysqli_real_escape_string($con, $_POST['tanggal'])); $ket = trim(mysqli_real_escape_string($con, $_POST['ket'])); if (isset($_POST['ubah_gambar'])) { $extensi = explode(".", $_FILES['gambar']['name']); $gambar = "gbr-" . round(microtime(true)) . "." . end($extensi); $sumber = $_FILES['gambar']['tmp_name']; $ukuran_file = $_FILES['gambar']['size']; $tipe_file = $_FILES['gambar']['type']; if ($ukuran_file <= 5000000) { if ($tipe_file == "image/jpeg" || $tipe_file == "image/png") { } else { echo ""; } } else { echo ""; } if (!$upload = move_uploaded_file($sumber, "img/" . $gambar)) { echo ""; } else { $upload = move_uploaded_file($sumber, "img/" . $gambar); $sql_user = mysqli_query($con, "SELECT * FROM tb_peripheral WHERE id_peripheral = '$id'") or die(mysqli_error($con)); while ($data = mysqli_fetch_array($sql_user)) { unlink("img/" . $data['gambar']); } mysqli_query($con, "UPDATE tb_peripheral SET kd_peripheral = '$kd_peripheral', nama_karyawan = '$nama_karyawan', nama_brg = '$nama_brg', dep = '$dep', merk = '$merk', type = '$type', tanggal = '$tanggal', gambar = '$gambar', keterangan = '$ket' WHERE id_peripheral = '$id'") or die(mysqli_error($con)); echo ""; } } else { mysqli_query($con, "UPDATE tb_peripheral SET kd_peripheral = '$kd_peripheral', nama_karyawan = '$nama_karyawan', nama_brg = '$nama_brg', dep = '$dep', merk = '$merk', type = '$type', tanggal = '$tanggal', keterangan = '$ket' WHERE id_peripheral = '$id'") or die(mysqli_error($con)); echo ""; } }