DaniWeb Forum Index > Web Development > PHP

display fix set of data in table....

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 6

Reputation: manish_gajjar is an unknown quantity at this point

Solved Threads: 0

manish_gajjar manish_gajjar is offline

Offline

Newbie Poster

display fix set of data in table....

Jan 3rd, 2008

Hi guys...Good morning...I have following code.
<?php
$pid=$_GET['pid'];
$conn=mysql_connect('localhost','root','') or die("Cannot connect to server");
mysql_select_db('developer',$conn) or die("Cannot connect to database");
$sql="select cnode,item,pnode from listviews where cnode='$pid'";
$res=mysql_query($sql) or die("Cannot execute query");
while($ar=mysql_fetch_array($res))
{
$itm=$ar[1];
$pid=$ar[0];
}
$sql="select cnode,item,pnode from listviews where pnode='$pid'";
$res=mysql_query($sql) or die("Cannot execute query");
echo "<table border='1'>";
if($pid==0)
echo "<th colspan=2>Parent Items</th>";
else
echo "<th colspan=2>$itm</th>";
while($ar=mysql_fetch_array($res))
{
echo "<tr><td>$ar[0]</td><td>$ar[1]</td>";
}
echo "</table>";
?>

Now i want to display only five rows per page...and using next button i want to see next five records...How it is possible to display it using PHP...This page is called by ajax script...Please show me the way...Thank you...

•

Join Date: Aug 2007

Posts: 569

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: display fix set of data in table....

Jan 3rd, 2008

http://www.php-mysql-tutorial.com/php-mysql-paging.php

http://www.ryantetek.com/

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: display fix set of data in table....

Jan 3rd, 2008

Simplest 'next-forward' script, just to get the idea on how it works. You will find much more efficient code on the net.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$offset=isset($_REQUEST['offset'])?$_REQUEST['offset']:0;
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
$total=mysql_num_rows(mysql_query("select * from test"));
$query="select * from test limit $offset,5";
$result=mysql_query($query);
while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
	print_r($row);
}	
if($offset==0){
	$next_offset=$offset+1;
	$prev_offset=0;
} elseif($offset == $total) {
	$next_offset=$total;
	$prev_offset=$offset-1;
} else {
	$next_offset=$offset+1;
	if($next_offset==$total){
		$next_offset=$total;
	}
	$prev_offset=$offset-1;
}
echo "<a href=test.php?offset=$prev_offset>Prev</a>";
echo "<a href=test.php?offset=$next_offset>Next</a>";
?>
<?php
$offset=isset($_REQUEST['offset'])?$_REQUEST['offset']:0;
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
$total=mysql_num_rows(mysql_query("select * from test"));
$query="select * from test limit $offset,5";
$result=mysql_query($query);
while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
	print_r($row);
}	
if($offset==0){
	$next_offset=$offset+1;
	$prev_offset=0;
} elseif($offset == $total) {
	$next_offset=$total;
	$prev_offset=$offset-1;
} else {
	$next_offset=$offset+1;
	if($next_offset==$total){
		$next_offset=$total;
	}
	$prev_offset=$offset-1;
}
echo "<a href=test.php?offset=$prev_offset>Prev</a>";
echo "<a href=test.php?offset=$next_offset>Next</a>";
?>