| Server IP : 84.32.84.191 / Your IP : 216.73.216.163 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/event/ |
Upload File : |
<?php
if (isset($_POST['nmlead']) && $_POST['nmlead']) {
// memasukan file koneksi ke database
require_once 'config/database.php';
// menyimpan variable yang dikirim Form
// $nmlead = $_POST['nmlead'];
// $alamat= $_POST['alamat'];
// $email = $_POST['email'];
// $telp = $_POST['hp'];
// $npa = $_POST['npa'];
// // cek nilai variable
// if (empty($nmlead)) {
// header('location: ./register.php?error=' .base64_encode('Nama tidak boleh kosong'));
// }
//
// if (empty($alamat)) {
// header('location: ./register.php?error=' .base64_encode('Alamat tidak boleh kosong'));
// }
//
// if (empty($email)) {
// header('location: ./register.php?error=' .base64_encode('Email tidak boleh kosong'));
// }
//
// if (empty($npa)) {
// header('location: ./register.php?error=' .base64_encode('KTA tidak boleh kosong'));
// }
// encryption dengan md5
// $password = md5($password);
$nmlead = mysqli_real_escape_string($mysqli, trim( $_POST['nmlead']));
$alamat = mysqli_real_escape_string($mysqli, trim( $_POST['alamat']));
$email = mysqli_real_escape_string($mysqli, trim( $_POST['email']));
$telp = mysqli_real_escape_string($mysqli, trim( $_POST['hp']));
$npa = mysqli_real_escape_string($mysqli, trim( $_POST['npa']));
$kd_acara = mysqli_real_escape_string($mysqli, trim( $_POST['kd_acara']));
$acara = mysqli_real_escape_string($mysqli, trim( $_POST['acara']));
// fungsi untuk membuat kode transaksi
$query_id = mysqli_query($mysqli, "SELECT RIGHT(kode_transaksi,7) as kode FROM h_regevent
ORDER BY kode_transaksi DESC LIMIT 1")
or die('Ada kesalahan pada query tampil kode_transaksi : '.mysqli_error($mysqli));
$count = mysqli_num_rows($query_id);
if ($count <> 0) {
// mengambil data kode transaksi
$data_id = mysqli_fetch_assoc($query_id);
$kode = $data_id['kode']+1;
} else {
$kode = 1;
}
// buat kode_transaksi
$tahun = date("Y");
$buat_id = str_pad($kode, 7, "0", STR_PAD_LEFT);
$kode_transaksi = "RO-$tahun-$buat_id";
include "modules/event/phpqrcode/qrlib.php";
//Nama Folder file QR Code kita nantinya akan disimpan
$tempdir = "temp/";
//jika folder belum ada, buat folder
if (!file_exists($tempdir)){
mkdir($tempdir);
}
#parameter inputan
$isi_teks = $kode_transaksi;
$namafile = $kode_transaksi.".png";
$quality = 'H'; //ada 4 pilihan, L (Low), M(Medium), Q(Good), H(High)
$ukuran = 5; //batasan 1 paling kecil, 10 paling besar
$padding = 2;
QRCode::png($isi_teks,$tempdir.$namafile,$quality,$ukuran,$padding);
$level = 'member'; // default,
$tgl=date("Y-m-d");
// SQL Insert
$sql= mysqli_query($mysqli, "INSERT INTO h_regevent(kode_transaksi,nmlead,alamat,email,telp,npa,tanggal_reg,barcode,kode_acara,acara)
VALUES('$kode_transaksi','$nmlead', '$alamat','$email', '$telp','$npa','$tgl','$namafile','$kd_acara','$acara')")
or die('Ada kesalahan pada query insert1 : '.mysqli_error($mysqli));
echo "<script>alert('Insert Data Berhasil, Cek email anda dan Simpan Barcode Untuk Registrasi Ulang di Event'); window.location.href = './event.php';</script>";
$query = mysqli_query($mysqli, "SELECT * FROM h_acara ")
or die('Ada kesalahan pada query tampil Data Masuk: '.mysqli_error($mysqli));
$data2 = mysqli_fetch_assoc($query);
$agenda = mysqli_real_escape_string($mysqli, trim( $data2['agenda']));
//Kirim email
$file_path = $tempdir.$namafile;
$email='ifi.kurnia@gmail.com';
require_once "modules/event/class.phpmailer.php";
$mail = new PHPMailer;
//(dari) email dan nama pengirim
$mail->From = "info@idikotabandung.com";
$mail->FromName = "Admin IDI Cabang Kota Bandung";
//(ke) email penerima
$mail->addAddress($email);
// $mail->addAttachment("idilogo.png");
// $mail->addAttachment($file_path);
// $surat="suratno_008_idi.jpg";
// $mail->addAttachment($surat);
// $mail->addAttachment($file_path2);
//Jika ada attach surat/pamflet dll
//$mail->addAttachment("idilogo.png");
$mail->isHTML(true);
$mail->AddEmbeddedImage($file_path, "my-attach", $namafile);
// $mail->Body = 'Your <b>HTML</b> with an embedded Image: <img src="cid:my-attach"> Here is an image!';
$mail->Subject = "Registrasi Event IDI Kota Bandung";
$mail->Body = "
Kepada Yth: Bapak/Ibu .$nmlead, <br>
<br>
$agenda,
Terimakasih atas partisipasinya,<br>
Mohon untuk Menyimpan Barcode Untuk melakukan Registrasi Ulang di Lokasi Event<br>
Untuk Informasi Hotline<br>
<br>
Hotline 1 : +62 813-2279-8252 <br>
Hotline 2 : +62 859-3918-9471 <br>
";
// //kirim email lokal
if(!$mail->send()){
echo "Email gagal dikirim: " . $mail->ErrorInfo;
}else{
echo "Email sukses dikirim";
}
// $sql = "INSERT INTO h_regevent (nama,alamat,email,telp,npa,tanggal_reg) VALUES ('$nmlead', '$alamat', '$email', '$telp','$tgl')";
//
// $insert = $mysqli->query($sql);
// // jika gagal
// if (! $insert) {
// echo "<script>alert('".$mysqli->error."'); window.location.href = './register.php';</script>";
// } else {
// echo "<script>alert('Insert Data Berhasil'); window.location.href = './event.php';</script>";
// }
}
?>