Welcome Guest, Not a member yet? Register   Sign In
Building query with active records ( a bit complex )
#1

[eluser]behnampmdg3[/eluser]
Hi
I send data to model like this:
Code:
$this->load->model('model_products');
$data = array('selected_data'=>$selected_data, 'url'=>base_url(''), 'classes'=>$classes, 'statuses'=>$status,'categories'=>$categories,'selected_data'=>$selected_data,'header'=>'Search For Products','price_type'=>$this->price_type);
   $this->load->view('product_search_form', $data);
And in model I simply:
Code:
public function results_products($data, $record_start=0,$number_of_records=20)
  {
   $query = $this->db->select('products_table.id, code, class, category, status, price, production_date, products_status.title AS STATUS')->from('products_table')->join('products_status', 'products_status.id = products_table.status')->get_where('', $data, $number_of_records, $record_start, 0);
   return $query->result_array();
  }
How can I change the model and controller so I can also get price between X and Y if I want to?
Thanks
#2

[eluser]behnampmdg3[/eluser]
Seriously no one can answer this?




Theme © iAndrew 2016 - Forum software by © MyBB