WordPress.org

Ready to get started?Download WordPress

Forums

Pagination (1 post)

  1. redds013
    Member
    Posted 1 year ago #

    Hi I have the following code : I am trying to paginated my table, I have got it to paginated but the next link takes me to the home page.
    Could someone please assist me.

    Thanks

    Gwen

    [ Moderator Note: Please post code or markup snippets between backticks or use the code button. As it stands, your code may now have been permanently damaged/corrupted by the forum's parser. Or use pastebin.com instead. ]

    <?php
    
    global $wpdb;
    $numpostss = $wpdb->get_results("SELECT COUNT(*) FROM hotels WHERE cat='hotel'", ARRAY_N);
    $numposts = $numpostss[0][0];
    $postsperpage = 3;
    $numofpages = intval($numposts/$postsperpage);
    if ($numposts%$postsperpage) { $numofpages=$numofpages+1; };
    $lastpageposts = $numposts-(($numofpages-1)*$postsperpage);
    $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
    $offset = ($paged-1) * $postsperpage;
    if ($paged==$numpofages) { $postsperpage=$lastpageposts; }
    $myrows = $wpdb->get_results( "SELECT * FROM hotels WHERE cat='hotel' LIMIT $offset, $postsperpage", OBJECT);
    
    //print_r($myrows);
    if ($myrows) {
       foreach ( $myrows as $hotel ) {
    echo "<table width='100%' align='center' border='3px solid grey'>";
    echo"<tr>";
    echo"<th>Picture</th>";
    echo "<th>Details</th>";
    echo "<th>More Info</th>";
    echo "</tr>";
    echo "<tbody>";
    echo "<tr>";
    echo "<td><img src='/images/$hotel->pic' alt='$hotel->name'/></td>";
    echo "<td><h1>{$hotel->name }</h1><h3>{$hotel->address}</h3><p class=\"tag\">{$hotel->tag} <a href="info.php?id=$hotel-">id'>More Info </a></p></td>";
    echo "<td class='contactd'><p class=\"price\"> From £$hotel->Price </p> Per Person Per Night<p class=\"price\">Contact Them On</p>{$hotel->contact}<p class=\"price\">Visit their Website </p><a>website'>{$hotel->website}</a></td>";
    echo "</tr>";
    echo "</tbody>";      
    
    echo "</table>";  
    
      }
    }
    
    ?>
    <?php
    $precpage=$paged-1;
    $nextpage=$paged+1;
    if ($paged>1) {
    if ($precpage==1)
    	{ echo ('<a href="../../">« Home</a>'); }
    	else
    	{ echo ('<a href="../' . $precpage . '/">« Preceding Page</a> • <a href="../../">Home</a>'); }
    }
    if ($nextpage<=$numofpages) {
    	if ($paged==1)
    		{ echo ('<a href="./page/'); }
    		else
    		{ echo (' • <a href="../'); }
    	echo ($nextpage . '/">Next Page »');
    	}
    ?>
    </div>

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.