ci分页问题，请帮忙解决下

liaomars · 发表于 2011-1-6 11:49:44

本帖最后由 liaomars 于 2011-1-6 11:52 编辑

这是我的控制器，分页的方法

PHP复制代码

<?php

/*
* Author@Liaobingbing
* liaoyunyu@gmail.com
* 留言本condeigniter
*/
date_default_timezone_set('Asia/Shanghai');

class Feedback extends Controller {

function __construct() {
parent::Controller();
$this->load->helper('url');
$this->load->helper('form');
$this->load->helper('date');
}

function _pagelist($method, $total, $perpage=2) {
$config['base_url'] = base_url() . 'index.php/' . 'Feedback/' . $method . '/';
$config['total_rows'] = $total;
$config['per_page'] = $perpage;
return $config;
}

function message_list() {
$this->load->library('pagination');
$this->load->model("Feed", '', true);
$rows = (int) $this->db->count_all('feed');
// echo $rows;
$conf = $this->_pagelist('message_list', $rows);
// print_r($conf);
$this->pagination->initialize($conf);
$offset = (int) $this->uri->segment(3);
echo $offset;
$sql = "SELECT * FROM feed ;";
//$this->db->select('*')->from('feed')->limit($offset, $conf['per_page']);
//$data['result'] = $this->db->get('feed',$offset,$conf['per_page']);
$data['result'] = $this->db->query($sql, array($offset, $conf['per_page']));
$data['include'] = "head";
$data['view_message'] = "view_message";
$data['title'] = "查看留言";
$this->load->view('view_message', $data);
}

}

?>

复制代码

这是视图页面。

HTML复制代码

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $title;?></title>
<base href="<?php echo base_url();?>"/>
<style type="text/css">
body{ margin:0px; padding:0px; font-size:12px; font-family:微软雅黑,Verdana, Geneva, sans-serif;}
div,ul,li,form,dl,dt,dd,table,td{margin:0px; padding:0px; }
.feed{ width:800px; margin:0 auto; }
.nav{ height:30px; line-height:30px; background:#9a9898; width:800px; overflow:hidden; margin-top:5px;}
.nav ul li{ float:left; width:90px; text-align:center; display:block; font-size:14px;}
.table{border:solid 1px #ccc; border-collapse: collapse; margin: 5px 0px; }
.table td{border:solid 1px #ccc; height: 30px; }
</style>
</head>

<body>
<div class="feed">
<?php $this->load->view($include);?>
<?php
foreach($result->result() as $rs){
?>
<table width="500" border="0" cellspacing="0" cellpadding="0" align="center" class="table">
<tr>
<td colspan="2">标题:<?php echo $rs->title;?></td>
</tr>
<tr>
<td width="218">时间:<?php echo $rs->addtime;?></td>
<td width="282">IP地址:<?php echo $rs->ipaddress;?></td>
</tr>
<tr>
<td colspan="2"><?php echo $rs->content;?></td>
</tr>
</table>
<?php }?>
<div><?php echo $this->pagination->create_links();?> </div>
</div>

</body>
</html>

复制代码

我现在数据库有四条数据。我设置每页为2条，但是打开页面还是4条。好像控制器那个查询语句的limit没有起作用。我找了手册。也试过用不同的查询语句。不行。请高手帮忙解答下。在这谢谢了

Hex · 发表于 2011-1-6 13:26:58

PHP复制代码

$sql = "SELECT * FROM feed ;";
$data['result'] = $this->db->query($sql, array($offset, $conf['per_page']));

复制代码

第一句有问题吧，你没写占位符
应该是

PHP复制代码

$sql = "SELECT * FROM feed limit ?,?";

复制代码

liaomars · 发表于 2011-1-6 14:06:46

回复 2# Hex

谢谢管理员。帮我解决问题了

		自动登录	找回密码
密码			入住 CI 中国社区

[已解决] ci分页问题，请帮忙解决下