Welcome Guest, Not a member yet? Register   Sign In
problem reading from the database
#1

[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>&lt;?php echo $user_item['username'] ?&gt;</h2>
    <div id="main">
        &lt;?php echo $user_item['password'] ?&gt;
    </div>
    <p><a href="news/&lt;?php echo $user_item['userid'] ?&gt;">View article</a></p>

&lt;?php endforeach ?&gt;

view - user/view.php
Code:
&lt;?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
#2

[eluser]Tpojka[/eluser]
In user.php file, in index method you have:
Code:
$data['username'] = $this->user->get_users();
What would you get if change it to
Code:
$data['username'] = $this->user_model->get_users();
?




Theme © iAndrew 2016 - Forum software by © MyBB