如何在codeigniter中执行排序，搜索，分页 [英] how to perform sorting,search,pagination in codeigniter

问题描述

我是一个更新的codeigniter。我想搜索，排序和应用分页到我的表。
我试过我的best.when搜索代码工作排序可能不工作。我不能在单个表中执行这三个操作。请帮帮我。

解决方案

使用

I'm a fresher in codeigniter. I want to search,sort and apply pagination to my table. I tried my best.when search code is working sorting may not work. i can't perform these three actions in a single table. please help me.

解决方案

use Bootstrap datatables. It has in built search, Sort and pagination too.

---

Sample of My code

In View

<div style="clear: both; margin-top: 35px"></div>
<div class="container">
    <div class="col-sm-12" style="padding: 0px">
        <div class="row">
            <div class="col-sm-10 col-sm-offset-1 " style="padding-right:0px;">
                <table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">

                    <thead>
                    <tr>
                        <th width="20%"></th>
                        <th width="15%"></th>
                        <th width="20%"></th>
                        <th width="15%"></th>
                        <th width="10%"></th>
                    </tr>
                    </thead>
                    <tbody>
                    <?
                        foreach ( $ as $ )
                        {
                            ?>
                            <tr>
                                <td><?php echo $['']?></td>
                                <td><?php echo $['']?></td>
                                <td><?php echo $['']?></td>
                                <td><?php echo $['']?></td>
                            </tr>
                        <?
                        }

                    ?>

                    </tbody>
                </table>
            </div>

        </div>
    </div>
</div>

In Controller

$data[''] = $this->model_name->function_name();

In Header

<link href="<?php echo base_url(); ?>css/bootstrap.css" rel="stylesheet" /> 
<link href="<?php echo base_url(); ?>css/bootstrap-glyphicons.css" rel="stylesheet" />
<link href="https://cdn.datatables.net/plug-ins/1.10.7/integration/bootstrap/3/dataTables.bootstrap.css" rel="stylesheet" />

---

Output

这篇关于如何在codeigniter中执行排序，搜索，分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！