Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //-- konfigurasi koneksi database
- $dbhost='localhost';
- $dbuser='root';
- $dbpass='';
- $dbname='metode_mfep';
- //-- connect to database
- $db=new mysqli($dbhost,$dbuser,$dbpass,$dbname);
- //-- query data ke database
- $sql="SELECT nama_siswa,nama_mp,nilai_akd,nilai_non_akd,sikap FROM view_rekap_nilai WHERE kode_rombel='2'&&kode_nilai='3'&&semester='1'";
- //-- inisialisasi variabel penampung
- $record=array();
- $data=array();
- $nama_siswa=array();
- $nama_mp=array();
- //-- menjalankan query ke database
- if($result=$db->query($sql)){
- //-- ambil data dan masukkan ke variabel penampung
- while($row=$result->fetch_object()){
- //-- copy data record ke variable $record utk table tanpa pivot
- $record[]=$row;
- //-- penyiapan data untuk pivot table
- if(isset($data[$row->nama_siswa])){
- if(isset($data[$row->nama_siswa][$row->nama_mp])){
- $data[$row->nama_siswa][$row->nama_mp][0]+=$row->nilai_akd;
- $data[$row->nama_siswa][$row->nama_mp][1]+=$row->nilai_non_akd;
- //$data[$row->nama_siswa][$row->nama_mp][2]+=$row->sikap;
- }else{
- $data[$row->nama_siswa][$row->nama_mp]=array($row->nilai_akd,$row->nilai_non_akd,$row);
- $nama_mp[]=$row->nama_mp;
- }
- }else{
- $data[$row->nama_siswa]=array();
- $nama_siswa[]=$row->nama_siswa;
- $data[$row->nama_siswa][$row->nama_mp]=array($row->nilai_akd,$row->nilai_non_akd,$row);
- $nama_mp[]=$row->nama_mp;
- }
- }
- $result->close();
- }
- $db->close();
- $nama_mp=array_unique($nama_mp);
- //======= Table Data sebelum di Pivot ========
- echo "<h2>Tabel Biasa</h2>";
- echo "<table border='1'>"
- ."<thead>"
- ."<th>Nama Siswa</th>"
- ."<th>Nama MP</th>"
- ."<th>Pengetahuan</th>"
- ."<th>Keteranpilan</th>"
- ."</thead>";
- for($i=0;$i<count($record);$i++){
- echo "<tbody>"
- ."<tr align='center'>"
- ."<td align='left'>".$record[$i]->nama_siswa."</td>"
- ."<td align='left'>".$record[$i]->nama_mp."</td>"
- ."<td>".$record[$i]->nilai_akd."</td>"
- ."<td>".$record[$i]->nilai_non_akd."</td>"
- ."</tr>";
- }
- echo "<tr align='center'>"
- ."<td align='left' colspan='2'>Total</td>"
- ."<td>Total?</td>"
- ."<td>Total?</td>"
- ."</tr>"
- ."</tbody>";
- echo "</table><br>";
- //======= Table Data sesudah di Pivot ========
- echo "<h2>Tabel Pivot</h2>";
- echo "<table border='1'>"
- ."<thead align='center'>"
- ."<th rowspan='2'>Nama Siswa</th>";
- for($i=0;$i<count($nama_mp);$i++){
- echo "<th colspan='2'>".$nama_mp[$i]."</th>";
- }
- echo "<th colspan='2'>Total</th>";
- echo "<th rowspan='2'>Total P & K</th></tr><tr>";
- for($i=0;$i<count($nama_mp);$i++){
- echo "<th>P</th><th>K</th>";
- }
- echo "<th>P</th><th>K</th>";
- echo "</thead>"
- ."<tbody align='center'>";
- for($i=0;$i<count($nama_siswa);$i++){
- echo "<tr>"
- ."<td align='left'>".$nama_siswa[$i]."</td>";
- $sikap=0;
- for($j=0;$j<count($nama_mp);$j++){
- echo (isset($data[$nama_siswa[$i]][$nama_mp[$j]])?"<td>".$data[$nama_siswa[$i]][$nama_mp[$j]][0]."</td>"
- ."<td>".$data[$nama_siswa[$i]][$nama_mp[$j]][1]."</td>":"<td>0</td><td>0</td>");
- //$sikap+=(isset($data[$nama_siswa[$i]][$nama_mp[$j]])?$data[$nama_siswa[$i]][$nama_mp[$j]][2]:0);
- }
- echo "<td>Total?</td><td>Total?</td>";
- echo "<td>Total?</td></tr>";
- }
- echo "</tbody>"
- ."<table>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement