ci使用smarty简单mvc实例
2018-05-28
后端
数据库增加数据
CREATE TABLE IF NOT EXISTS `users` (
`id` INT(8) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(30) CHARACTER SET utf8 DEFAULT NULL,
`age` VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL,
`sex` VARCHAR(2) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci AUTO_INCREMENT=14 ;
model中增加模型mtest.php
class Mtest extends CI_Model{
function Mtest(){
parent::__construct();
}
function
get_last_ten_entries()
{
$this->load->database();
mysql_query("SET NAMES GBK");
//防止中文乱码
$query =
$this->db->get('users');
//var_dump($query->result());
return
$query->result();
}
}
控制器增加test.php
if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Test extends CI_Controller {
function __construct()
{
parent::__construct();
$this->load->helper('url');
$this->tp->assign('base_url',
base_url()); //定义css以及js
}
function index()
{
//$this->output->enable_profiler(TRUE);
//调试模式
//组织简单2维数组测试
$info['title'] = "首页";
$info['headline'] = "录入用户信息";
$info['todo_list'] = array('Clean House', 'Call Mom',
'Run Errands');
//var_dump($info);
$this->tp->assign('info', $info);
$this->load->model('mtest');
//声明model
$data =
$this->mtest->get_last_ten_entries(); //调用model里的方法获得数据
//var_dump($data);
$this->tp->assign('data', $data);
$this->tp->display('user.html');
//显示模版
}
}
模版页面user.html
<{foreach from=$info
item=v}>
<{$v}>
<{foreach from=$v item=a}>
1111111<{$a}>
<{/foreach}>
<{/foreach}>
<{foreach
from=$info.todo_list item=v}>
<{$v}>
<{/foreach}>
<{foreach name=outer
from=$data item=c}>
<{foreach key=key from=$c item=d}>
<{$key}>:<{$d}>
<{/foreach}>
<{/foreach}>