| Server IP : 153.92.12.52 / Your IP : 216.73.217.80 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/IDI/superadmin/importexcel/ |
Upload File : |
<?php include "header.php";
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['level']<>"supervisor"){
header("location:location:../login.php");
}
?>
<!--
File : import data ke excel dengan phpspreadsheet
Author : Hakko Bio Richard
Blog : www.hakkoblogs.com
-->
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<div class="container">
<div class="panel panel-primary">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<br>
<div class="navbar-header">
<a class="navbar-brand" href="index.php">Ikatan Dokter Indonesia</a>
</div>
</div>
</nav>
<div class="panel-body">
<fieldset>
<legend>Form Upload Excel | www.idicabbandung.com</legend>
<?php
//include('header.php');
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Csv;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
?>
<?php
if(isset($_POST['import'])){
$file_mimes = array('application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
if(isset($_FILES['berkas_excel']['name']) && in_array($_FILES['berkas_excel']['type'], $file_mimes)) {
$arr_file = explode('.', $_FILES['berkas_excel']['name']);
$extension = end($arr_file);
if('csv' == $extension) {
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
} else {
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
}
$spreadsheet = $reader->load($_FILES['berkas_excel']['tmp_name']);
$sheetData = $spreadsheet->getActiveSheet()->toArray();
for($i = 1;$i < count($sheetData);$i++)
{
$npm = $sheetData[$i]['1'];
$tgl = $sheetData[$i]['2'];
$nama = $sheetData[$i]['3'];
$status = $sheetData[$i]['4'];
$a = $sheetData[$i]['5'];
$b = $sheetData[$i]['6'];
$c = $sheetData[$i]['7'];
$d = $sheetData[$i]['8'];
$e = $sheetData[$i]['9'];
$f = $sheetData[$i]['10'];
$g = $sheetData[$i]['11'];
$h = $sheetData[$i]['12'];
$created_by = 'Admin';
$datetime = date('Y-m-d H:i:s');
$rand = '0';
// echo date('d F Y', strtotime('1994-02-15')); // Hasil 15 February 1994
// echo date('Y m d', strtotime('1994-02-15')); // Hasil 1994-02-15
//$tg2 = date('Y m d', strtotime( $tgl)); // Hasil 1994-02-15
//rubah dari nama bulan ke date
//$tgl1 = strtotime($tgl);
//$tgl2 = date('Y-m-d',$tgl1);
//echo $tgl2;
$tgl1 = strtotime($g);
$tgl2 = date('Y-m-d',$tgl1);
// mysqli_query($konek,"insert into h_anggota2 (id_tagihan,npm,tgl_daf,nmlead,status,alamat,telp,email,nostr,mbstr,ahli,tgliuran,password) values ('','$nim','$nama','$email','$telp','$a','$b','$c','$d','$e','$f','$g','$h')");
mysqli_query($konek,"insert into h_anggota2 (id_tagihan,npm,tgl_daf,nmlead,status,alamat,telp,email,nostr,mbstr,ahli,tgliuran,active,email2) values ('','$npm','$tgl','$nama','$status','$a','$b','$c','$d','$e','$f','$tgl2','1','$h')");
// mysqli_query($konek,"insert into h_import (id_tagihan,npm,nmlead,email,telp,alamat,ahli,password,status,active,tgl) values // ('','$nim','$nama','$email','$telp','$a','$b','$c','$d','$e','$f')");
}
//header("Location: form_upload.html");
echo "<b style='color :red;'>Data berhasil di upload!</b>";
}
}
?>
<p><a href="d_praktek.xlsx" style="background:yellow; color:green; border:1px;">DOWNLOAD FORMAT EXCEL</a></p>
<p><a href="index.php">home
</a><br/>
<br/>
</p>
<form method="post" enctype="multipart/form-data" action="">
<div class="form-group">
<label for="exampleInputFile">File Upload</label>
<input type="file" name="berkas_excel" class="form-control" id="exampleInputFile">
</div>
<input type="submit" class="btn btn-primary" value="Import" name="import" />
</form>
</fieldset>
</body>
</html>