Please help with pagenav

[Lea Verou]

I'd like to add a pagenav to a mod I'm developing.
However no matter what I read in the API documentation or saw in vb php files I still can't understand how to use the construct_page_nav() function.
I can't understand what to put as it's variables.
Anyone that does? :nervous:

Thanks in advance

[cinq]

PHP Code:

    $vbulletin->input->clean_array_gpc('r', array(
        'perpage' => TYPE_INT,
        'page' => TYPE_INT
    ));
    
// $TOTALNUMBEROFROWS = total number of rows you have. Probably obtain this from a query and assign $db->num_rows($query) to this.
// $NOOFRESULTSPERPAGE = how many results you want per page. eg. 10 per page or 20 per page.

    $perpage = $NOOFRESULTSPERPAGE;
    $pagenumber = $vbulletin->GPC['page'];
    $pagecount = ceil($TOTALNUMBEROFROWS / $perpage);
    $pagenumber = iif(!is_numeric($pagenumber) OR $pagenumber < 1 OR $pagenumber > $pagecount, 1, $pagenumber);
    $offset = ($pagenumber-1) * $perpage;
        
    if(empty($vbulletin->GPC['page']))
        $page = 1;
    else
        $page = $vbulletin->GPC['page'];
    $pagenav = construct_page_nav($page, $perpage, $TOTALNUMBEROFROWS, "yourpage.php",""); 


Then in your main query which will limit results, use this as the LIMIT condition.

PHP Code:

LIMIT $offset,$perpage 


Now place $pagenav in your template wherever you want it to show.

Hope this helps. It's how I do it at least.

[Lea Verou]

It looks very helpful, thanks so much!
I'll try to use it and come again if I have any questions

Originally Posted by Michelle

It looks very helpful, thanks so much!
I'll try to use it and come again if I have any questions

It really helped but I can't make the LIMIT to work
When I put LIMIT every page is displayed as if it was the first page

[Oreamnos]

i don't think this will help Michelle but don't forget the '?' after yourpage.php?

PHP Code:

$pagenav = construct_page_nav($page, $perpage, $TOTALNUMBEROFROWS, "yourpage.php?",""); 


michelle, if you post your code we might be able to help a bit more.

cinq, worked great! thanks