dongzhong2018 2018-04-18 09:30
浏览 73
已采纳

选择带有范围的下拉列表,然后在数据库中搜索

I'm new in this field so please don't be harsh on me. It's looks simple yet I can't figured it out. So, I have dropdown select, like:

<select name="mode" id="mode">
    <option value="None">All</option>
    <option value="300-400">Inside</option>
    <option value="200-299">Outside</option>
</select>

Then I currently have this

$cMode=($mode == "None") ? '"%"' : $mode;

SELECT * FROM sections WHERE code LIKE '.$cMode.'

How can I change the query so if I select Inside to search between values 300 and 400?

  • 写回答

3条回答 默认 最新

  • dqcuq4138 2018-04-18 09:35
    关注

    You can use if-else with explode() and list()

    if($mode == "None"){
        $cMode = '"%"';
        SELECT * FROM sections WHERE code LIKE '.$cMode.'
    }else{
        list($start,$eand) = explode('-',$mode);
        SELECT * FROM sections WHERE code BETWEEN $start AND $end
    }
    

    As you asked in the comment:-

      $cMode ='';
       if($mode == "None"){
         $cMode = 'LIKE "%"';
       }else{
         list($start,$eand) = explode('-',$mode);
         $cMode ="BETWEEN $start AND $end";
       }
    
    $query = "SELECT * FROM sections WHERE code $cMode";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?