controllers下的 cquery.php文件
- <?php
- class CQuery extends Controller {
- //构造函数
- function CQuery() {
- parent::Controller();
- // $this->load->database();
- }
- function index() {
- //调用model 其中train为外层文件夹 MQuery为model名称 queryList为重命名
- $this->load->model('train/MQuery','queryList');
- //获得返回的结果集 这里确定调用model中的哪个方法
- $result = $this->queryList->queryList();
- //将结果集赋给res
- $this->smarty->assign('res',$result);
- //跳转到显示页面
- $this->smarty->view('train/vquery.tpl');
- }
- //进入新增页面
- function addPage() {
- $this->smarty->view('train/addPage.tpl');
- }
- //新增
- function add() {
- //获得前台数据
- //用户名
- $memberName = $this->input->post('memberName');
- //密码
- $password = $this->input->post('password');
- //真实姓名
- $userRealName = $this->input->post('userRealName');
- //性别
- $sex = $this->input->post('sex');
- //出生日期
- $bornDay = $this->input->post('bornDay');
- //e_mail
- $eMail = $this->input->post('eMail');
- //密码问题
- $question = $this->input->post('question');
- //密码答案
- $answer = $this->input->post('answer');
- //调用model
- $this->load->model('train/MQuery','addRecord');
- //向model中的addRecord传值
- $result = $this->addRecord->addRecord($memberName,$password,$userRealName,$sex,$bornDay,$eMail,$question,$answer);
- //判断返回的结果,如果返回true,则调用本页的index方法,不要写 $result == false 因为返回的值未必是false 也有可能是""
- if ($result) {
- $this->index();
- } else {
- echo "add failed.";
- }
- }
- //删除
- function deletePage() {
- //获得ID
- $deleteID = $this->uri->segment(4);
- //调用model
- $this->load->model('train/MQuery','delRecord');
- //将值传入到model的delRecord方法中
- $result = $this->delRecord->delRecord($deleteID);
- //判断返回值
- if ($result) {
- $this