StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POphp difference between 1 and '1'
primarykey
Id
15501960
data
AcceptedAnswerId
15503330
AnswerCount
3
ClosedDate
CommentCount
9
CommunityOwnedDate
CreationDate
2013-03-19T14:16:49.790
FavoriteCount
0
LastActivityDate
2013-03-20T13:00:50.827
LastEditDate
2013-03-20T12:13:33.287
LastEditorUserId
1203797
OwnerUserId
1203797
ParentId
0
PostTypeId
1
Score
0
ViewCount
185
LastEditorDisplayName
text
Body
I have struggle with this problem for hours. I have this method my model (codeigniter) : <pre><code>public function get_umat($kelas1 = 0, $kelas2 = 0) { $this->db->select('*'); $this->db->from('msumat'); $this->db->join('mskelas', 'msumat.kelas_id = mskelas.kelas_id'); if($kelas1 != 0) { echo $kelas1; var_dump($kelas1); $this->db->where('mskelas.kelas_id', $kelas1); } else if($kelas2 !=0) { echo '2'; $this->db->where('mskelas.kelas_id', $kelas2); } else if($kelas1 != 0 && $kelas2 !=0) { echo '3'; $this->db->where('mskelas.kelas_id BETWEEN $kelas1 AND $kelas2'); } return $this->db->get(); } </code></pre> EDIT : The one that not working is in this line of code (taken from above) : <pre><code>$this->db->where('mskelas.kelas_id', $kelas1); </code></pre> Its not working when i called this method in my controller, like this : <pre><code>$this->backend_m->get_umat($_POST['ddl_kelas1'], $_POST['ddl_kelas1']); </code></pre> I get '1'(String) when i vardump the <code>($_POST['ddl_kelas1']</code> Then i try to change the parameter in the controller, but its still not working : <pre><code> $this->backend_m->get_umat(1, $_POST['ddl_kelas1']); </code></pre> Desperately, i tried to change the parameter directly in the model, and its working : <pre><code>public function get_umat($kelas1 = 1, $kelas2 = 0) </code></pre> Whats going on here?i think it has something to do with the difference of 1 (int) and '1' (String). Thanks :D Edit 2 : After some experiment, i think variable type is not the problem here. Thats because : I tried to do this in my controller : <pre><code> if(isset($_POST['btnSearch'])) { $test = (int)$_POST['ddl_kelas1']; $this->backend_m->get_umat($_POST['ddl_kelas1'] , $_POST['ddl_kelas1']); } </code></pre> And this in my model : <pre><code>if((int)$kelas1 != 0) { echo $kelas1; var_dump($kelas1); $this->db->where('mskelas.kelas_id', $kelas1); } </code></pre> What i get is, the <code>$kelas1</code> is already an int now, but the code is still not working. I think it has something to do with <code>$_POST</code> in my <code>select</code> in html, or something else :D However, this code is still working perfectly (just like above, i manually changed the parameter to 1 (integer)) : <pre><code>public function get_umat($kelas1 = 1, $kelas2 = 0) </code></pre> This is my full controller code : <pre><code>public function index() { //table $data_umat = $this->backend_m->get_umat()->result(); $this->table->set_heading( 'No', 'Nama', 'Kelas', 'Alamat', 'Sekolah', 'Nomor Telepon', 'Keterangan' ); $table_template = array('table_open' => '<table border="1" id="custom_table">'); $this->table->set_template($table_template); $no = 1; foreach($data_umat as $list_temp) { $this->table->add_row( $no++, $list_temp->nama, $list_temp->kelas, $list_temp->alamat, $list_temp->sekolah, $list_temp->no_tlpn, $list_temp->keterangan ); } $data_kelas = $this->backend_m->get_kelas()->result(); $data['list_kelas'][0] = 'Pilih Kelas'; foreach($data_kelas as $row) { $data['list_kelas'][$row->kelas_id] = $row->kelas; } $data['table'] = $this->table->generate(); $this->load->view('backend/home_v', $data); if(isset($_POST['btnSearch'])) { //$test = (int)$_POST['ddl_kelas1']; $test = (int)$this->input->post('ddl_kelas1'); $this->backend_m->get_umat($test , $_POST['ddl_kelas1'], $_POST['txtNama']); } } </code></pre> Pretty confusing, meh? EASY ANSWER FOR THOSE WHO HAVE THE SAME PROBLEM Use <code>$_POST</code> or <code>$this->input->post()</code> in model, not in controller. So we dont have to call the model's method.
Tags
<php><codeigniter>
Title
php difference between 1 and '1'
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USBlaze Tama
UserOwnerUserId
1. USBlaze Tama
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.