dongmaopiao0901 2019-05-07 09:56
浏览 26

如何使用按钮在多个条件下搜索数据(如果)?

i have a problem, i cant use one button to search in many condition. i mean i have 3 searching boxs, and i fill its with things that i want to search. when i hit the button search it doesnt work.

this is the form to fill something that you wanna search.

        <form class="form-inline" method="post" enctype="multipart/form-data"> 
        <input class="form-control " type="text" name="pnm" placeholder="Search P/N" onkeyup="this.value = this.value.toUpperCase()" style="width: 250px;text-align: center; margin:10px; text-transform:uppercase; " > 
        </input>
        <button style="background-color:#668cff" class="btn btn-rounded btn-primary " type="submit" data-toggle="popover" data-trigger="hover" data-placement="bottom"  data-content="Search"><i class="fa fa-search"></i></button>            

        <form class="form-inline" method="post" enctype="multipart/form-data"> 
        <input class="form-control " type="text" name="req" placeholder="Search RQ" onkeyup="this.value = this.value.toUpperCase()" style="width: 250px;text-align: center; margin:10px; text-transform:uppercase; " > 
        </input>
        <button  style="background-color:#ffff66" class="btn btn-rounded btn-primary " type="submit" data-toggle="popover" data-trigger="hover" data-placement="bottom"  data-content="Search"><i class="fa fa-search"></i></button>   

        <div class="col-sm-5 form-inline">
            <p align="left"><label class="col-sm-7 control-label">Status</label></p>

            <p align="left"><select name="status" class="custom-select"></p>
            <option value=""><none></option>
            <option value="OPEN">Open</option>
            <option value="CLOSED">Closed</option>


            </select>

this is if else condition

     $ornum=''; $orline='';
     $stat='';
     $pnm = $_POST['pnm'];
     $stat = $_POST['status'];
     $filt='';

     if (isset($_REQUEST['req']) && $_REQUEST['req']!=''){$filt = ' and c.requisition =\''. $_POST['req'].'\'';}
     else {$req = '';}

     if (isset($tgl_awal1) && isset($tgl_akhir1)) {$filt = " and D.CREATED_DATE BETWEEN TO_DATE('$tgl_awal1', 'yyyy-mm-dd') AND TO_DATE('$tgl_akhir1', 'yyyy-mm-dd')";}
     else {$req = '';}

     if (isset($_REQUEST['submit_btn']))  { $stat = $_POST['status'];} 
    // if (isset($_REQUEST['submit_btn']))  { $stat = $_POST['status'];}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线
    • ¥15 seatunnel 怎么配置Elasticsearch
    • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
    • ¥15 (标签-MATLAB|关键词-多址)
    • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
    • ¥500 52810做蓝牙接受端
    • ¥15 基于PLC的三轴机械手程序
    • ¥15 多址通信方式的抗噪声性能和系统容量对比