示例#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>
示例#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>";


		
echo "</table>";
?>
 <table class=table cellpadding=2 cellspacing=1 bordercolor=#111111 width=100%>
	<tr class=\"bodystyle\" bgcolor='#757575' align=center height="3"><td align="center" width="3"><b>No</b></td><td align="center" width="5"><b>Tanggal Peraturan</b></td><td align="center" width="10"><b>Jenis Peraturan</b></td><td align="center" width="10"><b>Nomor Peraturan</b></td><td align="center" width="53%"><b>Tentang</b></td><td align="center" width="3">-</td><td align="center" width="10%"><b>Action</b></td></tr>
	<?php 
$no = $row_perpage * ($page - 1) + 1;
while ($row = mysql_fetch_array($rs)) {
    $tgl = date("d-M-Y", strtotime($row['tanggal']));
    $tgl_terima = date("d-M-Y", strtotime($row['tanggal_diterima']));
    $tgl_selesai = date("d-M-Y", strtotime($row['tanggal_distribusi']));
    if ($no % 2 == 0) {
        $bg = "#C8C8C8";
    } else {
        $bg = "#CCCCCC";
    }
    echo "<tr bgcolor={$bg}><td align=\"center\">{$no}</td><td align=\"center\">{$tgl}</td><td >" . getJenis($row[2]) . "</td><td align=\"center\">{$row['3']}</td><td>{$row['4']}</td>";
    ?>
		
		<td align="center"><a target='_blank' href="download.php?id=<?php 
    echo getFileId($row[0]);
    ?>
"><img border=0 src="images/doc.gif"
</a></td>
<td align="center"><a href="index.php?_mod=peraturan&task=edit_peraturan&id=<?php 
    echo $row[0];
    ?>
">Edit |</a><a href="index.php?_mod=peraturan&task=delete_peraturan&id=<?php 
    echo $row[0];
    ?>
" onclick="return confirm('Are you sure you want to delete Peraturan No <?php 
    echo $row['no_peraturan'];
示例#4
0
//$header = array('No','Tanggal Peraturan','Jenis Peraturan','No. Peraturan','Tentang','Unit Pemroses','Tgl Diterima Untuk Digandakan','Tanggal Selesai Didistribusikan');
//table_header('#757575',$header,'');
$go = $row_perpage * ($page - 1) + 1;
while ($row = mysql_fetch_array($rs)) {
    $tgl = date("d-M-Y", strtotime($row['tanggal']));
    $tgl_terima = date("d-M-Y", strtotime($row['tanggal_diterima']));
    $tgl_selesai = date("d-M-Y", strtotime($row['tanggal_distribusi']));
    if ($go % 2 == 0) {
        $bg = "#C8C8C8";
    } else {
        $bg = "#ffffff";
    }
    echo "<tr bgcolor={$bg}>";
    echo "<td>" . $go . "</td>";
    echo "<td>" . $tgl . "</td>";
    echo "<td>" . getJenis($row[2]) . "</td>";
    echo "<td>" . $row[3] . "</td>";
    echo "<td>" . $row[4] . "</td>";
    echo "<td>" . $row[5] . "</td>";
    echo "<td>" . $tgl_terima . "</td>";
    echo "<td>" . $tgl_selesai . "</td>";
    echo "</tr>";
    $go++;
}
table_close();
echo "</td></tr>";
echo "<tr>";
echo "<td colspan=4 align=right>";
echo "<table border=0 width=100%>";
echo "<tr>";
echo "<td align=right>";