contra10 Posted January 31, 2009 Share Posted January 31, 2009 im trying to create a new way of pagination ...currently im using this code <?php if(is_numeric($_GET['user'])){ $idp = $_GET['user']; $insert3= "SELECT * FROM post_profile WHERE userid = '$idp' ORDER BY ppid DESC"; $topic3 = mysql_query($insert3) or die(mysql_error()); } //This checks to see if there is a page number. If not, it will set it to page 1 if (!isset($pagenum)) { $pagenum = (isset($_GET['pagenum'])) ? $_GET['pagenum'] : 1; } //Here we count the number of results //Edit $data to be your query $data = mysql_query("SELECT * FROM post_profile WHERE userid = '$idp' ORDER BY ppid DESC") or die(mysql_error()); $rows = mysql_num_rows($data); //This is the number of results displayed per page $page_rows = 4; //This tells us the page number of our last page $last = ceil($rows/$page_rows); //this makes sure the page number isn't below one, or more than our maximum pages if ($pagenum < 1) { $pagenum = 1; } elseif ($pagenum > $last) { $pagenum = $last; } //This sets the range to display in our query $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; //This is your query again, the same one... the only difference is we add $max into it $data_p = "SELECT * FROM post_profile WHERE userid = '$idp' ORDER BY ppid DESC LIMIT 10"; $posts = mysql_query($data_p) or die(mysql_error()); //This is where you display your query results while($info = mysql_fetch_array($posts)) { $userpost= "{$info['post']}"; $usernamep= "{$info['postingusername']}"; $userdate= "{$info['datepost']}"; echo "<table border='0' align='center'>"; echo "<tr>"; echo"<td width= '500' align='center' bgcolor='black'><FONT FACE='ariel' SIZE='2' color='#0094f7'> $userpost</td>"; echo "</tr>"; echo "<tr>"; echo "<td align='right'><FONT FACE='ariel' SIZE='2' color='#0094f7'>Posted by $usernamep on $userdate</td>"; echo "<tr>"; echo"</table>"; } echo "<p>"; // This shows the user what page they are on, and the total number of pages echo " --Page $pagenum of $last-- <p>"; // First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page. if ($pagenum == 1) { } else { echo " <a href='http://localhost/mypost/index.php?user=$id&pagenum=1'> <<-First</a> "; echo " "; $previous = $pagenum-1; echo " <a href='http://localhost/mypost/index.php?user=$id&pagenum=$previous'> <-Previous</a> "; } //just a spacer echo " ---- "; //This does the same as above, only checking if we are on the last page, and then generating the Next and Last links if ($pagenum == $last) { } else { $next = $pagenum+1; echo " <a href='http://localhost/mypost/index.php?user=$id&pagenum=$next'>Next -></a> "; echo " "; echo " <a href='http://localhost/mypost/index.php?user=$id&pagenum=$last'>Last ->></a> "; } ?> but there is a javascript code that divides the pages into divs <div style="width: 400px;"> <div class="virtualpage hidepiece"> First Piece within Content " </div> <div class="virtualpage hidepiece"> Second Piece within Content " </div> <div class="virtualpage hidepiece"> Third Piece within Content " </div> </div> <div id="paginatediv" class="paginationstyle"> <a href="#" rel="previous" style="margin-right: 100px">Prev</a> <a href="#" rel="next">Next</a> </div> and <script type="text/javascript"> var pagecontent=new virtualpaginate({ piececlass: "virtualpage", //class of container for each piece of content piececontainer: "div", //container element type (ie: "div", "p" etc) pieces_per_page: 1, //Pieces of content to show per page (1=1 piece, 2=2 pieces etc) defaultpage: 0, //Default page selected (0=1st page, 1=2nd page etc). Persistence if enabled overrides this setting. persist: false //Remember last viewed page and recall it when user returns within a browser session? }) pagecontent.buildpagination(["paginatediv"]) </script> to vaguely put it...how can i incorporate my code into this new way of pagination...I'm doing this so that i don't have to reload the page when a page number is clicked THIS MAY BE AN AJAX ISSUE sry for length Quote Link to comment Share on other sites More sharing options...
webster08 Posted February 1, 2009 Share Posted February 1, 2009 THIS MAY BE AN AJAX ISSUE i believe you are correct; ajax is what you need to do this. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.