StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUndefined variable: query - codeigniter
text
Body
copied!<p>I am getting the message: </p> <p>A PHP Error was encountered</p> <p>Severity: Notice</p> <p>Message: Undefined variable: query</p> <p>Filename: views/main.php</p> <p>Line Number: 12</p> <p>This is the code for my controller:</p> <pre><code>function get_all(){ $this->load->model('book_model'); $this->load->library('table'); $this->load->helper('html'); $data['query'] = $this->books_model->books_getall(); $this->load->view('main', $data); } </code></pre> <p>And this is my view:</p> <pre><code><h1> List of books in library</h1> <table border="1"/> <tr> <th>ID</th> <th>Title</th> <th>Author</th> <th>Information</th> <th>Publisher</th> <th colspan="2">Action</th> </tr> <?php if(is_array($query)){ foreach ($query as $row){ echo "<tr>"; echo "<td>".$row->id."</td>"; echo "<td>".$row->title."</td>"; echo "<td>".$row->author."</td>"; echo "<td>".$row->information."</td>"; echo "<td>".$row->publisher."</td>"; echo "<td>".anchor('book/input'.$row->id,'Edit')."</td>"; echo "<td>".anchor('book/delete'.$row->id,'Delete')."</td>"; echo "</tr>"; } } ?> </table> </code></pre> <p>Thanks in advance for any help</p> <p>Edit: This is my model code:</p> <pre><code>function get_all(){ $this->load->database(); $query = $this->db->get('books'); return $query->result(); </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