+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: problem with 0 int from post request (/showthread.php?tid=41127)
problem with 0 int from post request - El Forum - 04-28-2011
[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
problem with 0 int from post request - El Forum - 04-28-2011
[eluser]InsiteFX[/eluser]
Because 0 is FALSE which will not print out anything!
The way around it is to use an enum field or BOOL!
InsiteFX
problem with 0 int from post request - El Forum - 04-29-2011
[eluser]Ngulo[/eluser]
but my public db field is ENUM('1','0')
if i print out $this->input->post('public'); it shows me 0
if i print out session data then it shows me anyway 0
really can't understand
problem with 0 int from post request - El Forum - 04-29-2011
[eluser]InsiteFX[/eluser]
As I said above when it comes back it thinks it is FALSE!
Code:
echo '0'; // works displays 0
echo FALSE; // displays nothing!Do a search on checkbox and you will see what I am talking about!
InsiteFX
problem with 0 int from post request - El Forum - 04-29-2011
[eluser]TWP Marketing[/eluser]
Ngulo,
I think the input function post() is returning an integer value, not a boolean or enum value.
test it with some code in your view:
Code:
$test = $this->input->post(‘public’);
if($test === '0'){ echo "string zero";}
if($test === 0){ echo "integer zero";}
if($test === ''){ echo "empty string";}