Jump to content

pagination javascript mixed with php


contra10

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.