- Beranda
- Komunitas
- Tech
- Programmer Forum
Menampilkan data kesamping sesuai database


TS
lalasislamiati
Menampilkan data kesamping sesuai database
Permisi kak mau tanya ada yang bisa membantu saya mengubah isi data yang ada pada gambar kuning ini menjadi script PHP(CI)? Yang diwarnai kuning itu ngambil data dari database. Yang warna hijau biru itu hasil output codingan saya yang ngga sesuai yang diharapkan. Terima kasih



Code:
<table class="table table-striped- table-bordered table-hover table-checkable">
<thead>
<tr>
<th>NO</th>
<th>NIM</th>
<th>NAMA</th>
<?php
foreach($transkrip as $data)
{
$id_kelas_prodi = $data['id_kelas_prodi'];
}
$id_smt = $this->db->query ("select * from semester where smt='".$id."' and nm_smt='".$this->session->userdata("tahun")."'")->result_array();
$kode_prodi = $this->db->query ("select * from mahasiswa join kelas_prodi on (kelas_prodi.id_kelas_prodi=mahasiswa.id_kelas_prodi)
where mahasiswa.id_kelas_prodi='".$id_kelas_prodi."'")->result_array();
$matkul_dosen = $this->db->query ("select matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk from matkul_dosen
join mata_kuliah on(matkul_dosen.id_mk=mata_kuliah.id_mk)
where id_smt='".$id_smt[0]['id_smt']."' and kode_prodi='".$kode_prodi[0]['kode_prodi']."'
Group by matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk")->result_array();
foreach ($matkul_dosen as $key) { ?>
<th><?php echo $key['kode_mk']; ?></th>
<th><?php echo $key['sks_mk']; ?></th>
<?php } ?>
<th>JUMLAH BOBOT</th>
<th>IPS</th>
<th>Jumlah Nilai D</th>
<th>Jumlah Nilai E</th>
</tr>
</thead>
<?php
$no = 1;
$sks = array();
$nilai = array();
foreach($transkrip as $data) {
$total_uas = ($data['uas']*$data['k_uas'])/100;
$total_uts = ($data['uts']*$data['k_uts'])/100;
$total_lain = ($data['lain']*$data['k_lain'])/100;
$nilai_angka = $total_uas+$total_uts+$total_lain;
$sks[] = $data['sks_mk'];
if($nilai_angka >= 85)
{
$nilai_huruf = "A";
}
if(($nilai_angka >= 78) && ($nilai_angka <= 84.99))
{
$nilai_huruf = "AB";
}
if($nilai_angka >= 70 && $nilai_angka <= 77.99)
{
$nilai_huruf = "B";
}
if($nilai_angka >= 63 && $nilai_angka <= 69.99) {
$nilai_huruf = "BC";
}
if($nilai_angka >= 55 && $nilai_angka <= 62.99) {
$nilai_huruf = "C";
}
if($nilai_angka >= 40 && $nilai_angka <= 54.99) {
$nilai_huruf = "D";
}
if($nilai_angka > 0 && $nilai_angka <= 39.99) {
$nilai_huruf = "E";
}
if($nilai_angka == 0) {
$nilai_huruf = "";
}
if($nilai_huruf == "A") {
$nilai_indeks = 4;
}
if($nilai_huruf == "AB") {
$nilai_indeks = 3.5;
}
if($nilai_huruf == "B") {
$nilai_indeks = 3;
}
if($nilai_huruf == "BC") {
$nilai_indeks = 2.5;
}
if($nilai_huruf == "C") {
$nilai_indeks = 2;
}
if($nilai_huruf == "D") {
$nilai_indeks = 1;
}
if($nilai_huruf == "E") {
$nilai_indeks = 0;
}
if($nilai_huruf == "") {
$nilai_indeks = 0;
}
$nilai = $nilai_indeks*$data['sks_mk'];
?>
<tbody>
<tr>
<td><?php echo $no++ ?> </td>
<td><?php echo $data['nim']; ?> </td>
<td><?php echo $data['nm_pd']; ?> </td>
<?php
$id_smt = $this->db->query ("select * from semester where smt='".$id."' and nm_smt='".$this->session->userdata("tahun")."'")->result_array();
$kode_prodi = $this->db->query ("select * from mahasiswa join kelas_prodi on (kelas_prodi.id_kelas_prodi=mahasiswa.id_kelas_prodi)
where mahasiswa.id_kelas_prodi='".$data['id_kelas_prodi']."'")->result_array();
$matkul_dosen = $this->db->query ("select matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk from matkul_dosen
join mata_kuliah on(matkul_dosen.id_mk=mata_kuliah.id_mk)
join input_nilai on (input_nilai.kode_mk=mata_kuliah.kode_mk)
where id_smt='".$id_smt[0]['id_smt']."' and
kode_prodi='".$kode_prodi[0]['kode_prodi']."' and
input_nilai.kode_mk='".$data['kode_mk']."'
Group by matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk")->result_array();
foreach ($matkul_dosen as $key) { ?>
<th><?php echo $nilai_huruf; ?></th>
<th><?php echo $nilai_indeks; ?></th>
<?php } ?>
<td><?php echo $nilai; ?> </td>
</tr>
</tbody>
<?php } ?>
</table>


nona212 memberi reputasi
1
907
0


Komentar yang asik ya


Komentar yang asik ya
Komunitas Pilihan