Postingan lainnya
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