[eluser]Unknown[/eluser]
hi I've run through the database tutorial for codeigniter but i'm having trouble recreating it all im trying to do is view data from my database as show here
http://ellislab.com/codeigniter/user-gui...ction.html.
the code
controller - user.php
Code:
<?php
class News extends CI_Controller {
public function __construct()
{
parent::__construct();
$this->load->model('user_model');
}
public function index()
{
$data['username'] = $this->user->get_users();
$data['title'] = 'Members';
$this->load->view('templates/header', $data);
$this->load->view('user/index', $data);
$this->load->view('templates/footer');
}
public function view($username)
{
$data['username'] = $this->user_model->get_user($username);
if (empty($data['user_item']))
{
show_404();
}
$data['username'] = $data['user_item']['username'];
$this->load->view('templates/header', $data);
$this->load->view('news/view', $data);
$this->load->view('templates/footer');
}
}
method - user_model
Code:
<?php
class News_model extends CI_Model {
public function __construct()
{
$this->load->database();
}
public function get_users($username = FALSE)
{
if ($username === FALSE)
{
$query = $this->db->get('000membrs');
return $query->result_array();
}
$query = $this->db->get_where('000membrs', array('username' => $username));
return $query->row_array();
}
}
view - user/index.php
Code:
<?php foreach ($user as $user_item): ?>
<h2><?php echo $user_item['username'] ?></h2>
<div id="main">
<?php echo $user_item['password'] ?>
</div>
<p><a href="news/<?php echo $user_item['userid'] ?>">View article</a></p>
<?php endforeach ?>
view - user/view.php
Code:
<?php
echo '<h2>'.$user_item['username'].'</h2>';
echo $user_item['password'];
route
Code:
$route['user/(:any)'] = 'user/view/$1';
$route['user'] = 'user';
table name - 000membrs
columns - Userid`, `username`, `Password`, `Firstname`, `Surname`, `Email`, `Admin
any help would be appreciated
im an idiot i figured it out today the problem was i dint change the class names on the controller and method