Untitled

<html>
<title>RANGKING</title>
<style type="text/css">
<!--
.style2 {font-size: 24px}
-->
</style>
<head>
	<link rel="stylesheet" type="text/css" href="assets/css/jquery.dataTables.css">
<link rel="stylesheet" href="css/style.css" type="text/css" />
<link rel="stylesheet" href="css/menu.css" type="text/css" media="screen">
	<script type="text/javascript" src="assets/js/jquery.min.js"></script>
	<script type="text/javascript" src="assets/js/jquery.dataTables.min.js"></script>
</head>
<script>
    $(document).ready(function() {
	   $('#example').DataTable();
	} );
</script>
<body>
<div id="content" align="center">
<div class="body">
<div id="content" align="center">
<div class="header">
<img src="images/headernew.jpg"></div>

<div class="menu">
<ul id="nav">
        <li><a title="Home"href="home.php"><b><font >Home</font></b></a></li>
        <li><a title="Imput Data"href="input.php"><b></font>Input Data</b></a></li>
        <li><a title="view"href="view.php"><b></font>Lihat Data</b></a></li>
        <li><a title="Normalisasi"href="normalisasi.php"><b></font>Normalisasi</b></a></li>
		<li><a title="Rangking" href="rangking.php"><b><font >Rangking</font></b></a></li>
		<li><a title="Logout" href="index.php">Logout</a></li>
				</div> <!--end: menu-->

		</div>
<div class="tengah">
<br>
<h1> PERANGKINGAN </h1>

<?php
	//Gunakan Koneksi
	include("koneksi.php");


	//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>";

?>
</body>
</html>