Cara Looping Horizontal

Maaf teman2, judulnya bingung mau pakai judul apa :D. Jadi gini ceritanya. Saya punya tabel jadwal KBM seperti di bawah ini
tabel-kbm.pngtabel jadwal kbm
Berikut ini tabel di databasenya
tabel-kbm-db.pngtabel jadwal kbm database
Berikut ini adalah kode querynya
public function search_jadwal($hari,$semes,$tahun) {
		$this->db->select('*');
		$this->db->from('tb_jadwal');
		$this->db->join('tb_mapel', 'tb_mapel.mapel_id = tb_jadwal.jadwal_mapelid');
		$this->db->join('tb_kelas', 'tb_kelas.id = tb_jadwal.jadwal_kelasid');
		$this->db->join('tb_hari', 'tb_hari.hari_id = tb_jadwal.jadwal_hari');
		$this->db->join('tb_dewan_guru', 'tb_dewan_guru.guru_kode = tb_jadwal.jadwal_guruid');
		$this->db->where(['jadwal_ta' => $tahun, 'jadwal_sms' => $semes, 'jadwal_hari' => $hari]);
		$this->db->order_by('jadwal_jam_start', 'ASC');
		return $this->db->get()->result_array();
	}
ย Berikut ini kode untuk viewnya
<div class="table table-responsive">
                      <table class="table table-bordered table-striped">
                        <thead>
                          <tr>
                            <th rowspan="4" class="align-middle">No</th>
                            <th rowspan="4" class="align-middle">Nama Guru</th>
                            <th rowspan="4" class="align-middle">Kode/Id</th>
                            <th colspan="35" class="text-center">Jam KBM Ke-</th>
                          </tr>
                          <tr class="text-center">
                            <th colspan="3">1</th>
                            <th colspan="3">2</th>
                            <th colspan="3">3</th>
                            <th colspan="3">4</th>
                            <th colspan="3">5</th>
                          </tr>
                          <tr class="text-center">
                            <th colspan="3">07.30-08.40</th>
                            <th colspan="3">08.40-09.50</th>
                            <th colspan="3">10.50-12.00</th>
                            <th colspan="3">13.15-14.15</th>
                            <th colspan="3">14.15-15.15</th>
                          </tr>
                          <tr class="text-center">
                            <th>Kelas</th>
                            <th>Mapel</th>
                            <th>Ceklis</th>
                            <th>Kelas</th>
                            <th>Mapel</th>
                            <th>Ceklis</th>
                            <th>Kelas</th>
                            <th>Mapel</th>
                            <th>Ceklis</th>
                            <th>Kelas</th>
                            <th>Mapel</th>
                            <th>Ceklis</th>
                            <th>Kelas</th>
                            <th>Mapel</th>
                            <th>Ceklis</th>
                          </tr>
                        </thead>
                        <tbody>
                          <?php $i = 1; ?>
                          <?php foreach($lijad as $lj): ?>
                            <tr>
                              <td><?php echo $i; ?>.</td>
                              <td><?php echo $lj['guru_nama']; ?></td>
                              <td><?php echo $lj['jadwal_guruid']; ?></td>
                              <?php if($lj['jadwal_jam_start'] == '07:30' AND $lj['jadwal_jam_end'] == '08:40') { ?>
                                <td><?php echo $lj['kelas']; ?></td>
                                <td><?php echo $lj['mapel_nama']; ?></td>
                                <td>H/S/I/A</td>
                              <?php }else if($lj['jadwal_jam_start'] == '08:40' AND $lj['jadwal_jam_end'] == '09:50') { ?>
                                <td><?php echo $lj['kelas']; ?></td>
                                <td><?php echo $lj['mapel_nama']; ?></td>
                                <td>H/S/I/A</td>
                              <?php }else if($lj['jadwal_jam_start'] == '10:50' AND $lj['jadwal_jam_end'] == '12:00') { ?>
                                <td><?php echo $lj['kelas']; ?></td>
                                <td><?php echo $lj['mapel_nama']; ?></td>
                                <td>H/S/I/A</td>
                              <?php }else if($lj['jadwal_jam_start'] == '13:15' AND $lj['jadwal_jam_end'] == '14:15') { ?>
                                <td><?php echo $lj['kelas']; ?></td>
                                <td><?php echo $lj['mapel_nama']; ?></td>
                                <td>H/S/I/A</td>
                              <?php }else { ?>
                                <td><?php echo $lj['kelas']; ?></td>
                                <td><?php echo $lj['mapel_nama']; ?></td>
                                <td>H/S/I/A</td>
                              <?php } ?>
                            </tr>
                          <?php $i++; ?>
                          <?php endforeach; ?>
                        </tbody>
                      </table>
                    </div>

Nah pertanyaannya adalah bagaimana caranya, agar guru yg memiliki jadwal lebih 1, data nya looping ke samping sesuai dengan jadwal yg ada di tabel jadwal KBM dengan cara mengecek jadwal kbm dia yg ada di tabel database.

Mohon pencerahannya, terima kasih.
avatar Ahmad554

@Ahmad554

67 Kontribusi 20 Poin


Jawaban

Belum ada Jawaban, jadi yang pertama

Login untuk gabung berdiskusi
premium logo tube

Hey, sedang ada diskon premium untuk akses semua kelas. Lihat di sini