Tahun baru, skill baru! 🚀. Masukkan kupon "skill2025" untuk diskon 30% di kelas apa saja

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);
}
?>

avatar Obbytokun
@Obbytokun

186 Kontribusi 16 Poin

Diperbarui 6 tahun yang lalu

1 Jawaban:

coba dengan code ini,

<pre> &lt;?php if(isset($_REQUEST['grup2']) && $_REQUEST['grup2']&lt;&gt;""): $grup=$_REQUEST['grup2']; elseif(isset($_REQUEST['grup']) && $_REQUEST['grup']&lt;&gt;""): $grup=$_REQUEST['grup']; andif; (!empty($grup))?$sql="SELECT * data where (CL_CO&lt;&gt;'Y' OR CL_DN&lt;&gt;'Y') and (aa_name='$grup')":$sql="SELECT * data where (CL_CO&lt;&gt;'Y' OR CL_DN&lt;&gt;'Y')"; $result = mssql_query($sql); ?&gt; </pre>

Nuwun

avatar hipdotcom
@hipdotcom

4 Kontribusi 3 Poin

Dipost 6 tahun yang lalu

Login untuk ikut Jawaban