Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <link rel="stylesheet" href="css/bootstrap.min.css" />
- <link rel="stylesheet" href="css/font-awesome.min.css" />
- <link rel="stylesheet" href="css/style.css" />
- </head>
- </html>
- <body>
- <?php include 'koneksi.php'; ?>
- <div class="container">
- <div class="row">
- <div class="col-md-2"></div>
- <div class="col-md-8">
- <h1 class="h1 text-center">ID3 Algorithm</h1>
- </div>
- </div>
- <div class="row">
- <div class="col-md-2"></div>
- <div class="col-md-8">
- </div>
- <div class="col-md-2"></div>
- </div>
- <div class="row">
- <div class="col-md-2"></div>
- <div class="col-md-8">
- <div class="table-responsive">
- <table class="table table-bordered table-condensed table-hover">
- <tr>
- <th>Nama</th>
- <th>tugas1</th>
- <th>tugas2</th>
- <th>uts</th>
- <th>uh</th>
- <th>uas</th>
- <th>nilai akhir</th>
- </tr>
- <?php
- $query = "SELECT * FROM nilai_siswa";
- $data = mysqli_query($konek,$query);
- foreach($data as $w)
- {
- ?>
- <tr>
- <td><?= $w['nama'] ?></td>
- <td><?= $w['tugas1'] ?></td>
- <td><?= $w['tugas2']?></td>
- <td><?= $w['UH'] ?></td>
- <td><?= $w['UTS'] ?></td>
- <td><?= $w['UAS']?></td>
- <td><?= $w['Nilai_Akhir']?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- </div>
- </div>
- <br>
- <!-- menghitung siswa lulu dan tidak -->
- <?php
- $siswa = "SELECT COUNT(Nilai_Akhir) as jumlah from nilai_siswa";
- $datasis = mysqli_query($konek,$siswa);
- $resultsis = mysqli_fetch_array($datasis);
- echo "jumlah siswa ".$resultsis['jumlah'];
- echo "<br>";
- $lulus = "SELECT COUNT(Nilai_Akhir) as jumlah from nilai_siswa where Nilai_Akhir>=75";
- $datalul = mysqli_query($konek,$lulus);
- $resultlul = mysqli_fetch_array($datalul);
- echo "jumlah siswa lulus ".$resultlul['jumlah'];
- echo "<br>";
- $gagal = "SELECT COUNT(Nilai_Akhir) as jumlah from nilai_siswa where Nilai_Akhir<75";
- $datagag = mysqli_query($konek,$gagal);
- $resultgag = mysqli_fetch_array($datagag);
- echo "jumlah siswa gagal ".$resultgag['jumlah'];
- echo "<br>";
- echo "<hr>";
- // <!-- menghitung data total tabel nilai uas -->
- $uastotal = "SELECT COUNT(UAS) as jumlah FROM nilai_siswa";
- $duastot = mysqli_query($konek,$uastotal);
- $resultot = mysqli_fetch_array($duastot);
- echo "jumlah total uas ".$resultot['jumlah'];
- echo "<br>";
- // <!-- menghitung data total tabel nilai uts -->
- $utstotal = "SELECT COUNT(UTS) as jumlah FROM nilai_siswa";
- $dutstot = mysqli_query($konek,$utstotal);
- $resultot2 = mysqli_fetch_array($dutstot);
- echo "jumlah total uts ".$resultot2['jumlah'];
- echo "<br>";
- echo "<hr>";
- // <!-- menghitung data lulus dan gagal tabel nilai uts -->
- $uts = "SELECT COUNT(UTS) as jumlah FROM nilai_siswa where UTS >=75";
- $duts = mysqli_query($konek,$uts);
- $result = mysqli_fetch_array($duts);
- echo "jumlah uts lulus ".$result['jumlah'];
- echo "<br>";
- $uts2 = "SELECT COUNT(UTS) as jumlah FROM nilai_siswa where UTS <75";
- $duts2 = mysqli_query($konek,$uts2);
- $result2 = mysqli_fetch_array($duts2);
- echo "jumlah uts gagal ".$result2['jumlah'];
- echo "<br>";
- echo "<hr>";
- // <!-- menghitung data lulus dan gagal tabel nilai uts -->
- $uas = "SELECT COUNT(UAS) as jumlah FROM nilai_siswa where UAS >=75";
- $duas = mysqli_query($konek,$uas);
- $result = mysqli_fetch_array($duas);
- echo "jumlah uas lulus ".$result['jumlah'];
- echo "<br>";
- $uas2 = "SELECT COUNT(UAS) as jumlah FROM nilai_siswa where UAS <75";
- $duas2 = mysqli_query($konek,$uas2);
- $result2 = mysqli_fetch_array($duas2);
- echo "jumlah uas gagal ".$result2['jumlah'];
- echo "<br>";
- // $total= 0;
- // echo "jumlah ".$total = $resultot['jumlah']+$resultgag['jumlah'];
- // <!-- mencari entropy semseta -->
- // <!-- <?php
- $entropytot = 0;
- if (is_numeric($lulus) && is_numeric($gagal) && is_numeric($siswa)) {
- $entropytot = (-($lulus/$siswa)*log($lulus/$siswa,2)+(-($gagal/$siswa)*log($gagal/$siswa,2)));
- }
- echo "<br>";
- echo "entropynya : ".$entropytot;
- ?>
- </div>
- </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement