EllisLab text mark
Advanced Search
     
problem count rows on table in pagination?
Posted: 14 August 2011 04:02 PM
Avatar
Joined: 2010-11-22
188 posts

I have an problem with rownum in following code. it is this that, in each page of pagination rows in table be counted from the beginning. For example, the clear:

P1: If we’re on the first page of pagination, rows are the counts:

1 Columns1
2 Columns2
3 Columns3
4 Columns4 

P2: If we’re on the second page of pagination, rows are the counts:

1 Columns5
2 Columns6
3 Columns7
4 Columns8 


P2: The I want to be counted row in table,(on the second page of pagination and ...):

5 Columns5
6 Columns6
7 Columns7
8 Columns8 

P3: ... and more

This code:

$data['results'$this->db->query("SELECT @rownum:=@rownum+1 rownum, t.* ".
            
"FROM (SELECT @rownum:=0) r, hotel_submits t ".
            
"ORDER BY id desc LIMIT $offset, 4"); 

Full code:

function show($offset 0
        
{
        $this
->load->library('pagination');
            
$config['base_url'base_url().'admin/accommodation/show';
            
$config['uri_segment'4;
            
$config['total_rows'$this->db->count_all('hotel_submits');
            
$config['per_page''4';            
            
            
$this->pagination->initialize($config);    
                
$data['pagination'$this->pagination->create_links();                                        

            
$offset = (int) $offset// just to make sure nothing funky gets in here
            
$data['results'$this->db->query("SELECT @rownum:=@rownum+1 rownum, t.* ".
                
"FROM (SELECT @rownum:=0) r, hotel_submits t ".
                
"ORDER BY id desc LIMIT $offset, 4");
           
                
////////////////////////                                
                
                
$this->load->view('admin/accommodation_submit_show'$data); 
    

How is it?
With respect

 
Posted: 14 August 2011 08:00 PM   [ # 1 ]   [ Rating: 0 ]
Avatar
Joined: 2010-11-22
188 posts

More about this: I do not want that in each page of pagination, rows are counted from the beginning.
The next page will be counted on every prev page.

see this images:
http://i.stack.imgur.com/2QzSc.gif
http://i.stack.imgur.com/komL3.gif
http://i.stack.imgur.com/6RQIb.gif

my view:

<div class="table_show">
    <
table>
        <
tr>
                <
th><input type="checkbox" name="remember_me" value="true" ></th>
                <
th>#</th>
                
<th>نوع</th>
                <
th>نام</th>
                <
th>ستاره نوع</th>
                <
th>آدرس</th>
                <
th>شماره تماس</th>
                <
th>نمابر</th>
                <
th>وب سایت</th>
                <
th>ایمیل</th>
                <
th>زمان ثبت</th>
        </
tr>
    
<?php
    
//echo $this->table->generate($results);    
        
foreach ($results->result() as $row)
        
{
                
echo    '<tr><td><input type="checkbox" name="remember_me" value="true" ></td>';
                echo    
'<td>'.$row->rownum.'</td>';
                echo    
'<td>'.$row->type.'</td>';
                echo    
'<td>'.$row->name.'</td>';
                echo    
'<td>'.$row->star.' - '.$row->type_star.'</td>';                                
                echo    
'<td><span id="'.$row->address.'" class="tooltip">'.$row->address.'</span></td>';
                echo    
'<td><span id="'.$row->number_phone.'" class="tooltip">'.$row->number_phone.'</span></td>';
                echo    
'<td>'.$row->fax.'</td>';
                echo    
'<td>'.$row->site.'</td>';
                echo    
'<td>'.$row->email.'</td>';
                echo    
'<td>'.$row->date.'</td></tr>';
            
}
    ?>

    
</table>
    
<?$pagination;?>
</div
 
Posted: 15 August 2011 06:23 AM   [ # 2 ]   [ Rating: 0 ]
Avatar
Joined: 2010-11-22
188 posts

Please help me…