StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSearch with two input fields in codeigniter
text
Body
copied!<p>I have a searchform to search factories in my database. my factories table has a field called 'postcode' now when you visit the site for the first time you have to type in your postcode. this will be saved in a cookie so you don't have to change it again.</p> <p>Now i want to search for factories using a searchterm and the cookie 'postcode'</p> <p>here is my searchform <a href="http://kees.een-site-bouwen.nl/" rel="nofollow noreferrer">http://kees.een-site-bouwen.nl/</a></p> <p>So something like this:</p> <pre><code><form action="home/searchresults" method="post"> <input type="search" placeholder="search..." name="search"> <input type="search" value="<?= $this->input->cookie('postcode')?>"> </form> </code></pre> <p>and in my controller something like:</p> <pre><code>$match = $this->input->post('search'); $match2 = $this->input->cookie('postcode'); $data['query'] = $this->bedrijven_model->get_search($match, $match2); $this->load->view('views/header'); $this->load->view('views/searchresults', $data); $this->load->view('views/footer'); </code></pre> <p>in my model i have:</p> <pre><code>function get_search($match) { $this->db->like('Bedrijfsnaam', $match); $this->db->or_like('Postcode', $match); $this->db->or_like('Plaats', $match); $this->db->or_like('Telefoonnummer', $match); $this->db->or_like('Email', $match); $this->db->or_like('Website', $match); $this->db->or_like('Profiel', $match); $this->db->or_like('Adres', $match); $this->db->or_like('Categorie', $match); $this->db->join('bedrijven', 'bedrijfcategorieen.idbedrijven = bedrijven.idbedrijven'); $this->db->join('categorieen', 'bedrijfcategorieen.idcategorieen = categorieen.idcategorieen'); $this->db->group_by('bedrijfcategorieen.idbedrijven', 'bedrijfcategorieen.idcategorieen'); $query = $this->db->get('bedrijfcategorieen'); return $query->result(); } </code></pre> <p>But this does not work. i asked a similar question here: <a href="https://stackoverflow.com/questions/16011313/prevent-overriding-queries-in-controller-function-codeigniter">Prevent overriding queries in controller function - codeigniter</a></p> <p>but no answer that worked for me.</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