Cara multi membuat insert dan update dalam satu form source code input dan edit nilai dalam satu form
<?php
include "../templates/header.php";
include "../templates/sidebar.php";
?>
<?php
// pengaturan
require "../kalakayxxx/functions_kbm.php";
//mengambil data base kerjasama
$id = $_GET["id"];
$kbm = query_kbm("SELECT * FROM ajar_dosen WHERE id = $id")[0];
?>
<?php
$id_kbm = $kbm["id"];
?>
<?php
require "../kalakayxxx/functions_kuliah.php";
//mengambil data base kerjasama
$data_kuliah = query_kuliah ("SELECT * FROM perkuliahan WHERE id_kbm = '$id_kbm' ORDER BY id_perkuliahan ");
?>
<?php
require "../kalakayxxx/functions_tampilabsen.php";
//mengambil data base kerjasama
$tampil = query_tabsen ("SELECT * FROM krs WHERE id_kbm = '$id_kbm' ORDER BY id ");
$total_mahasiswa = count(query_tabsen ("SELECT * FROM krs WHERE id_kbm = '$id_kbm' ORDER BY id "));
$tm = $total_mahasiswa+1
?>
<!-- Pengaturan nilai -->
<?php
// pengaturan
require "../kalakayxxx/functions_nilai.php";
#Proses kedua untuk menambahkan data ke database dengan perulangan
if( isset($_POST ["submit"]) ) {
// var_dump($_POST);
// die;
for ($i= 1; $i < $_POST['total_mahasiswa'] ; $i++) {
$id = $_POST ['id'.$i];
$nim = $_POST ['nim'.$i];
$nama = $_POST ['nama'.$i];
$kode_mk = $_POST ['kode_mk'];
$nama_mk = $_POST ['nama_mk'];
$nama_kelas = $_POST ['nama_kelas'];
$semester = $_POST ['semester'];
$kode_jurusan = $_POST ['kode_jurusan'];
$status_error = $_POST ['status_error'];
$nilai_huruf = $_POST ['nilai_huruf'.$i];
$nilai_indek = $_POST ['nilai_indek'.$i];
$nilai_angka = $_POST ['nilai_angka'.$i];
$keterangan = $_POST ['keterangan'.$i];
//memisahkan fungsi insert dan update
$result = mysqli_query($koneksi,"SELECT * FROM nilai where id = '$id'");
// menghitung jumlah data yang ditemukan
if ( mysqli_num_rows($result) === 1 ) {
//gunakan fungsi update
$result = mysqli_query($koneksi, "UPDATE nilai SET
nim = '$nim',
nama = '$nama',
kode_mk = '$kode_mk',
nama_mk = '$nama_mk',
nama_kelas = '$nama_kelas',
semester = '$semester',
kode_jurusan = '$kode_jurusan',
status_error = '$status_error',
keterangan = '$keterangan',
nilai_huruf = '$nilai_huruf',
nilai_indek = '$nilai_indek',
nilai_angka = '$nilai_angka'
WHERE id = $id
");
}else{
$result = mysqli_query($koneksi, "INSERT INTO nilai (id, nim, nama, kode_mk, nama_mk, nama_kelas, semester, kode_jurusan, status_error, keterangan, nilai_huruf, nilai_indek, nilai_angka)
VALUES ('', '$nim', '$nama', '$kode_mk', '$nama_mk', '$nama_kelas', '$semester', '$kode_jurusan', '$status_error', '$keterangan', '$nilai_huruf', '$nilai_indek', '$nilai_angka')");
}
}
}
?>
<!-- Begin Page Content -->
<div class="container-fluid">
<!-- Page Heading -->
<div class="alert alert-light shadow-sm"role="alert">
<h1 class="h3 mb-0 text-gray-800"><i class="fa fa-university"></i> DAFTAR NILAI MAHASISWA </h1>
<br>
<a class="btn btn-sm btn-primary" href="<?php echo base_url(); ?>/unisa/data/pembelajaran/absensi_mahasiswaCetak.php?id=<?php echo $id_kbm ?>"><i class="fas fa-fw fa-print"></i> Cetak Nilai Mahasiswa</a>
</div>
<!-- Content Row -->
<div class="card shadow mb-4">
<div class="card-body">
<strong>Identitas Mata Kuliah</strong>
<table>
<tr> <td>Kode Mata Kuliah </td> <td>: <?php echo $kbm["kode_mk"]?></td></tr>
<tr> <td>Nama Mata Kuliah </td> <td>: <?php echo $kbm["nama_mk"]?></td></tr>
<tr> <td>Total Pertemuan </td> <td>: <?php echo $kbm["rencana_tatap_muka"]?>
<tr> <td>Kelas </td> <td>: <?php echo $kbm["nama_kelas"]?></td></tr> <br>
</tr>
</table>
<br>
<div id="dataTable_wrapper" class="dataTables_wrapper dt-bootstrap4">
<div class="row">
<div class="col-sm-12">
<table class="table table-bordered dataTables" width="100%">
<thead>
<tr>
<td width="20px" rowspan="2" > <br><center>NO</center></td>
<td rowspan="2" ><br><center>NIM</center></td>
<td rowspan="2"><br><center>Nama</center> </td>
<td colspan="3"><center>Nilai</center></td>
<td rowspan="2"><br><center>Ket</center> </td>
</tr>
<tr>
<td>Angka</td>
<td><center>Hurup</center></td>
<td><center>Bobot</center></td>
</tr>
</thead>
<form method="POST" action="">
<?php $no = 1; ?>
<?php $i = 0; ?>
<?php foreach( $tampil as $row_tampil ) : ?>
<tr>
<td><?php echo $no++; $i++; ?></td>
<td>
<?php echo $row_tampil["nim"];?>
<input type="hidden" name="kode_mk" value="<?php echo $kbm["kode_mk"]?>">
<input type="hidden" name="nama_mk" value="<?php echo $kbm["nama_mk"]?>">
<input type="hidden" name="nama_kelas" value="<?php echo $kbm["nama_kelas"]?>">
<input type="hidden" name="semester" value="<?php echo $kbm["semester"]?>">
<input type="hidden" name="kode_jurusan" value="<?php echo $kbm["kode_jurusan"]?>">
<input type="hidden" name="status_error">
<input width="20px" type="hidden" name="nim<?php echo $i ?>" value="<?php echo $row_tampil["nim"];?>" class="form-control form-control-sm">
</td>
<td>
<?php echo $row_tampil["nama"];?>
<input type="hidden" name="nama<?php echo $i ?>" value="<?php echo $row_tampil["nama"];?>" class="form-control form-control-sm">
</td>
<td width="20px">
<?php include "../kalakay/resto_conn.php";
$npm = $row_tampil["nim"];
$name = $row_tampil["nama"];
$query=mysqli_query ($koneksi, "SELECT * FROM nilai WHERE nim ='$npm' AND nama = '$name' ORDER BY id");
$tampil_nilai=mysqli_fetch_array($query); ?>
<div class="row g-3">
<div class="col">
<input width="20px" type="text" name="nilai_angka<?php echo $i ?>" value="<?php echo $tampil_nilai['nilai_angka']; ?>" class="form-control form-control-sm">
<input type="hidden" name="id<?php echo $i ?>" value="<?php echo $tampil_nilai['id']; ?>">
</div>
</div>
</td>
<td>
<input width="20px" type="text" name="nilai_huruf<?php echo $i ?>"
value="<?php
if ($tampil_nilai['nilai_angka'] >= 80 ){
echo"A";
}else if ($tampil_nilai['nilai_angka'] >= 65 ){
echo"B";
}else if ($tampil_nilai['nilai_angka'] >= 57 ){
echo"C";
}else{
echo"D";
}
?>" class="form-control form-control-sm" readonly>
</td>
<td>
<input type="text" name="nilai_indek<?php echo $i ?>"
value="<?php
if ($tampil_nilai['nilai_angka'] >= 80 ){
echo "4";
}else if ($tampil_nilai['nilai_angka'] >= 65 ){
echo "3";
}else if ($tampil_nilai['nilai_angka'] >= 57 ){
echo "2";
}else{
echo"1";
}
?>"class="form-control form-control-sm" readonly>
</td>
<td>
<input type="text" name="keterangan<?php echo $i ?>" class="form-control form-control-sm">
<input type="hidden" name="total_mahasiswa" value="<?php echo $tm ?>">
</td>
</tr>
<?php endforeach ?>
</table>
<center>
<button class="btn btn-sm btn-primary" type="submit" name="submit">Simpan</button>
</center>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- End of Main Content -->
<?php
include "../templates/footer.php";
?>
Yogi Iskandar
Comments
Tidak ada komentar:
"Terimakasih telah berkunjung ke blog kami, semoga anda dapat menemukan apa yang anda cari. Mohon untuk menambahkan komentar!"