PHP MessageModel::showMessageByPage Examples

Example #1

File: messageListUIController.php Project: JimChenAnother/notebook

<?php

session_start();
//这是一个控制器，专门处理对信息分页查询
//echo "ok";
require_once 'smarty_inc.php';
require_once '../model/messageModel.class.php';
require_once '../model/mypage.class.php';
require_once '../sqlHelper.class.php';
if (isset($_GET['page'])) {
    $page = $_GET['page'];
}
//获取总记录
$mysqli = new SqlHelper();
$sql = "select count(*) from message where getter = '" . $_SESSION['loginname'] . "'";
$mypage = new Mypage($page, 7, 5, $mysqli->pagingCount($sql));
$mypage->goToURL = 'messageListUIController.php';
$messageModel = new MessageModel();
$smarty->assign('res', $messageModel->showMessageByPage($mypage, $_SESSION['loginname']));
$smarty->assign('page_banne', $mypage->navigationBar());
$smarty->display("messageList.tpl");

Example #2

File: LoginController.php Project: JimChenAnother/notebook

<?php

//echo $emp_name.'----'.$emp_pwd;
//exit();
require_once 'smarty_inc.php';
require_once '../sqlHelper.class.php';
require_once '../model/messageModel.class.php';
require_once '../model/mypage.class.php';
$emp_name = $_POST['emp_name'];
$emp_pwd = $_POST['emp_pwd'];
if ($emp_name == "root" && $emp_pwd == "123") {
    //用session记录
    session_start();
    $_SESSION['loginname'] = $emp_name;
    //计算所有信息条数
    $mysqli = new SqlHelper();
    $sql = "select count(*) from message where getter = '{$emp_name}'";
    //
    $mypage = new Mypage(1, 7, 5, $mysqli->pagingCount($sql));
    $mypage->goToURL = 'messageListUIController.php';
    $messageModel = new MessageModel();
    //print_r($MessageModel);
    $smarty->assign('res', $messageModel->showMessageByPage($mypage, $emp_name));
    $smarty->assign('page_banne', $mypage->navigationBar());
    $smarty->display("messageList.tpl");
} else {
}