Untitled

<?php
//koneksi ke database
	include('koneksi_db.php');
        //$host = "localhost";
		//$username = "root";
		//$password = "";
		//$nama_db = "1084_db";

		$koneksi_db = mysqli_connect($host,$username,$password,$nama_db) or die (mysqli_error());
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>JQuery Print Area</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <link href="bootstrap.min.css" rel="stylesheet" media="screen">

    <!-- css yang digunakan ketika dalam mode screen -->
    <link href="style.css" rel="stylesheet" media="screen">

    <!-- ss yang digunakan tampilkan ketika dalam mode print -->
    <link href="print.css" rel="stylesheet" media="print">

    <script src="jquery-1.10.2.min.js"></script>
    <script src="printarea/PrintArea-master/js/jquery.printarea.js"></script>
    <script>
        (function($) {
            // fungsi dijalankan setelah seluruh dokumen ditampilkan
            $(document).ready(function(e) {

                // aksi ketika tombol cetak ditekan
                $("#cetak").bind("click", function(event) {
                    // cetak data pada area <div id="#data-mahasiswa"></div>
                    $('#data-mahasiswa').printArea();
                });
            });
        }) (jQuery);
    </script>
 <title>Lihat Data</title>
	<!-- CSS untuk mempercantik tampilan-->
 		<style type="text/css">
		td
		{
 			text-align: center;
		}
		</style>

</head>
<?php
//membentuk klausa where pencarian
	//$where = '';
	if(isset($_GET['q'])&&isset($_GET['g'])&&isset($_GET['d'])&&isset($_GET['r'])&&isset($_GET['p']))
	{
				$cari=$_GET['q'];
				$gender=$_GET['g'];
				$district=$_GET['d'];
				$region=$_GET['r'];
				$province=$_GET['p'];

		$sql="SELECT student.student_number,student.student_name,student.student_gender,
			  district.district_name,region.region_name,province.province_name from
	          student inner join district on student.district_id=district.district_id
	          inner join region on district.region_id=region.region_id
	          inner join province on region.province_id=province.province_id where (student.student_name like '%$cari%' or   				student.student_number like '%$cari%') AND (student.student_gender like '%$gender%') AND (student.district_id ='$district' OR ''='$district') AND (district.region_id ='$region' OR ''='$region') AND (region.province_id ='$province' OR ''='$province')";
	$hasil = mysqli_query($koneksi_db,$sql);
	}

//mencari banyak data yang ada dalam tabel
	$sqlCount = "SELECT count(student.student_number),student.student_name,student.student_gender,
			  district.district_name,region.region_name,province.province_name FROM
	          student INNER JOIN district ON student.district_id=district.district_id
	          INNER JOIN region ON district.region_id_fk=region.region_id
	          INNER JOIN province ON region.province_id_fk=province.province_id";
	$rsCount = mysqli_fetch_array(mysqli_query($koneksi_db,$sqlCount));
	$banyakData = $rsCount[0];
	$page = isset($_GET['page']) ? $_GET['page'] : 1;
	$limit = 5;
	$mulai_dari = $limit * ($page - 1);
	$sql_limit = "SELECT student.student_number,student.student_name,student.student_gender,
			  	  district.district_name,region.region_name,province.province_name FROM
	          	  student INNER JOIN district ON student.district_id=district.district_id
	          	  INNER JOIN region ON district.region_id_fk=region.region_id
	          	  INNER JOIN province ON region.province_id_fk=province.province_id order by student_name limit $mulai_dari, $limit";
	$hasil = mysqli_query($koneksi_db,$sql_limit);
//form pencarian dibawah
?>


<body>
<div class="navbar navbar-static-top">
    <div class="navbar-inner">
        <div class="container">
            <a class="brand" href="http://jengkolberdarahbiru.esy.es">JengkolBerdarah</a>
        </div>
    </div>
</div>

<div class="container">
    <div class="row">
<fieldset>
	<legend><h1>Cari Data Mahasiswa</h1></legend>
 		<div style="margin-bottom:15px;" align="right">

  		<form name="search" method="get" action="pencarian.php">
 		Search: <input type="text" name="q"/>
        <br />
        <br />
        Gender : <select name="g" id="g">
   				 <option value="">--SEMUA--</option>
            	 <option value="F">Female</option>
            	 <option value="M">Male</option>
            	 </select>

         District : <select name="d" id="d">
   			<option value="">--SEMUA--</option>
   			<?php
			$sql = "select * from district";
			$query = mysqli_query($koneksi_db,$sql);
			while($data = mysqli_fetch_array($query))
				{
					echo "<option value=".$data['district_id'].">".$data['district_name']."</option>";
				}
			?>
            </select>
   Region : <select name="region" id="region">
   			<option value="">--SEMUA--</option>
   			<?php
			$sql = "select * from region";
			$query = mysqli_query($koneksi_db,$sql);
			while($data= mysqli_fetch_array($query))
				{
					echo "<option value=".$data['region_id'].">".$data['region_name']."</option>";
				}
			?>
            </select>
   Province : <select name="p" id="p">
   			<option value="">--SEMUA--</option>
   			<?php
			$sql = "select * from province";
			$query = mysqli_query($koneksi_db,$sql);
			while($data = mysqli_fetch_array($query))
				{
					echo "<option value=".$data['province_id'].">".$data['province_name']."</option>";
				}
			?>
            </select>

 		<input type="submit" value="GO"/>
		</form>
 		</div>

 			<table width="100%" border="1px solid #000" style="border-collapse:collapse;" class="table table-condensed table-bordered table-hover" cellpadding="0" cellspacing="0">
  				<tr style="background-color:#fc0;">
                	<th>No</th>
   					<th>Nim Mahasiswa</th>
   					<th>Nama Mahasiswa</th>
                    <th>Gender</th>
 			 	</tr>
<?php
	//menampilkan data
 	$no=1;
	while ($dataSiswa = mysqli_fetch_array($hasil)) {
 	echo '<tr>';
 	echo '<td>' . $no . '</td>';
 	echo '<td>' . $dataSiswa['student_number'] . '</td>';
 	echo '<td>' . $dataSiswa['student_name'] . '</td>';
 	echo '<td>' . $dataSiswa['student_gender'] . '</td>';
 	echo '</tr>';
 	$no++;
}

//membuat pagination
$banyakHalaman = ceil($banyakData / $limit);
echo 'Halaman: ';
for ($i = 1; $i <= $banyakHalaman; $i++) {
 if ($page != $i) {
echo '[<a href="pencarian.php?page=' . $i .($page ? '&q='.$_GET['q'] : ''). '">' . $i . '</a>] ';
 } else {
 echo "[$i] ";
 }
}
?>
 			</table>
            <?php echo '<a href="cetak.php"><button id="cetak" class="btn pull-right">Cetak</button></a> '; ?>
</fieldset>
</body>
</html>