Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Inputan Gagal dan Tidak Tersimpan dalam Database
Saya sedang menginputkan data nama kedalam Database, pada waktu saya mau nginput data urutan ke-55 tiba tiba muncul error data tersebut gagal tersimpan / gagal terinput seperti gambar berikut :
Gagal Input.jpg
Berikut Codingan full Input Data :
<!DOCTYPE html>
<?php
include('koneksi.php');
$query ="SELECT COUNT(*) FROM data_training";
$result = mysqli_query($koneksi, $query);
if($result) {
$banyak_data = mysqli_fetch_array($result);
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Sistem Penentuan Seleksi Pegawai Baru</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<ul class="nav navbar-nav" >
<li ><a href="index.php">Home</a></li>
<li class="active"><a href="inputLatihAdmin.php">Data Training</a></li>
<li ><a href="input-data-uji.php">Data Testing</a></li>
<li ><a href="hasil-knn.php">Hasil Klasifikasi KNN</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li ><a href="logoff.php">Log Out</a></li>
</ul>
</div>
</nav>
<h1 align="center">Sistem Penentuan Seleksi Pegawai Baru</h1>
<h1 align="center"></h1>
<form class="form-horizontal" method="post" action="proses-pelatihan-datatesting.php">
<div class="form-group ">
<label class="col-sm-1 control-label">Nilai K</label>
<div class="col-sm-1 ">
<input class="form-control" placeholder="Banyak K" name="k_vall" required>
</div>
<button type="reset" class="btn btn-warning" >Reset</button>
</div>
<div class="form-group">
<div class=" col-sm-offset-1 col-sm-2">
<button type="submit" class="btn btn-primary btn-block">Mulai Pelatihan</button>
</div>
</div>
<hr />
</form>
<button type="button" class="btn btn-success col-sm-offset-9 col-sm-2" data-toggle="modal" data-target="#myModal">
Input Data Training
</button>
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel">Input Data Pegawai</h4>
</div>
<form class="form-horizontal col-sm-offset-2" method="post" action="tambahDataTraining.php">
<div class="modal-body">
<div class="form-group ">
<label class="col-sm-4 control-label">Nama</label>
<div class="col-sm-6 ">
<input class="form-control" id=" "name="nama" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Nilai IPK</label>
<div class="col-sm-6">
<input class="form-control" id="" name="ipk" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Nilai Akademik</label>
<div class="col-sm-6">
<input class="form-control" id="" name="akademik" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Nilai IPTEK</label>
<div class="col-sm-6">
<input class="form-control" id="" name="iptek" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Nilai Wawancara</label>
<div class="col-sm-6">
<input class="form-control" id="" name="wawancara" required>
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">Klasifikasi</label>
<div class="col-sm-6">
<input class="form-control" id="" name="klasifikasi" required>
</div>
</div>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-primary">Simpan</button>
<button type="button" class="btn btn-default" data-dismiss="modal">Tutup</button>
</div>
</form>
</div>
</div>
</div>
<br>
<br><br />
<div class="table-responsive col-md-10 col-md-offset-1" style="height:350px;overflow:auto;">
<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Nama</th>
<th>Nilai IPK</th>
<th>Nilai Akademik</th>
<th>Nilai IPTEK</th>
<th>Nilai Wawancara</th>
<th>Klasifikasi</th>
<th>Edit Data</th>
</tr>
</thead>
<?php
//$c=0;
include("koneksi.php");
$sql = "SELECT * FROM data_training";
$query = mysqli_query($koneksi,$sql);
$result = array();
while ($data = mysqli_fetch_array($query)){
?>
<tbody>
<tr>
<td><?php echo $data[0] ?></td>
<td><?php echo $data[1] ?></td>
<td><?php echo $data[2] ?></td>
<td><?php echo $data[3] ?></td>
<td><?php echo $data[4] ?></td>
<td><?php echo $data[5] ?></td>
<td><?php echo $data[6] ?></td>
<td align="center" width="140">
<a href="form-edit-datatraining.php?id=<?php echo $data[0] ?>" class="btn btn-success btn-sm">
<span class="glyphicon glyphicon-edit" aria-hidden="true"></span> Edit
</a>
<a href="deleteDataTraining.php?id=<?php echo $data[0] ?>" class="btn btn-danger btn-sm">
<span class="glyphicon glyphicon-remove" aria-hidden="true"></span> Del
</a>
</td>
</tr>
</tbody>
<?php }
?>
</table>
</div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
Berikut codingan full Fungsi logika input datanya :
<?php
include('koneksi.php');
$nama = $_POST['nama'];
$ipk = $_POST['ipk'];
$akademik = $_POST['akademik'];
$iptek = $_POST['iptek'];
$wawancara = $_POST['wawancara'];
$query = "INSERT into data_testing (nama,ipk,akademik,iptek,wawancara)
VALUES ('$nama','$ipk','$akademik','$iptek','$wawancara')
";
$result = mysqli_query($koneksi,$query);
if($result){
header("Location: input-data-uji.php");
}else{
echo "Input Gagal";
}
?>
Mohon bantuannya dari para master sekalian
0
Tanggapan
coab diperiksa mulai dari isi $querynya apakah sudha sesuai yang diinginkan
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban