Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Buat array bobot { C1 = 40%; C2 = 25%; C3 = 30%;}
- $ak=mysql_fetch_array(mysql_query("select * from kriteria order by idkriteria asc"));
- //$bobot= array($ak[kriteria]);
- //$bobot = array(0.5, 0.3, 0.2);
- //Lakukan Normalisasi dengan rumus pada langkah 2
- //Cari Max atau min dari tiap kolom Matrik
- $crMax = mysql_query("SELECT min(kriteria1_pekerjaan) as maxK1,
- max(kriteria2_penghasilan) as maxK2,
- max(kriteria3_jenis_rumah) as maxK3
- FROM tbl_matrik");
- $max = mysql_fetch_array($crMax);
- //Buat fungsi tampilkan nama
- function getNama($id){
- $q =mysql_query("SELECT * FROm tbl_warga where nik = '$id'");
- $d = mysql_fetch_array($q);
- return $d['nama'];
- }
- //Proses perangkingan dengan rumus langkah 3
- $sql3 = mysql_query("SELECT * FROM tbl_matrik");
- //Buat tabel untuk menampilkan hasil
- echo "
- <table id='example' class='display' cellspacing='0' width='100%'>
- <thead>
- <tr align='center'>
- <td>No</td>
- <td>Nama</td>
- <td>Rangking</td>
- <td>Status</td>
- </tr>
- </thead>
- ";
- $no = 1;
- //Kita gunakan rumus (Normalisasi x bobot)
- while ($dt3 = mysql_fetch_array($sql3)) {
- $rangking = round((($max['maxK1']/$dt3['kriteria1_pekerjaan'])*$bobot[0])+
- (($dt3['kriteria2_penghasilan']/$max['maxK2'])*$bobot[1])+
- (($dt3['kriteria3_jenis_rumah']/$max['maxK3'])*$bobot[2]),3);
- $status = $rangking;
- if ($status < 0.500){
- $status = 'Tidak Menerima';
- } else {
- $status = 'Menerima';
- }
- echo "<tr>
- <td align='center'>$no</td>
- <td>".getNama($dt3['nik'])."</td>
- <td align='center'>$rangking</td>
- <td align='center'>$status</td>
- </tr>";
- $no++;
- }
- echo "</table>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement