<div class="main_block"> <br> <h2> Top questions on forum :</h2> <br><br> <div class="user_table"> <?php $o = array(); $obj = new All_users(); $o = $obj->get_user_info(); $i = 0; foreach ($o as $object) { echo "<table><tr>\r\n\t\t\t\t\t<td>Username\r\n\t\t\t\t\t<td><a href=\" view_user/" . $o[$i]->userid . "\">" . $o[$i]->nickname . "</a>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t<td>Specialization\r\n\t\t\t\t\t<td>" . $o[$i]->specialization . "\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t<td>Location\r\n\t\t\t\t\t<td>" . $o[$i]->location . "\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>"; $i++; } ?> </div> </div> </div>
public function get_user_info() { $query = "select * from user_info;"; $records = $this->db->query($query); return All_users::instantiate($records); }