StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to add records to database using a joined table - codeigniter
text
Body
copied!<p>I made a form for adding factories to my database. this works great but i can't show my factories on the page because they're in a joined table, but when i submit the page it does not add an id to the joined table so the factory won't be shown at the page.</p> <p>the joined table looks like this:</p> <pre><code>bedrijfcategorieen ------------------ idbedrijfcat idbedrijven idcategorieen </code></pre> <p>Where idbedrijven is the id for my factories table.</p> <p>My controller function for adding factories:</p> <pre><code>function bedrijven() { $data['options'] = $ddmenu; $this->load->view('members/header'); $this->load->view('members/editform', $data); $this->load->view('members/footer'); } function addbedrijven() { $this->members_model->addbedrijf(); redirect('members/index'); } </code></pre> <p>my model function for adding factories:</p> <pre><code>function addbedrijf() { $data = array( 'idbedrijven' => $idbedrijven, 'Bedrijfsnaam' => $this->input->post('Bedrijfsnaam'), 'Postcode' => $this->input->post('Postcode'), 'Plaats' => $this->input->post('Plaats'), 'Telefoonnummer' => $this->input->post('Telefoonnummer'), 'Email' => $this->input->post('Email'), 'Website' => $this->input->post('Website'), 'Profiel' => $this->input->post('Profiel'), 'Adres' => $this->input->post('Adres'), 'logo' => $this->input->post('logo') ); $this->db->insert('bedrijven', $data); } </code></pre> <p>i would like to add my factories trough the joined table. so it would be easier to add categories to the factories too.</p> <p>I tried <code>where('bedrijfcategorieen.idbedrijven = idbedrijven</code> but it did not work.</p> <hr> <p><strong>table scheme</strong></p> <pre><code>factories --------- idfactories factoryname adress postcode country telephone ... ... categories ---------- idcategories category factorycategories ----------------- idfactorycat idfactories idcategories </code></pre> <hr>

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