通过使用codeigniter实现分页来显示更新的表

I'm a beginner at this, so I just started pagination. My problem is that I can display pages for viewing just fine but once I update a record the method causes error.Here is the code

controller

<?php

class Regc extends CI_Controller 
{

function __construct()
{
    parent::__construct();
    $this->load->helper(array('form', 'url'));

}

function index() 
{
    $this->load->view('regv');
}

function insert()
{
    $a=$this->input->post('fname');
    $b=$this->input->post('lname');    
    $c=$this->input->post('date');    
    $d=$this->input->post('place');    
    $e=$this->input->post('qual');    
    $f=$this->input->post('gender');    
    $g=$this->input->post('text');
    $h=$this->input->post('mobile');    
    $i=$this->input->post('email');    
    $config['upload_path'] = './uploads/';
    $config['allowed_types'] = 'gif|jpg|png|mp3';
    $config['max_size'] = '10000000';
    $config['max_width'] = '1024';
    $config['max_height'] = '768';

    $this->load->library('upload', $config);


        if (!$this->upload->do_upload())
        {
        $error = array('error' => $this->upload->display_errors());

        $this->load->view('name', $error);
        } 
        else 
        {
        $x = $this->upload->data();
        $image = $x["file_name"];
        $this->load->model("regm");

        $data = array('upload_data' => $this->upload->data());

    $this->load->model('regm');
    $query=$this->regm->insertdata($a,$b,$c,$d,$e,$f,$g,$h,$i,$image); 
    $this->load->view('regv');
        }
}
function select()
    {

        $this->load->model('regm');

        $this->load->library('pagination');
    $config['base_url'] = base_url() . 'index.php/regc/select';
    $config['total_rows'] = $this->db->get_where('register')->num_rows();
    $config['per_page'] = 2;
    $this->pagination->initialize($config);
    $q['link'] = $this->pagination->create_links();
    $this->load->model('regm');
    $off = $this->uri->segment(3, 0);
    $q['query'] = $this->regm->select($config['per_page'], $off);
    $this->load->view('new', $q);

    }
    function update($id)
        {
    $this->load->model('regm');
    $result['query']=$this->regm->update($id);
    $this->load->view('regedit',$result);
        }
    function edit($id)
        {

$fname=$this->input->post('fname');
$lname=$this->input->post('lname');
$date=$this->input->post('date');
$place=$this->input->post('place');
$qual=$this->input->post('qual');
$gender=$this->input->post('gender');
$text=$this->input->post('text'); 
$mobile=$this->input->post('mobile');
$email=$this->input->post('email');

$config['upload_path'] = './uploads/';
$config['allowed_types'] = 'gif|jpg|png|mp3';
$config['max_size'] = '10000000';
$config['max_width'] = '1024';
$config['max_height'] = '768';
    $this->load->library('upload', $config);
    if (!$this->upload->do_upload())
        {
        $error = array('error' => $this->upload->display_errors());
        $this->load->view('name', $error);
        } 
        else 
        {
        $x = $this->upload->data();
        $image = $x["file_name"];
        $this->load->model("regm");

        $data = array('upload_data' => $this->upload->data());


        $this->load->model('regm');



        $xt['qry']=$this->regm->edit($id,$fname,$lname,$date,$place,$qual,$gender,$text,$mobile,$email,$image);

        $this->load->library('pagination');
        $config['base_url'] = base_url() .'index.php/regc/select';
        $config['total_rows'] = $this->db->get_where('register')->num_rows();
        $config['per_page'] = 2;
        $this->pagination->initialize($config);
        $xt['link'] = $this->pagination->create_links();
        $this->load->model('regm');
        $off = $this->uri->segment(3, 0);
        $xt['query'] = $this->regm->select($config['per_page'], $off);


        $this->load->view('new1',$xt);


        }

        }
    function delete($id)
   {
     $this->load->model('regm');
     $this->regm->row_delete($id);
     redirect($_SERVER['HTTP_REFERER']); 
   }
  }

Model

<?php
class Regm extends CI_Model 
 {
function __construct()
{
    parent::__construct();
   $this->load->database();
}
function insertdata($a,$b,$c,$d,$e,$f,$g,$h,$i,$image)

{
$this->db->set('fname',$a); 
$this->db->set('lname',$b); 
$this->db->set('dob',$c); 
$this->db->set('place',$d); 
$this->db->set('qual',$e); 
$this->db->set('gender',$f); 
$this->db->set('address ',$g); 
$this->db->set('mobile',$h); 
$this->db->set('email',$i); 
$this->db->set('img',$image);
$this->db->insert('register');
}
 function select($c,$r)
{
    $this->db->select('*');
    $query= $this->db->from('register');
    $query= $this->db->limit($c,$r)->get();
    return  $query->result();
}
function update($id)
{
    $this->db->select('*');
    $this->db->where('id',$id);
    $query=$this->db->get('register');
    return $query->result();
    }
function   edit($id,$fname,$lname,$date,$place,$qual,$gender,$text,$mobile,$email,$image)

   {

$this->db->where('id',$id);

$this->db->set('fname',$fname); 
$this->db->set('lname',$lname); 
$this->db->set('dob',$date); 
$this->db->set('place',$place); 
$this->db->set('qual',$qual); 
$this->db->set('gender',$gender); 
$this->db->set('address ',$text); 
$this->db->set('mobile',$mobile); 
$this->db->set('email',$email); 
$this->db->set('img',$image);
$this->db->update('register');
$qry=$this->db->get('register');

return $qry->result();
}
function row_delete($id)
    {
    $this->db->where('id', $id);
    $this->db->delete('register'); 
    }

}

view

<html>
<body>
    <?php 
    echo form_open_multipart('regc/insert');
    ?>
    <table> 
        <tr>
            <td>Image</td>



                <input type="file" name="userfile" size="20" />
        </tr>
        <tr>
            <td>Firstname:</td>
            <td><input type="text" name="fname" value=""></td>
        </tr>
        <tr>
            <td>Lastname:</td>
            <td><input type="text" name="lname" value=""></td>
        </tr>
        <tr>
        <td>DOB:</td>
        <td><input type="date" name="date" value=""></td>
        </tr>
        <tr>
        <td>place:</td>
        <td><input type="text" name="place" value=""></td>
        </tr>
        <tr>
        <td>qualification</td>
                    <td><select name="qual">
                            <option value="btech">btech</option>
                            <option value="mtech">mtech</option>
                        </select>
             </tr>
              <tr>
                    <td>gender</td>
                    <td><input type="radio" name="gender" value="male"/>male 
                        <input type="radio" name="gender" value="female"/>female 
                    </td>  
                </tr>
                <tr>
                    <td>address:</td>
                    <td><textarea  name="text" rows="10" cols="10"/></textarea>
                </tr>
                <tr>
                    <td>mobile:</td>
                    <td><input type="tel" name="mobile" value=""/></td>   
                </tr>
                <tr> 
                    <td>email:</td>
                    <td><input type="email" name="email" value=""/></td>
                </tr>


    </form>  
        </table>
                    <input type="submit" name="submit" value="register"/></td>

    <?php echo form_close();?>
    <?php echo form_open('regc/select');?>
     <input type="submit" name="view" value="view"/>

    <?php echo form_close();?>

</body>

other view pages

new

<html>
<body>
    <?php echo form_open();?>
    <table border="2">
        <tr>
            <th>Image</th>
            <th>FirstName</th>
            <th>LastName</th>
            <th>DOB</th>
            <th>Place</th>
            <th>Qualification</th>
            <th>Gender</th>
            <th>Address</th>
            <th>Mobile</th>
            <th>Email</th>
            <th>Edit</th>
            <th>Delete</th>
        </tr>  
        <?php
        foreach($query as $row)
        {
            $id=$row->id;
            $image=$row->img;
            $fname=$row->fname;
             $lname=$row->lname;
              $date=$row->dob;
               $place=$row->place;
                $qual=$row->qual;
                 $gen=$row->gender;
                  $addr=$row->address;
                   $mob=$row->mobile;
            $em=$row->email;
            ?><tr>
                <td><img src="<?php echo base_url().'uploads/'.$row->img ?>" class="img-responsive" width="100" height="100"></td>
                <td align="center"><?php echo $fname; ?></td>
                 <td align="center"><?php echo $lname; ?></td>
                  <td align="center"><?php echo $date; ?></td>
                   <td align="center"><?php echo $place; ?></td>
                    <td align="center"><?php echo $qual; ?></td>
                    <td align="center"><?php echo $gen; ?></td>
                     <td align="center"><?php echo $addr; ?></td> 
                      <td align="center"><?php echo $mob; ?></td>
                       <td align="center"><?php echo $em; ?></td>

                <td><a href="<?php echo site_url('regc/update/'.$id);?>">Edit</a></td>
                <td><a href="<?php echo site_url('regc/delete/'.$id);?>">Delete</a></td>
            </tr>


        <?php }
     ?>   

    </table>

    <?php echo form_close() ?>
    <?php
    echo $link ;
  ?>
</body>

new1

<html>
<body>
    <?php echo form_open_multipart();?>
    <table border="1">
        <tr>
            <th>Image</th>
            <th>FirstName</th>
            <th>LastName</th>
            <th>DOB</th>
            <th>Place</th>
            <th>Qualification</th>
            <th>Gender</th>
            <th>Address</th>
            <th>Mobile</th>
            <th>Email</th>
            <th>Edit</th>
            <th>Delete</th>
        </tr>  
        <?php
        foreach($qry as $row)
        {
            $id=$row->id;
            $image=$row->img;
            $fname=$row->fname;
             $lname=$row->lname;
              $date=$row->dob;
               $place=$row->place;
                $qual=$row->qual;
                 $gen=$row->gender;
                  $addr=$row->address;
                   $mob=$row->mobile;
            $em=$row->email;
            ?><tr>
                <td><img src="<?php echo base_url().'uploads/'.$row->img ?>" class="img-responsive" width="100" height="100"></td>
                <td><?php echo $fname; ?></td>
                <td><?php echo $lname; ?></td>
                 <td><?php echo $date; ?></td>
                  <td><?php echo $place; ?></td>
                   <td><?php echo $qual; ?></td>
                    <td><?php echo $gen; ?></td>
                     <td><?php echo $addr; ?></td> 
                     <td><?php echo $mob; ?></td>
                      <td><?php echo $em; ?></td>

                <td><a href="<?php echo site_url('regc/update/'.$id);?>">Edit</a></td>
                <td><a href="<?php echo site_url('regc/delete/'.$id);?>">Delete</a></td>
            </tr>


        <?php }
     ?>   

    </table>

    <?php echo form_close() ?>

</body>

I just want to display the updated table with pagination.There might be mistakes but please tell me whats wrong.

Thanks in advance!

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

duanqiu2064 2015-06-08 09:07

关注

In Controller

<?php
    $this->load->model('regm');
    $this->pagination->initialize($config);

    $count= $this->db->get_where('register')->num_rows();//Count

    $this->load->library('pagination');

    $config['base_url'] = base_url() .'index.php/regc/select';
    $config['total_rows'] = $count;
    $config['per_page'] = 2;
    $config['uri_segment'] = 3;
    $limit = $config['per_page']; //define how many items to show   


    $page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0;

    $data['links'] = $this->pagination->create_links();
    $data['query'] = $this->regm->select($limit, $data);

in Model

function select($page , $limit)
{
    $query = $this->db->query("SELECT * FROM register LIMIT $page, $limit");
    $result = $query->result_array();
    return $result;
}

in view(pagination view)

<html>
<body>
<?php echo form_open();?>
<table border="2">
    <tr>
        <th>Image</th>
        <th>FirstName</th>
        <th>LastName</th>
        <th>DOB</th>
        <th>Place</th>
        <th>Qualification</th>
        <th>Gender</th>
        <th>Address</th>
        <th>Mobile</th>
        <th>Email</th>
        <th>Edit</th>
        <th>Delete</th>
    </tr>
    <?php
        foreach($query as $row)
        {
            ?>
            <tr>
                <td><img src="<?php echo base_url().'uploads/'.$row->img; ?>" class="img-responsive" width="100" height="100"></td>
                <td align="center"><?php echo $row->fname; ?></td>
                <td align="center"><?php echo $row->lname; ?></td>
                <td align="center"><?php echo $row->dob; ?></td>
                <td align="center"><?php echo $row->place; ?></td>
                <td align="center"><?php echo $row->qual; ?></td>
                <td align="center"><?php echo $row->gender; ?></td>
                <td align="center"><?php echo $row->address; ?></td>
                <td align="center"><?php echo $row->mobile; ?></td>
                <td align="center"><?php echo $row->email; ?></td>

                <td><a href="<?php echo site_url('regc/update/'.$row->id);?>">Edit</a></td>
                <td><a href="<?php echo site_url('regc/delete/'.$row->id);?>">Delete</a></td>
            </tr>

        <?php
        }
    ?>

</table>

<?php echo form_close() ?>
<?php
    echo $link ;
?>
</body>
</html>

报告相同问题？

关注问题

codeigniter分页显示所有记录 php
2016-06-23 09:01

回答 2 已采纳 Try this - Tested and working on mine Your URI segment will be 2 - $config['uri_segment']
codeigniter分页不显示链接 php
2013-04-22 07:34

回答 2 已采纳 You are passing the in the every alboum count as total_albums but the pagination library is lookin
无法使用codeigniter分页类正确加载数据库结果 php
2015-05-15 01:43

回答 1 已采纳 Use $offset = $this->input->get('pageno'); for your offset.
codeigniter中测试通过的分页类示例
2020-12-18 15:53

通用分页类（以Codeigniter测试） page_list.php复制代码代码如下:<?php if( ! defined(‘BASEPATH’)) die(‘No Access’); /** * 分页类 */class Page_list { /** * 总数据 * @var int */ private $...
CodeIgniter与Ajax分页 ajax jquery php
2016-02-09 11:14

回答 1 已采纳 Please Use this code in view $(function() { paginate(); }); function paginate() {
CodeIgniter：分页不允许我通过发布表单来更改功能 php
2014-10-17 07:20

回答 1 已采纳 So I figured it out, basically I am posting my form to 'filter' when I should be posting it to '/m
Codeigniter分页和List.js html javascript php
2019-03-16 14:11

回答 1 已采纳 I thought that list.js requried exisiting pagination to work. However, list.js does every thing on
Codeigniter框架实现获取分页数据和总条数的方法
2021-01-21 16:00

本文实例讲述了Codeigniter框架实现获取分页数据和总条数的方法。分享给大家供大家参考。具体实现方法如下：一般在数据分页的时候需要获取当前页的数据和总条数，一般人是在model中封装两个函数分别获取当前页的...
Codeigniter分页：错误自动增量编号 php
2017-04-05 04:55

回答 1 已采纳 It will work. I am using same pagination. Update controller: public function gate() { $this-&
高级搜索在codeigniter中使用分页 php
2016-06-14 11:31

回答 1 已采纳 Method one (recommended) So for pagination in CodeIgniter, you have 3 main variables you must set
在CodeIgniter分页中排序 php
2015-06-29 06:38

回答 2 已采纳 I did the following to get the answer: Changed the order of the parameters passed in the functio
PHP CodeIgniter分页实例及多条件查询解决方案(推荐)
2020-10-19 20:04

主要介绍了PHP CodeIgniter分页实例及多条件查询的思路详解，非常不错，具有参考借鉴价值,需要的朋友可以参考下
Codeigniter使用get方法对搜索结果进行分页 php
2014-10-19 10:03

回答 1 已采纳 That is because the validation class in CodeIgniter does not check for $_GET parameters and tries
CodeIgniter分页类pagination使用方法示例
2020-12-19 18:21

本文实例讲述了CodeIgniter分页类pagination使用方法。分享给大家供大家参考，具体如下： controller控制器（application/controller/page.php文件）： public function index() { $this->load->model ( 'home_...
php分页显示页数代码,php-Codeigniter分页显示结果数和页数
2021-03-23 22:02

段元朋的博客使用分页类,我想在每个页面的顶部显示以下内容；Showing x to y of z results哪里;x = start rowy - end rowz = total rows`Showing 1 to 10 of 5213 results.``Showing 11 to 20 of 5213 results.``etc`...
pagination_helper:使用Bootstrap分页类的Codeigniter的简单分页助手
2021-05-21 01:21

pagination_helper 使用Bootstrap分页类的Codeigniter的简单分页助手#Instructions控制器中的第一个加载分页库加载分页... 通过计算您要分页的表的总行数来获取此信息。 $ uri =这是包含分页的控制器类/函数的完整URI。
使用codeigniter_使用CodeIgniter分页
2020-08-10 19:04

culi3118的博客使用codeigniterWhen you perform a search on Google, the results are displayed in a list and you have the option to click through pages of the results. That is an example of pagination. Pagination ...
使用配置类定义Codeigniter全局变量
2021-01-20 01:08

CodeIgniter中公共函数不能追加，可以通过 helper 辅助函数实现。创建 common_helper.php 文件，定义所需公共函数，存放至 application/helpers 目录中。在 application/config/autoload.php 中配置 $autoload[...
php get 分页,codeigniter实现get分页的方法
2021-04-30 05:24

遇见sher的博客 //get分页配置 $name = $get_data['name']; $username = $get_data['username']; $budget = $get_data['budget']; $type = $get_data['type']; $posttime_start = $get_data['posttime_start']; $posttime_end = $...
Codeigniter(CI)框架分页函数及相关知识
2020-12-19 02:55

一般在数据分页的时候需要获取当前页的数据和总条数，一般人是在model中封装两个函数分别获取当前页的数据和数据总条数，业务逻辑类似，感觉有点冗余，可以封装在一起：复制代码代码如下: /** * 获取分页数据及...
没有解决我的问题, 去提问

悬赏问题

¥20 BAPI_PR_CHANGE how to add account assignment information for service line
¥500 火焰左右视图、视差（基于双目相机）
¥100 set_link_state
¥15 虚幻5 UE美术毛发渲染
¥15 CVRP 图论物流运输优化
¥15 Tableau online 嵌入ppt失败
¥100 支付宝网页转账系统不识别账号
¥15 基于单片机的靶位控制系统
¥15 真我手机蓝牙传输进度消息被关闭了，怎么打开？(关键词-消息通知)
¥15 装 pytorch 的时候出了好多问题，遇到这种情况怎么处理？

码龄粉丝数原力等级 --

通过使用codeigniter实现分页来显示更新的表

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

通过使用codeigniter实现分页来显示更新的表

1条回答 默认 最新

悬赏问题

1条回答默认最新