额，先记下来再说，是个很简单的例子而已：

models/display.php

<?php
class Display extends Model{
public function Display(){
parent::Model();
}
public function get_item($name) {
$sql = “SELECT * FROM users WHERE name = ? “;
$query = $this->db->query($sql, $name);
$rowsnum = $query->num_rows();
return $row;
}
}
?>

—————-

controllers/test.php

<?php
class Test extends Controller {

function Test(){
parent::Controller();
$this->load->helper(‘url’);
$this->load->database();
}

function index(){
$this->load->helper(‘form’);
$data['title'] = “Users add.”;
$data['headline'] = “Welcome! to User System.”;
$this->load->vars($data);
$this->load->view(‘users’);
}
function save(){
$this->load->helper(‘url’);
$this->load->model(‘MtestAdd’,”,TRUE);
$this->MtestAdd->addUser();
redirect(‘http://localhost/codeigniter/index.php/test/thanks’,'refresh’);
}
function display(){
$this->load->model(‘display’);
$data['results'] = $this->display->get_item(‘pheng’);
$this->load->view(‘userslist’,$data);
}
function thanks(){
echo “<h1>Thank you !</h1>”;
}
}
?>

—————-

views/userlist.php

<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
</head>
<body>
<?php
echo $results['id'].’<br/>’;
echo $results['name'].’<br/>’;
echo $results['age'].’<br/>’;
echo $results['sex'].’<br/>’;
?>
</body>
</html>