Codeigniter get where clause from input select

Question

I need to get database information from table by using where clause from a select options.

My view:

<div>
    <select name="noSeats" class="form-control" placeholder="Seats">
        <option value="">Seats</option>
        <option value="45">45</option>
        <option value="49">49</option>
        <option value="51">51</option>
        <option value="53">53</option>
        <option value="56">56</option>
        <option value="57">57</option>
        <option value="61">61</option>
    </select>
</div>

My Model:

public function getSeats($noSeats) {
    $query = $this->db->get('seat');
    if ($query->num_rows() > 0) {
        return $query->result();
    }    
}

Also I have another problem with listing checkboxes; I need to list checkboxes in row of limit to 4 since I have many chechboxes.

Nagesh · Accepted Answer · 2018-08-02 09:47:55Z

1

public function getSeats($noSeats){
      $query = $this->db->from('seat')->where('seat_col', $noSeats)->get();
      if($query->num_rows() > 0){
      return $query->result();
      }  
 }

answered Aug 2, 2018 at 9:47

Nagesh

4373 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Coeng Over a year ago

I need those check boxes to appear after choosing number of seats

Nagesh Over a year ago

This function is returning the result of seats, so you can pass these seats to the view.

manish · Accepted Answer · 2018-08-02 09:47:44Z

1

You can use

$query = $this->db->where('COLUMN_NAME', $noSeats )->get('seat');

answered Aug 2, 2018 at 9:47

manish

4213 silver badges9 bronze badges

Collectives™ on Stack Overflow

Codeigniter get where clause from input select

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related