在CodeIgniter中,从数据库读取数据,并分页显示,每一条数据旁边都有一个按钮,请问怎么实现?
假设一个新闻列表分页:
views:
<?php echo $fen;?>
controllers:
public function index()
{
$this->load->library('parser');
$this->load->database();
$this->load->library('pagination');
//新闻总条数
$data['news_rows'] = $this->db->query("
SELECT id FROM news
") -> result_array();
//网址中取得参数,这里的uri_segment = 3
$config['base_url'] = base_url().'index.php/news/1/';
$config['total_rows'] = count($data['news_rows']);
$config['per_page'] = 10;
$config['uri_segment'] = 3;
//下面是一些css配置
$config['num_tag_open'] = '<div class="listPage2">';
$config['num_tag_close'] = '</div>';
$config['cur_tag_open'] = '<div class="listPage3"><a href="javascript:void(0)">';
$config['cur_tag_close'] = '</a></div>';
$config['prev_link'] = '<<';
$config['prev_tag_open'] = '<div class="listPage">';
$config['prev_tag_close'] = '</div>';
$config['next_link'] = '>>';
$config['next_tag_open'] = '<div class="listPage">';
$config['next_tag_close'] = '</div>';
//初始化,要分页啦
$this->pagination->initialize($config);
//开始分页
$start = $this->uri->segment(3,0);
if(!$start){
$start = 0;
}
$data['news'] = $this->db->query("
SELECT id,title FROM news
limit $start,10
") -> result_array();
$data['fen'] = $this->pagination->create_links();
$this->parser->parse('news.html', $data);
}
上面的config里面的css样式自己写,比如:
/*分页*/
.listPage{float:left;font-size:12px;background:#BC2222;color:white;border:1px solid #CA6A6B;padding:0px 10px;margin-right:3px;font-family:Arial;}
.listPage:hover{background:#BC5555;}
.listPage2{float:left;font-size:12px;background:#7F7F7F;color:white;border:1px solid #EBEDEC;padding:0px 10px;margin-right:3px;}
.listPage2:hover{background:#333;}
.listPage3{float:left;font-size:12px;background:#333;color:white;border:1px solid #EBEDEC;padding:0px 10px;margin-right:3px;}
1 回答4.1k 阅读✓ 已解决
3 回答1.8k 阅读✓ 已解决
2 回答2.2k 阅读✓ 已解决
2 回答2.2k 阅读
1 回答1.4k 阅读✓ 已解决
792 阅读
638 阅读
看手册啊。。
这种基础的问题手册上都有的,
http://codeigniter.org.cn/user_guide/