StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The MODEL</p> <pre><code>function addressForMap($id) { $this->db->select('b.id, b.busaddress, b.buscity, b.buszip'); $this->db->from('business as b'); $this->db->where('b.id', $id); // add a limit $this->db->limit(1); // get the results.. cha-ching $q = $this->db->get(); // any results? if($q->num_rows() !== 1) { return FALSE; } return $q->row(); } </code></pre> <p>The CONTROLLER</p> <pre><code>function your_controller_method($id) { $data = $this->Business_model->addressForMap($id); // did we get any results? if($data === FALSE) { show_error(); return; } $marker['address'] = $data->busaddress.' '.$data->buscity.', '.$data->buszip; } </code></pre> <p>Make sure you validate that <code>$id</code> is an actual numerical id. It's a good thing to do before actually performing the query.. IMO.</p> <p><strong>EDIT #2: See changed code above</strong></p> <hr> <p><strong>EDIT #1: From your comment and changes</strong></p> <p>You've got this: </p> <pre><code>return $this->db->get(); </code></pre> <p>when, based on the rest of your code, it should be this:</p> <pre><code>$query = $this->db->get(); </code></pre> <p>When you return the query object, the variable <code>$address</code> gets assigned the CI result object. so, in your controller, you would actually have to do something like this:</p> <pre><code>$address = $this->Business_model->addressForMap($id); $row = $address->row(); $marker['address'] = $row->busaddress .' '.$row->buscity .', '. $row->buszip; </code></pre> <p>Still... I would suggest changing <code>return</code> to <code>$query =</code> and you could keep your controller as it is.</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