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="POST">


    <?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 value="<?php echo $row['area']?>"><?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 value="<?php echo $row['portofolio']?>"><?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 value="<?php echo $row['branchdominan']?>"><?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 value="<?php echo $row['dealername']?>"><?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 value="<?php echo $row['bulan']?>"><?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 value="<?php echo $row['tahun']?>"><?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


$where = "where 1=1 and ";
if (strpos($_POST['area'], '--') === false) { $where .= " area = '".$_POST['area']."' and "; }
if (strpos($_POST['portofolio'], '--') === false) { $where .= " portofolio = '".$_POST['portofolio']."' and "; }
if (strpos($_POST['branchdominan'], '--') === false) { $where .= " branchdominan = '".$_POST['branchdominan']."' and "; }
if (strpos($_POST['dealername'], '--') === false) { $where .= " dealername = '".$_POST['dealername']."' and "; }
if (strpos($_POST['bulan'], '--') === false) { $where .= " bulan = '".$_POST['bulan']."' and "; }
if (strpos($_POST['tahun'], '--') === false) { $where .= " tahun = '".$_POST['tahun']."' and "; }

$where = substr($where,0,-4);

        //menampilkan tabel inventory dari database mysql
$result = mysql_query ('SELECT * from marketshare '.$where);
        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>