mysql 数据库分页逻辑

mysql 数据库分页逻辑

// 基于0,  返回0：错误, 否则返回总页数
uint get_recs_on_page_of(int page_index, int n_per_page)
{
     int n = select  count(*) from books;
     int page_count;
     page_count = n/page_count;
     n?(page_count += n%page_count?1:0): page_count=1;
    
     if ( page_index >= page_count ) return 0;
     int offset = page_index*n_per_page;
     print (select * from table where ... limit offset, n_per_page);
     return page_count;
}