Min ini gagal upload file kenapa yaa 'Upload LOI Gagal!'
<?php
class pro {
private $mysqli;
function __construct($conn) {
$this->mysqli = $conn;
}
public function tampil($id = null) {
$db = $this->mysqli->conn;
$sql = "SELECT * FROM perorangan";
if($id != null) {
$sql = " WHERE id_loi = $id";
}
$query = $db->query($sql) or die ($db->error);
return $query;
}
public function tambah($cif, $nama_nasabah, $cabang, $no_rek_tujuan, $sms_1, $phone_1, $nama_pen_rek, $cab_penerima, $nama_pen_kuasa, $no_id, $no_hp_pen_kuasa, $tgl_mulai, $tgl_akhir, $keterangan, $intrk_1, $intrk_2, $intrk_3, $intrk_4, $intrk_5, $intrk_6, $intrk_7, $intrk_8, $dormant, $upload_loi, $ket_callback) {
$db = $this->myslqi->conn;
$db->query("INSERT INTO perorangan VALUES ('', '$cif', '$nama_nasabah', '$cabang', '$no_rek_tujuan', '$sms_1', '$phone_1', '$nama_pen_rek', '$cab_penerima', '$nama_pen_kuasa', '$no_id', '$no_hp_pen_kuasa','$tgl_mulai', '$tgl_akhir', '$keterangan', '$intrk_1', '$intrk_2', '$intrk_3', '$intrk_4', '$intrk_5', '$intrk_6', '$intrk_7', '$intrk_8', '$dormant', '$upload_loi', '$ket_callback')") or die ($db->error);
}
}
?
<?php
include "models/m_pro.php";
$perorangan = new pro($connection);
?>
<div class="row">
<div class="col-lg-12">
<h1> Data <small>LOI Perorangan</small></h1>
<ol class="breadcrumb">
<li><a href=""><i class="icon-dashboard"></i>Perorangan</a></li>
<li class="active"><i class="icon-file-alt"></i></li>
</ol>
</div>
</div><!-- /.row -->
<div class="row justify-content-md-center">
<div class="col col-lg-12">
<div class="table-responsive">
<table class="table table-bordered table-hover table-striped">
<tr>
<th>NO.</th>
<th>CIF</th>
<th>NAMA NASABAH</th>
<!--<th>CABANG</th>
<th>NO REKENING TUJUAN</th>-->
<th>NO HANDPHONE 1</th>
<!--<th>NO HANDPHONE 2</th>
<th>NAMA REKENING PENERIMA</th>
<th>CABANG PENERIMA</th>-->
<th>NAMA PENERIMA KUASA</th>
<!--<th>NO IDENTITAS</th>-->
<th>NO HANDPHONE PENERIMA KUASA</th>
<th>TANGGAL BERLAKU</th>
<th>TANGGAL BERAKHIR</th>
<!--<th>KETERANGAN</th>
<th>INTRUKSI 1</th>
<th>INTRUKSI 2</th>
<th>INTRUKSI 3</th>
<th>INTRUKSI 4</th>
<th>INTRUKSI 5</th>
<th>INTRUKSI 6</th>
<th>INTRUKSI 7</th>
<th>INTRUKSI 8</th>
<th>AKTIVASI REKENING DORMANT</th>-->
<th>UPLOAD LOI</th>
<th>CALLBACK NASABAH</th>
<th>OPSI</th>
<th>OPSI</th>
</tr>
<?php
$no = 1;
$tampil = $perorangan->tampil();
while($data = $tampil->fetch_object()) {
?>
<tr>
<td align="center"><?php echo $no++."."; ?></td>
<td><?php echo $data->cif; ?> </td>
<td><?php echo $data->nama_nasabah; ?> </td>
<!--<td><?php echo $data->cabang; ?> </td>
<td><?php echo $data->no_rek_tujuan; ?> </td>-->
<td><?php echo $data->sms_1; ?> </td>
<!--<td><?php echo $data->phone_1; ?> </td>
<td><?php echo $data->nama_pen_rek; ?> </td>
<td><?php echo $data->cab_penerima; ?> </td>-->
<td><?php echo $data->nama_pen_kuasa; ?> </td>
<!--<td><?php echo $data->no_id; ?> </td>-->
<td><?php echo $data->no_hp_pen_kuasa; ?> </td>
<td><?php echo $data->tgl_mulai; ?> </td>
<td><?php echo $data->tgl_akhir; ?> </td>
<!--<td><?php echo $data->keterangan; ?> </td>
<td><?php echo $data->intrk_1; ?> </td>
<td><?php echo $data->intrk_2; ?> </td>
<td><?php echo $data->intrk_3; ?> </td>
<td><?php echo $data->intrk_4; ?> </td>
<td><?php echo $data->intrk_5; ?> </td>
<td><?php echo $data->intrk_6; ?> </td>
<td><?php echo $data->intrk_7; ?> </td>
<td><?php echo $data->intrk_8; ?> </td>
<td><?php echo $data->dormant; ?> </td>-->
<td><?php echo $data->upload_loi; ?> </td>
<td><?php echo $data->ket_callback; ?> </td>
<td align="center">
<button class="btn btn-info btn-xs"><i class="fa fa-edit"></i>Edit</button>
</td>
<td align="center">
<button class="btn btn-danger btn-xs"><i class="fa fa-trash-o"></i>Delete</button>
</td>
</tr>
<?php
}?>
</table>
</div>
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#tambah"> Add Data</button>
<div id="tambah" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Add Data LOI</h4>
</div>
<form action="" method="post" enctype="multipart/form-data">
<div class="modal-body">
<div class="form-group">
<label class="control-label" for="cif">CIF</label>
<input type="number" name="cif" class="form-control" id="cif" required>
</div>
<div class="form-group">
<label class="control-label" for="nama_nasabah">NAMA NASABAH</label>
<input type="text" name="nama_nasabah" class="form-control" id="nama_nasabah" required>
</div>
<!--<div class="form-group">
<label class="control-label" for="cabang">CABANG</label>
<select name="cabang" class="form-control" id="cabang">
<option id="cabang"></option>
<option>KC Sampoerna Strategic</option>
<option>KC Gading Serpong</option>
<option>Capem Pluit</option>
<option>Capem Puri Indah</option>
<option>KC Medan</option>
<option>Capem Kelapa Gading</option>
<option>KC Pekanbaru</option>
<option>Capem Tanah Abang</option>
<option>KC Palembang</option>
<option>KC Surabaya</option>
<option>KC Bandung</option>
<option>KC Makassar</option>
<option>KC Samarinda</option>
<option>KC Jayapura</option>
<option>KC Sorong</option>
<option>KC Rantau Parapat</option>
<option>KC Tugu Mulyo</option>
<option>KC Jababeka</option>
<option>KC Malang</option>
<option>KC Pontianak</option>
<option>KC Denpasar</option>
<option>KC Semarang</option>
<option>Cabang Virtual</option>
<option>Cabang Business Center</option>
<option>KF Batam</option>
<option>KF Solo</option>
<option>KF Jambi</option>
<option>AMC</option>
<option>KANTOR PUSAT</option>
<option>WRITE OFF</option>
</select>
</div>
<div class="form-group">
<label class="control-label" for="no_rek_tujuan">NO REKENING TUJUAN</label>
<input type="number" name="no_rek_tujuan" class="form-control" id="no_rek_tujuan">
</div>
<div class="form-group">
<label class="control-label" for="sms_1">NO HANDPHONE 1</label>
<input type="number" name="sms_1" class="form-control" id="sms_1" required>
</div>
<div class="form-group">
<label class="control-label" for="phone_1">NO HANDPHONE 2</label>
<input type="number" name="phone_1" class="form-control" id="phone_1">
</div>
<div class="form-group">
<label class="control-label" for="nama_pen_rek">NAMA REKENING PENERIMA</label>
<input type="text" name="nama_pen_rek" class="form-control" id="nama_pen_rek">
</div>
<div class="form-group">
<label class="control-label" for="cab_penerima">CABANG PENERIMA</label>
<select name="cab_penerima" class="form-control" id="cab_penerima">
<option id="cab_penerima"></option>
<option>KC Sampoerna Strategic</option>
<option>KC Gading Serpong</option>
<option>Capem Pluit</option>
<option>Capem Puri Indah</option>
<option>KC Medan</option>
<option>Capem Kelapa Gading</option>
<option>KC Pekanbaru</option>
<option>Capem Tanah Abang</option>
<option>KC Palembang</option>
<option>KC Surabaya</option>
<option>KC Bandung</option>
<option>KC Makassar</option>
<option>KC Samarinda</option>
<option>KC Jayapura</option>
<option>KC Sorong</option>
<option>KC Rantau Parapat</option>
<option>KC Tugu Mulyo</option>
<option>KC Jababeka</option>
<option>KC Malang</option>
<option>KC Pontianak</option>
<option>KC Denpasar</option>
<option>KC Semarang</option>
<option>Cabang Virtual</option>
<option>Cabang Business Center</option>
<option>KF Batam</option>
<option>KF Solo</option>
<option>KF Jambi</option>
<option>AMC</option>
<option>KANTOR PUSAT</option>
<option>WRITE OFF</option>
</select>
</div>
<div class="form-group">
<label class="control-label" for="nama_pen_kuasa">NAMA PENERIMA KUASA</label>
<input type="text" name="nama_pen_kuasa" class="form-control" id="nama_pen_kuasa" required>
</div>
<div class="form-group">
<label class="control-label" for="no_id">NO IDENTITAS</label>
<input type="number" name="no_id" class="form-control" id="no_id">
</div>
<div class="form-group">
<label class="control-label" for="no_hp_pen_kuasa">NO HANDPHONE PENERIMA KUASA</label>
<input type="number" name="no_hp_pen_kuasa" class="form-control" id="no_hp_pen_kuasa" required>
</div>
<div class="form-group">
<label class="control-label" for="tgl_mulai">TANGGAL BERLAKU</label>
<input type="date" name="tgl_mulai" class="form-control" id="tgl_mulai">
</div>
<div class="form-group">
<label class="control-label" for="tgl_akhir">TANGGAL BERAKHIR</label>
<input type="date" name="tgl_akhir" class="form-control" id="tgl_akhir">
</div>
<div class="form-group">
<label class="control-label" for="keterangan">KETERANGAN</label>
<textarea type="text" name="keterangan" class="form-control" id="keterangan"></textarea>
</div>
<div class="form-group">
<label class="control-label "for="intrk_1">INTRUKSI 1</label>
<select id="intrk_1" name="intrk_1" class="form-control">
<option selected></option>
<option>1.SURAT DIKIRIM MELALUI KUNJUNGAN PETUGAS MARKETING</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_2">INTRUKSI 2</label>
<select id="intrk_2" name="intrk_2" class="form-control">
<option selected></option>
<option>2.PENGAMBILAN DAN PENGIRIMAN DOKUMEN MELALUI KURIR ATAU PERWAKILAN YANG DIBERI KUASA</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_3">INTRUKSI 3</label>
<select id="intrk_3" name="intrk_3" class="form-control">
<option selected></option>
<option>3.PEMBUKAAN DAN/ATAU PERUBAHAN DATA DAN/ATAU PENUTUPAN REKENING CIF DAN/ATAU TABUNGAN DAN/ATAU GIRO</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_1">INTRUKSI 4</label>
<select id="intrk_4" name="intrk_4" class="form-control">
<option selected></option>
<option>4.PENEMPATAN DAN/ATAU PERUBAHAN DATA DAN/ATAU PENCAIRAN DEPOSITO</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_1">INTRUKSI 5</label>
<select id="intrk_5" name="intrk_5" class="form-control">
<option selected></option>
<option>5.PENYERAHAN ADVIS DEPOSITO</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_1">INTRUKSI 6</label>
<select id="intrk_6" name="intrk_6" class="form-control">
<option selected></option>
<option>6.DEBET TRANSFER UNTUK TRANSFER/PEMINDAHBUKUAN</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_1">INTRUKSI 7</label>
<select id="intrk_7" name="intrk_7" class="form-control">
<option selected></option>
<option>7.PENYERAHAN CEK/BG (HANYA MELALUI KURIR DAN NASABAH)</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="intrk_8">INTRUKSI 8</label>
<select id="intrk_8" name="intrk_8" class="form-control">
<option selected></option>
<option>8.PENYERAHAN BUKU TABUNGAN (PASSBOOK) UNTUK PERTAMA KALI</option>
</select>
</div>
<div class="form-group">
<label class="control-label "for="dormant">AKTIVASI REKENING DORMANT</label>
<select id="dormant" name="dormant" class="form-control">
<option selected></option>
<option>YA</option>
<option>TIDAK</option>
</select>
</div>-->
<div class="form-group">
<label class="control-label" for="uplod_loi">UPLOAD LOI</label>
<input type="file" name="uplod_loi" class="form-control" id="uplod_loi" required>
</div>
<!--<div class="form-group">
<label class="control-label" for="ket_callback">CALLBACK NASABAH</label>
<textarea type="text" name="ket_callback" class="form-control" id="ket_callback"></textarea>
</div>-->
<div class="modal-footer">
<button type="reset" class="btn btn-danger">Reset</button>
<input type="submit" class="btn btn-success" name="tambah" value="Simpan">
</div>
</div>
</form>
<?php
if(@$_POST['tambah']) {
$cif = $connection->conn->real_escape_string($_POST['cif']);
$nama_nasabah = $connection->conn->real_escape_string($_POST['nama_nasabah']);
//$cabang = $connection->conn->real_escape_string($_POST['cabang']);
//$no_rek_tujuan = $connection->conn->real_escape_string($_POST['no_rek_tujuan']);
//$sms_1 = $connection->conn->real_escape_string($_POST['sms_1']);
//$phone_1 = $connection->conn->real_escape_string($_POST['phone_1']);
//$nama_pen_rek = $connection->conn->real_escape_string($_POST['nama_pen_rek']);
//$cab_penerima = $connection->conn->real_escape_string($_POST['cab_penerima']);
//$nama_pen_kuasa = $connection->conn->real_escape_string($_POST['nama_pen_kuasa']);
//$no_id = $connection->conn->real_escape_string($_POST['no_id']);
//$no_hp_pen_kuasa = $connection->conn->real_escape_string($_POST['no_hp_pen_kuasa']);
//$tgl_mulai = $connection->conn->real_escape_string($_POST['tgl_mulai']);
//$tgl_akhir = $connection->conn->real_escape_string($_POST['tgl_akhir']);
//$keterangan = $connection->conn->real_escape_string($_POST['keterangan']);
//$intrk_1 = $connection->conn->real_escape_string($_POST['intrk_1']);
//$intrk_2 = $connection->conn->real_escape_string($_POST['intrk_2']);
//$intrk_3 = $connection->conn->real_escape_string($_POST['intrk_3']);
//$intrk_4 = $connection->conn->real_escape_string($_POST['intrk_4']);
//$intrk_5 = $connection->conn->real_escape_string($_POST['intrk_5']);
//$intrk_6 = $connection->conn->real_escape_string($_POST['intrk_6']);
//$intrk_7 = $connection->conn->real_escape_string($_POST['intrk_7']);
//$intrk_8 = $connection->conn->real_escape_string($_POST['intrk_8']);
//$dormant = $connection->conn->real_escape_string($_POST['dormant']);
//$ket_callback = $connection->conn->real_escape_string($_POST['ket_callback']);
$extensi = explode(".". $_FILES['upload_loi']['name']);
$upload_loi = "pro-" .round(microtime(true)).".".end($extensi);
$sumber = $_FILES['upload_loi']['tmp_name'];
$upload = move_uploaded_file($sumber, "assets/img/pro/".$upload_loi);
if($upload) {
$perorangan->tambah($cif, $nama_nasabah, $cabang, $no_rek_tujuan, $sms_1, $phone_1, $nama_pen_rek, $cab_penerima, $nama_pen_kuasa, $no_id, $no_hp_pen_kuasa, $tgl_mulai, $tgl_akhir, $keterangan, $intrk_1, $intrk_2, $intrk_3, $intrk_4, $intrk_5, $intrk_6, $intrk_7, $intrk_8, $dormant, $upload_loi, $ket_callback);
header("location: ?page=loipro");
} else {
echo "<script>alert('Upload LOI Gagal!')</script>";
}
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
3 Kontribusi 0 Poin
atau respon:
Jawaban
Ada beberapa kemungkinan penyebab mengapa gagal upload file. justru untuk koding nya sendiri ada bocor php karena di baris 27 ada ? kurang ?>
Namun, beberapa kemungkinan penyebab gagalnya upload file adalah:
Namun, beberapa kemungkinan penyebab gagalnya upload file adalah:
- Ukuran file terlalu besar sehingga melebihi batas maksimum yang diperbolehkan oleh server.
- Jenis file tidak diperbolehkan untuk diunggah oleh server. Sebagai contoh, server mungkin tidak mengizinkan unggahan file dengan ekstensi tertentu.
- Ada kesalahan pada kode untuk mengunggah file. Misalnya, fungsi untuk mengunggah file belum diimplementasikan dengan benar atau ada kesalahan penulisan kode.
- terima kasih @yukari06 upload berhasil masuk ke folder tetapi data tidak masuk ke database - @dwinurpriyanto
Login untuk gabung berdiskusi
Pertanyaan Lainnya
Top Kontributor
- @ahanafi
813 Kontribusi 551 Poin
- @Nandar
647 Kontribusi 204 Poin
- @dianarifr
642 Kontribusi 316 Poin
- @Saputroandhi
509 Kontribusi 162 Poin
- @dodipsitorus
412 Kontribusi 145 Poin