StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCodeIgniter Sql syntax not working
text
Body
copied!<p>Okay here i am, be direct i need some advice</p> <p>so here i have some code igniter problem with "Database", this is the code</p> <pre><code> $as="&amp;"; $string1="title="; $a= $this->input->post('title'); $string2="category="; $b= $this->input->post('category'); $string3="length_comparison="; $c= $this->input->post('length_comparison'); $string4="length="; $d= $this->input->post('length'); $combine=$string1.$a.$as.$string2.$b.$as.$string3.$c.$as.$string4.$d; $this->db->select('*'); $this->db->from('ci_query'); $this->db->where('ci_query.query_string',$combine); $query = $this->db->get(); $rows=$query->result(); $count=0; foreach($rows as $row) { $count=$count+1; $query_id = $row->id; } if($count==0) { $query_id = $this->input->save_query($query_array); } redirect("films/display/$query_id"); </code></pre> <p>Here is the logic</p> <pre><code> 1. i got an input from a search form tittle,category,length_comparison,and length. 2. first case these logic will save all those input into a column in a table, all in 1 column, if there is no same parameter "tittle,category,length_comparison,and length" in the table. 3. but if there is any same parameter it will not insert to the table, and just redirect to the page i choose 4. from the table we got the id and display instead of using long query string. display the search result. </code></pre> <p>My problem : i've done the coding and it's work perfectly in my computer/pc. but when i use my laptop it's just doesn't work, anyone can give me some advice ? or my coding? or ci version? or what?</p> <p>Update : </p> <p>i think that is not the problem since i've override the lib, so i have this to use that function </p> <p> <pre><code>function save_query($query_array) { $CI =& get_instance(); $CI->db->insert('search', array('query_string' => http_build_query($query_array))); return $CI->db->insert_id(); } function load_query($query_id) { $CI =& get_instance(); $rows = $CI->db->get_where('search', array('id' => $query_id))->result(); if (isset($rows[0])) { parse_str($rows[0]->query_string, $_GET); } } </code></pre> <p>}</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload