Algoritma/Cara Filter pakai Option Select di PHP

coba tombol ini kasih name juga <pre> &lt;button class="btn btn-primary" type="submit" value="filter"&gt;Show&lt;/button&gt; </pre> ubah jadi <pre> &lt;button class="btn btn-primary" type="submit" name="submit" value="filter"&gt;Show&lt;/button&gt; </pre>

Thanks banget mas , sudah berhasil .

ini ss nya <img src='https://i.imgur.com/eGryVR7.png'>

tapi saya mau tanya lagi , kalo mau kasih notifikasi salah satu formnya belum di isi gimana ya ? misal tidak input tanggal atau tanggalnya salah kelebihan terus nanti pas di submit muncul pemberitahuan . dan menghide warning atau notice .

berikut ss nya .

<img src='https://i.imgur.com/QQpcHIz.png'>

berikut kodenya finalnya .

<pre>

&lt;!doctype html&gt; &lt;html lang="en"&gt; &lt;head&gt; &lt;title&gt;Giromix Data Information&lt;/title&gt; &lt;!-- Required meta tags --&gt; &lt;meta charset="utf-8"&gt; &lt;meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"&gt;

<!-- Bootstrap CSS -->
<link rel="stylesheet" href="bootstrap4.1.3/css/bootstrap.min.css"  crossorigin="anonymous">

&lt;/head&gt;

&lt;body&gt; &lt;div class="container" &gt;

&lt;form action="showgiromix2.php" method="POST"&gt;

<!-- custom file input date picker  -->
<div class="input-group mb-3">
  <div class="input-group-prepend">

    <label class="input-group-text" for="inputGroupSelect01" style="width: 150px">Start Date</label>
    <input type="Date" name="tgl_dari">
    <label class="input-group-text" for="inputGroupSelect01" style="width: 150px">End Date</label>
    <input type="Date" name="tgl_sampai">
    <button class="btn btn-primary"  type="submit" name="submit" value="filter">Show</button>
  </div>
</div>

&lt;br&gt; &lt;br&gt;

&lt;!-- custom file input List Machines --&gt;

<div class="input-group mb-3">
  <div class="input-group-prepend">
    <label class="input-group-text" for="inputGroupSelect01" style="width: 150px;">List Machines</label>
  </div>
  <select class="custom-select" id="inputGroupSelect01" name="select">
    <option selected>Choose...</option>
    <option value="TRI1">Extruder</option>
    <option value="LIN1">Inner Complex</option>
    <option value="TEX1">Textile Calendar</option>
  </select>
</div>

&lt;/form&gt;

&lt;br&gt; &lt;br&gt; &lt;table class="table" &gt; &lt;thead class="thead-dark"&gt; &lt;tr&gt; &lt;th scope="col"&gt;No&lt;/th&gt; &lt;th scope="col"&gt;Plant&lt;/th&gt; &lt;th scope="col"&gt;Machines Code&lt;/th&gt; &lt;th scope="col"&gt;Calculation Date&lt;/th&gt; &lt;th scope="col"&gt;PP Code&lt;/th&gt; &lt;th scope="col"&gt;SFC Code Code&lt;/th&gt; &lt;th scope="col"&gt;ST Code&lt;/th&gt; &lt;th scope="col"&gt;Value 1&lt;/th&gt; &lt;th scope="col"&gt;Value 2&lt;/th&gt; &lt;th scope="col"&gt;Change Count&lt;/th&gt; &lt;th scope="col"&gt;Distinct Count&lt;/th&gt; &lt;th scope="col"&gt;Factory&lt;/th&gt;

</tr>
</thead>

&lt;?php include 'connection.php'; ?&gt;

&lt;?php if(isset($_POST['tgl_dari']) && isset($_POST['tgl_sampai'])){

    $dari = $_POST['tgl_dari'];
    $sampai = $_POST['tgl_sampai'];

?&gt;

&lt;?php //ambil submit if (isset($_POST['submit'])) { if ($_POST['select'] == 'TRI1') { $sql = "select * from [PCSRepository].[dbo].dc_giromix where PLANT ='ID' and MCH_CODE ='TRI1' and CALC_DATE &gt;= '$dari' and CALC_DATE &lt;= '$sampai' order by CALC_DATE desc"; }

elseif ($_POST['select'] == 'LIN1') {
    $sql = "select * from [PCSRepository].[dbo].dc_giromix where PLANT ='ID' and MCH_CODE ='LIN1' and CALC_DATE >= '$dari' and CALC_DATE <= '$sampai' order by CALC_DATE desc" ;
}

elseif ($_POST['select'] == 'TEX1') {
    $sql = "select * from [PCSRepository].[dbo].dc_giromix where PLANT ='ID' and MCH_CODE ='TEX1' and CALC_DATE >= '$dari' and CALC_DATE <= '$sampai' order by CALC_DATE desc" ;
}

else {

    echo "Please Select the machines List ";
}

} ?&gt;

<?php 


// mengambil data dari database
 $data = odbc_exec($koneksi,$sql);
                $no = 1;

// mengubah data ke array dan menampilkannya dengan perulangan while while($d=odbc_fetch_array($data)){

?&gt; &lt;tbody&gt; &lt;tr&gt; &lt;th scope="row"&gt;&lt;?php echo $no++; ?&gt;&lt;/th&gt; &lt;td&gt;&lt;?php echo $d['PLANT']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['MCH_CODE']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['CALC_DATE']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['PP_CODE']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['SFC_CODE']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['ST_CODE']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo ((float)$d['VAL1']); ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo ((float)$d['VAL2']); ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo ((float)$d['CHANGE_COUNT']); ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['DISTINCT_COUNT']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $d['FACTORY']; ?&gt;&lt;/td&gt;

    <!-- //var_dump($d['VAL1']); -->

  </tr>

&lt;/tbody&gt; &lt;?php }} ?&gt; &lt;/table&gt; &lt;br&gt; &lt;a href='export.php'&gt; Cetak &lt;/a&gt; &lt;/div&gt; &lt;/body&gt; &lt;/html&gt;

</pre>

Thank mas ,, Closed ..