Wednesday, April 7, 2010

Converting PHP pagination to jQuery?

Programmer Question

Hey, I have been trying to get this pagination class that I am using to be more ajaxy - meaning when I click on the page number like page [2] the data loads, but I want to load in the data without going to a different page (HTTP request in the background, with no page reloads).



Being new to both php and jquery, I am a little unsure on how to achieve this result, especially while using a php class.



This is what the main page looks like by the way:



<?php
$categoryId=$_GET['category'];
echo $categoryId;
?>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js"></script>
<script type="text/javascript" src="jquery_page.js"></script>

<?php
//Include the PS_Pagination class
include('ps_pagination.php');
//Connect to mysql db
$conn = mysql_connect('localhost', 'root', 'root');
mysql_select_db('ajax_demo',$conn);
$sql = "select * from explore where category='$categoryId'";
//Create a PS_Pagination object
$pager = new PS_Pagination($conn, $sql, 3, 11, 'param1=value1&param2=value2');
//The paginate() function returns a mysql
//result set for the current page
$rs = $pager->paginate();
//Loop through the result set

echo "<table width='800px'>";

while($row = mysql_fetch_assoc($rs)) {

echo "<tr>";
echo"<td>";
echo $row['id'];
echo"</td>";

echo"<td>";
echo $row['site_description'];
echo"</td>";

echo"<td>";
echo $row['site_price'];
echo"</td>";
echo "</tr>";

}
echo "</table>";

echo "<ul id='pagination'>";

echo "<li>";
//Display the navigation
echo $pager->renderFullNav();
echo "</li>";

echo "</ul>";

?>

<div id="loading" ></div>
<div id="content" ></div>


Would I need to do something with this part of the class?, as seen above:



$pager = new PS_Pagination($conn, $sql, 3, 11, 'param1=value1&param2=value2');


Or this?:



echo $pager->renderFullNav();


I don't no much about jquery,but i guess I would start it like:



$("#pagination li").click(function() {


Then load something maybe...



I don't no. Any help on this would be great. Thanks.



Find the answer here

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails