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

Question

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?

Answer 1

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";