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 Link to comment https://forums.phpfreaks.com/topic/143233-pagination-javascript-mixed-with-php/ 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. Link to comment https://forums.phpfreaks.com/topic/143233-pagination-javascript-mixed-with-php/#findComment-751708 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.