Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
2 select option dan 1 button search
selamat siang,ane punya kode pencarian berdasarkan select option tapi hanya bisa berjalan satu pencarian saja, kalo biar bisa 2 pencarian gimana yah cara penulisan nya?
<button type="submit" class="btn btn-success btn-sm left-search" >Search</button>
<div class= "btn-group left-option" >
<div class = "input-group table-options" >
<select class="custom-select from-control" style="max-width:55px; max-height:31px; font-size:13px" name="grup">
<option>Sales</option>
<?php
include 'conection.php';
$query1 = ("select ae_id,ae_name from appl_empl where ae_issm=1 and ae_isuse=1");
$result1 = mssql_query($query1);
$grup=['ae_name'];
while ($row1 = mssql_fetch_array ($result1)) {
?>
<option ><?php echo $row1 ['ae_name'] ; } ?></option>
</select>
<select class="custom-select from-control" name="grup2" style="max-width:55px; max-height:31px; font-size:13px">
<option>Area</option>
<?php
include 'conection.php';
$query2 = ("select aa_id,aa_name from appl_area ");
$result2 = mssql_query($query2);
$grup2=['aa_name'];
while ($row2 = mssql_fetch_array ($result2)) {
?>
<option ><?php echo $row2 ['aa_name'] ; } ?></option>
</select>
</div>
</div>
eksekusi pencarian
<?php
include '../koneksi.php';
if (isset($_REQUEST['grup2']) && $_REQUEST['grup2']<>""){
$grup=$_REQUEST['grup2'];
$sql2 = ("SELECT * data where (CL_CO<>'Y' OR CL_DN<>'Y') and (aa_name='$grup') ");
$result = mssql_query($sql2);
}elseif(isset($_REQUEST['grup']) && $_REQUEST['grup']<>""){
$grup=$_REQUEST['grup'];
$sql2 = ("SELECT * data where (CL_CO<>'Y' OR CL_DN<>'Y') and (aa_name='$grup') ");
$result = mssql_query($sql2);
}else{
// jika tidak ada pencarian pakai ini
$sql = "SELECT * data where (CL_CO<>'Y' OR CL_DN<>'Y') ";
$result = mssql_query($sql);
}
?>
1 Jawaban:
coba dengan code ini,
<pre> <?php if(isset($_REQUEST['grup2']) && $_REQUEST['grup2']<>""): $grup=$_REQUEST['grup2']; elseif(isset($_REQUEST['grup']) && $_REQUEST['grup']<>""): $grup=$_REQUEST['grup']; andif; (!empty($grup))?$sql="SELECT * data where (CL_CO<>'Y' OR CL_DN<>'Y') and (aa_name='$grup')":$sql="SELECT * data where (CL_CO<>'Y' OR CL_DN<>'Y')"; $result = mssql_query($sql); ?> </pre>
Nuwun