Esempio n. 1
0
echo "</table>";
//Lakukan Normalisasi dengan rumus pada langkah 2
//Cari Max atau min dari tiap kolom Matrik
$crMax = mysql_query("SELECT max(id_bencana) as maxK1, \n\t\t\t\t\t\tmax(kerusakan) as maxK2,\n\t\t\t\t\t\tmax(id_bencana) as maxK3,\n\t\t\t\t\t\tmax(pengungsi) as maxK4 \n\t\t\tFROM tbl_informasi");
$max = mysql_fetch_array($crMax);
//Hitung Normalisasi tiap Elemen
$sql2 = mysql_query("SELECT * FROM tbl_informasi");
//Buat tabel untuk menampilkan hasil
echo "\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t\n\t\t";
$no = 1;
while ($dt2 = mysql_fetch_array($sql2)) {
    "<tr>\n\t\t\t<td>{$no}</td><td>" . getId_prov($dt2['id_prov']) . "</td><td>" . getId_bencana($dt2['id_bencana']) . "</td><td>" . getNama($dt2['id_info']) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK1'], 2) . "</td><td>" . round($dt2['kerusakan'] / $max['maxK2'], 2) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK3'], 2) . "</td><td>" . round($dt2['pengungsi'] / $max['maxK4'], 2) . "</td>\n\t\t</tr>";
    $no++;
}
echo "</table>";
//Proses perangkingan dengan rumus langkah 3
$sql3 = mysql_query("SELECT * FROM tbl_informasi");
//Buat tabel untuk menampilkan hasil
echo " <center><H3>Sistem Pendukung Keputusan Metode SAW</H3>\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t<tr>\n\t\t\t<td>No</td><td>id provinsi</td><td>id bencana</td><td>id info</td><td>jenis</td><td>Rangking</td>\n\t\t</tr> </center>\n\t\t";
$no = 1;
//Kita gunakan rumus (Normalisasi x bobot)
while ($dt3 = mysql_fetch_array($sql3)) {
    echo "<tr>\n\t\t\t<td>{$no}</td><td>" . getId_prov($dt3['id_prov']) . "</td><td>" . getId_bencana($dt3['id_bencana']) . "</td><td>" . getNama($dt3['id_info']) . "</td><td>" . getJenis($dt3['jenis']) . "</td>\n\t\t\t<td>" . round($dt3['id_bencana'] / $max['maxK1'] * $bobot[0] + $dt3['kerusakan'] / $max['maxK2'] * $bobot[1] + $dt3['id_bencana'] / $max['maxK3'] * $bobot[2] + $dt3['pengungsi'] / $max['maxK4'] * $bobot[3], 2) . "</td>\n\t\t\t\n\t\t</tr>";
    $no++;
}
echo "</table>";
echo " pilih urutan 3 paling bawah atau 3 ranking paling tinggi";
?>
</footer>
</br></html>
Esempio n. 2
0
//Cari Max atau min dari tiap kolom Matrik
$crMax = mysql_query("SELECT max(id_bencana) as maxK1, \n\t\t\t\t\t\tmax(kerusakan) as maxK2,\n\t\t\t\t\t\tmax(id_bencana) as maxK3,\n\t\t\t\t\t\tmax(pengungsi) as maxK4 \n\t\t\tFROM tbl_informasi");
$max = mysql_fetch_array($crMax);
//Hitung Normalisasi tiap Elemen
$sql2 = mysql_query("SELECT * FROM tbl_informasi");
//Buat tabel untuk menampilkan hasil
echo "\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t";
$no = 1;
while ($dt2 = mysql_fetch_array($sql2)) {
    "<tr>\n\t\t\t<td>{$no}</td><td>" . getId_prov($dt2['id_prov']) . "</td><td>" . getId_bencana($dt2['id_bencana']) . "</td><td>" . getNama($dt2['id_info']) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK1'], 2) . "</td><td>" . round($dt2['kerusakan'] / $max['maxK2'], 2) . "</td><td>" . round($dt2['id_bencana'] / $max['maxK3'], 2) . "</td><td>" . round($dt2['pengungsi'] / $max['maxK4'], 2) . "</td>\n\t\t</tr>";
    $no++;
}
echo "</table>";
//Proses perangkingan dengan rumus langkah 3
$sql3 = mysql_query("SELECT * FROM tbl_informasi");
//Buat tabel untuk menampilkan hasil
echo " <center><H3>Sistem Pendukung Keputusan Metode SAW</H3>\n\t<table width=500 style='border:1px; #ddd; solid; border-collapse:collapse' border=1>\n\t\t<tr>\n\t\t\t<td>No</td><td>id provinsi</td><td>id bencana</td><td>id info</td><td>jenis</td><td>Rangking</td>\n\t\t</tr> </center>\n\t\t";
$no = 1;
//Kita gunakan rumus (Normalisasi x bobot)
while ($dt3 = mysql_fetch_array($sql3)) {
    echo "<tr>\n\t\t\t<td>{$no}</td><td><a href='http://localhost/google-gis-ri32/dashboard.php?page=peta26/" . getId_prov($dt3['id_prov']) . "'>" . getId_prov($dt3['id_prov']) . "</a></td><td>" . getId_bencana($dt3['id_bencana']) . "</td><td>" . getNama($dt3['id_info']) . "</td><td>" . getJenis($dt3['jenis']) . "</td>\n\t\t\t<td>" . round($dt3['id_bencana'] / $max['maxK1'] * $bobot[0] + $dt3['kerusakan'] / $max['maxK2'] * $bobot[1] + $dt3['id_bencana'] / $max['maxK3'] * $bobot[2] + $dt3['pengungsi'] / $max['maxK4'] * $bobot[3], 2) . "</td>\t\t\n\t\t</tr>";
    $no++;
}
echo "</table>";
echo " pilih urutan 3 paling bawah atau 3 ranking paling tinggi";
?>
echo "<td><a href='http://localhost/contoh/".$row['nama']."'>".$row['nama']."</a></td>";
echo "<td><a href='alamat linknya'>".$row['nama']."</a></td>";