[eluser]Ngulo[/eluser]
hi guys i have:
view
Code:
<select name="public">
<option value="">-</option>
<option value="1">1</option>
<option value="0">0</option>
</select>
<?php echo $this->session->userdata('admin_events_filter_public');?>
<?php $this->output->enable_profiler(TRUE);?>
controller
Code:
$sessionFilter=array(
'admin_events_filtering'=>'1',
'admin_events_filter_day_from' => $this->input->post('day_from',true),
'admin_events_filter_month_from' => $this->input->post('month_from',true),
'admin_events_filter_year_from'=>$this->input->post('year_from',true),
'admin_events_filter_day_to'=>$this->input->post('day_to',true),
'admin_events_filter_month_to'=>$this->input->post('month_to',true),
'admin_events_filter_year_to'=>$this->input->post('year_to',true),
'admin_events_filter_public'=>"".$this->input->post('public'),
'admin_events_filter_date_from'=>$date_from,
'admin_events_filter_date_to'=>$date_to,
'admin_events_filter_text' => $text,
'admin_events_filter_title'=>$title,
'admin_events_filter_order'=>$order
);
$this->session->set_userdata($sessionFilter);
$this->load->model('admin_events');
$populateevents = $this->admin_events->populate(
$this->session->userdata('admin_events_filter_date_from'),
$this->session->userdata('admin_events_filter_date_to'),
$this->session->userdata('admin_events_filter_text'),
$this->session->userdata('admin_events_filter_title'),
$this->session->userdata('admin_events_filter_order'),
$this->session->userdata('admin_events_filter_public')
);
model
Code:
function populate($date_from,$date_to,$text,$title,$order,$public){
$this->db->select('
ci_events.id,
ci_events.public,
ci_events.event_date,
ci_events_details.title,
ci_events.insert_datetime,
ci_events.update_datetime'
);
$this->db->from('ci_events');
$this->db->join('ci_events_details','ci_events.id = ci_events_details.id_event');
$this->db->where('ci_events_details.lang','it');
if($title){
$this->db->like('ci_events_details.title',$title);
}
if($text){
$this->db->like('ci_events_details.text',$text);
}
if($date_from){
$this->db->where('ci_events.event_date >=',$date_from);
}
if($date_to){
$this->db->where('ci_events.event_date <=',$date_to);
}
if($public){
$this->db->where('ci_events.public',$public);
}
if($order)
{
$this->db->order_by('ci_events.event_date '.$order);
}
else{
$this->db->order_by('ci_events.event_date DESC');
}
$query = $this->db->get();
return $query->result();
ok enabled profiler and i see query in plain text
when i pass $this->input->post('public'); to session then to model for query results:
if public = 1 query it's ok
if public = '' query it's ok
if public = 0 query NOT ok cause seems in session and post array it exists as 0 but in query it doesn't comes up in WHERE condition
does anyone have ideas?
thanks