prepare($checkEmail); $stmt->bind_param("si", $email, $user_id); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { $_SESSION['error'] = "Email sudah digunakan oleh pengguna lain!"; header("Location: ./"); exit(); } $stmt->close(); // Update data jika validasi lolos $sql = "UPDATE users SET nama_lengkap = ?, no_hp = ?, email = ? WHERE id_user = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("sssi", $nama_lengkap, $no_hp, $email, $user_id); // Eksekusi update if ($stmt->execute()) { $_SESSION['success'] = "Data berhasil diperbarui!"; unset($_SESSION['old_input']); // Hapus old input setelah sukses header("Location: ./"); exit(); } else { $_SESSION['error'] = "Terjadi kesalahan saat memperbarui data!"; header("Location: ./"); exit(); } // Tutup statement $stmt->close(); } // Tutup koneksi database $conn->close(); ?>