Untitled

<?php
//buat konekasi dengan MySQL
session_start();
$hostname = "localhost";
$user = "root";
$password = "";
$database = "mshare";
$koneksi = mysql_connect ($hostname, $user, $password);
$pilihdb = mysql_select_db ($database, $koneksi);

//jika koneksi gagal, langusng keluar dari PHP
if(!$koneksi)
{
	die("Koneksi dengan MySQL gagal");
}

//Menggunakan data base yang sudah di buat
$result = mysql_query('USE mshare');
if (!$result)
{
	die ("Database marketshare tidak terkoneksi");
}


?>
<h3>MARKET SHARE</h3>
<!DOCTYPE html>
<head>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<title> Market Share</title>
<body>
		<form action="" method="index.php">


	<?php

	$sql = mysql_query('SELECT area FROM marketshare GROUP BY area');
 ?>
			<div id="container">
			<select name="area">
				<option>-- Area --</option>
				<?php if (mysql_num_rows ($sql) > 0) { ?>
				<?php while ($row = mysql_fetch_array($sql)){ ?>
				<option><?php echo $row['area']?></option>
				<?php } ?>
				<?php } ?>
			</select>
		</div>

	<?php

	$sql = mysql_query('SELECT portofolio FROM marketshare GROUP BY portofolio');
 ?>
			<div id="container">
				<select name="portofolio">
				<option>-- Portofolio --</option>
				<?php if (mysql_num_rows ($sql) > 0) { ?>
				<?php while ($row = mysql_fetch_array($sql)){ ?>
				<option><?php echo $row['portofolio']?></option>
				<?php } ?>
				<?php } ?>
			</select>
		</div>

	<?php

	$sql = mysql_query('SELECT branchdominan FROM marketshare GROUP BY branchdominan');
 ?>
			<div id="container">
				<select name="branchdominan">
				<option>-- Branch Dominan --</option>
				<?php if (mysql_num_rows ($sql) > 0) { ?>
				<?php while ($row = mysql_fetch_array($sql)){ ?>
				<option><?php echo $row['branchdominan']?></option>
				<?php } ?>
				<?php } ?>
			</select>
		</div>

<?php

	$sql = mysql_query('SELECT dealername FROM marketshare GROUP BY dealername');
 ?>
			<div id="container">
				<select name="dealername">
				<option>-- Dealername --</option>
				<?php if (mysql_num_rows ($sql) > 0) { ?>
				<?php while ($row = mysql_fetch_array($sql)){ ?>
				<option><?php echo $row['dealername']?></option>
				<?php } ?>
				<?php } ?>
			</select>
		</div>

<?php

	$sql = mysql_query('SELECT bulan FROM marketshare GROUP BY bulan');
 ?>
			<div id="container">
		    	<select name="bulan">
				<option>-- Bulan --</option>
				<?php if (mysql_num_rows ($sql) > 0) { ?>
				<?php while ($row = mysql_fetch_array($sql)){ ?>
				<option><?php echo $row['bulan']?></option>
				<?php } ?>
				<?php } ?>
			</select>
		</div>

<?php

	$sql = mysql_query('SELECT tahun FROM marketshare GROUP BY tahun');
 ?>
			<div id="container">
				<select name="tahun">
				<option>-- Tahun --</option>
				<?php if (mysql_num_rows ($sql) > 0) { ?>
				<?php while ($row = mysql_fetch_array($sql)){ ?>
				<option><?php echo $row['tahun']?></option>
				<?php } ?>
				<?php } ?>
			</select>


			<input type="submit" value="SEARCH" name="ok_submit"></input>

	</div>
</form>


<table style=" border-collapse:collapse; font-size:13px; text-align:center"  border="1" cellpadding="80px" cellspacing="0"  width="100%">
    <tbody><tr style="background:#aaa; color:#000 font-weight:bold; font-size:13px" width="20px" height="5px">

<div id="container">
		<th>IDms</th>
		<th>Area</th>
		<th>Portofolio</th>
		<th>Branch Dominan</th>
		<th>Dealer Name</th>
		<th>SD</th>
		<th>AF</th>
		<th>Bulan</th>
		<th>Tahun</th>
	</tr>
	</tbody>

	<br></br>


</div>
		<?php


		//menampilkan tabel inventory dari database mysql
$result = mysql_query ('SELECT * from marketshare');
		while ($row = mysql_fetch_array($result))
		{
			echo"<tr>";
			echo"<td>$row[idms]</td>";
			echo"<td>$row[area]</td>";
			echo"<td>$row[portofolio]</td>";
			echo"<td>$row[branchdominan]</td>";
			echo"<td>$row[dealername]</td>";
			echo"<td>$row[sd]</td>";
			echo"<td>$row[af]</td>";
			echo"<td>$row[bulan]</td>";
			echo"<td>$row[tahun]</td>";
			echo"</tr>";
		}

		?>

		</table>
		</body>
		<form method="post" action="">

<input name="ms_download" value="DOWNLOAD" style="width:130px" onclick="location.href='ms_download.php';" type="button">
</form>
		</html>