[Resolved] limit results

[rutin]

hi there,

since very long time i am trying to solve my problem with pagination. as you may noticed i have posted many questions on forum. regarding my problem

i still havent solved my problem. so here i am again asking for help from you guys.

i am trying to paginate my portofolio page. as i have many diferent categories of my portofolio, ( like webdesign, flash design, graphic design, logo design, etc )

i have build out admin for my portofolio, its all working just fine.

Pagination is my big problem, i have tried so many classes, code snipets, nothing helped me.

i have two tables. " portofolio" and "category".

I am accessing results from portofolio based on category from category table using is set method.

if (isset($_GET['kat']) && isset($_GET['kat'])) { 

if i type index.php?kat=1, that will display results from category 1

which looks like this :

$queryp=mysql_query("Select * from portofolio   where category='$_GET[kat]'");
echo "<table width=100%  border=0>\n";
echo "<tr><td >Project thumb</td><td ><div>Project  Name</div></td><td ><div>Client name</div></td><td ><div>Url</div></td></tr>";


if (mysql_num_rows($queryp) == 0)

echo "This category has no data in it, either empty or deleted by admin"; 

  elseif (mysql_num_rows($queryp) == 1){
}

while ($rowp=mysql_fetch_array($queryp)){

echo "<tr><td align='center'> <a href='index.php?client=$rowp[id]'><img src='porto/images/$rowp[photo]' border=0 align=\"left\"></a></td>";
echo "<td>$rowp[name]</td><td>$rowp[client]</td><td><a href='$rowp[url]' target=\"_blank\">Visit the site</a></td></tr>\n";

}
echo "</table><br>\n";

that is working just fine.

my problem starts here, how can i paginate this so my url looks

like this "index.php?kat=1&next, or different. it really doesnt matter as long as it works.

At the end iam very sorry for reposting my question.
I thank you all in advance for all your help, and sorry for broken english.

my comeplete code looks like this :

<!--  "porto"   -->
<?php

if (isset($_GET['kat']) && isset($_GET['kat'])) { 

 echo '<table border="0" cellpadding="0" cellspacing="0" width="100%">

  <tr>
   <td width="0"><img name="box_upleft" src="prazan/box_upleft.gif" width="10" height="30" border="0" alt="portofolio"></td>
   <td width="94%" align="center" valign="middle" background="prazan/box_r1_c2.gif"><div align="left"></div></td>
   <td width="0"><img name="box_upright" src="prazan/box_upright.gif" width="6" height="30" border="0" alt="portofolio"></td>
  </tr>
  <tr>
   <td background="prazan/box_left.gif">&nbsp;</td>
   <td width="100%" bgcolor="#6A5B5B"> <p>';






$queryp=mysql_query("Select * from portofolio   where category='$_GET[kat]'");
echo "<table width=100%  border=0>\n";
echo "<tr><td >Project thumb</td><td ><div>Project  Name</div></td><td ><div>Client name</div></td><td ><div>Url</div></td></tr>";


if (mysql_num_rows($queryp) == 0)

echo "This category has no data in it, either empty or deleted by admin"; 

  elseif (mysql_num_rows($queryp) == 1){
}

while ($rowp=mysql_fetch_array($queryp)){

echo "<tr><td align='center'> <a href='index.php?client=$rowp[id]'><img src='porto/images/$rowp[photo]' border=0 align=\"left\"></a></td>";
echo "<td>$rowp[name]</td><td>$rowp[client]</td><td><a href='$rowp[url]' target=\"_blank\">Visit the site</a></td></tr>\n";

}
echo "</table><br>\n";



    echo '  



   </p>    </td>
   <td background="prazan/box_right.gif"><img name="box_right" src="prazan/box_right.gif" width="6" height="48" border="0" alt="portofolio"></td>
  </tr>
  <tr>
   <td><img name="box_downleft" src="prazan/box_downleft.gif" width="10" height="5" border="0" alt="portofolio"></td>
   <td background="prazan/box_down.gif"><img name="box_down" src="prazan/box_down.gif" width="79" height="5" border="0" alt="portofolio"></td>
   <td><img name="box_downright" src="prazan/box_downright.gif" width="6" height="5" border="0" alt="portofolio"></td>
  </tr>
</table>';

}
<!--  "is set ends here"   -->
<!--  "porto ends here"   -->

p.s.

please dont send me for some tutorials cause i been on many of them.

[paulnaj]

Hi rutin,

Haven't seen your earlier posts and am not going to try and 'fix' your code.

Here's a cut down version of what you want ...

<?php 
// Define a page size somehow
define('PAGE_SIZE', 10);

// I haven't bothered to read all your code
// so here I'm using a dummy sql string
$sql = 'SELECT * FROM `mytable`';

// Check to see if 'page' is in range
$result = mysql_query($sql);
$total_num_pages = ceil(mysql_num_rows($result)/PAGE_SIZE);
if(!isset($_GET['page']){
	$_GET['page'] = 0;
} else if($_GET['page'] > $total_num_pages){
	$_GET['page'] = $total_num_pages;
} else if($_GET['page'] < 0){
	$_GET['page'] = 0;
}
// First build the page menu
?>
<table>
	<tr>
		<td><a href="<?php echo $_SERVER['PHP_SELF']; ?>?page=0">First</a></td>
		<td><a href="<?php echo $_SERVER['PHP_SELF']; ?>?page=<?php echo $_GET['page'] - 1; ?>">Previous</a></td>
		<td><a href="<?php echo $_SERVER['PHP_SELF']; ?>?page=<?php echo $_GET['page'] + 1; ?>">Next</a></td>
		<td><a href="<?php echo $_SERVER['PHP_SELF']; ?>?page=<?php echo $total_num_pages; ?>">Next</a></td>
	</tr>
</table>
<hr>
<table>
<?php
// Now get your paged result
$sql .= ' LIMIT '.$_GET['page'].', '.PAGE_SIZE;
$result = mysql_query($sql);
?>
<table>
<?php
while($row = mysql_fetch_row($sql)){
	echo '<tr><td>'.join('</td><td>', $row).'</td></tr>';
}
?> 
</table>

... but you are going to have to get a grip on the principle before applying it. Otherwise you won't be able to understand things if it goes wrong.

Hope it helps!

Paul 🙂

EDIT: Just noticed a couple of typo's in the ....

if(!isset($_GET['page']){
...
}

... block and elsewhere. Ooops.

[rutin]

thank you for your reply. i wasnt able to input this. i got parse error right where is that typo's.

if(!isset($_GET['page']){ 
... 
} 

let make it clear, will this work for be what you giving to me.

index.php?kat=1

display resuls from portofolio table, based on category.

under , next prev or numbered.

so when click on the link it shows next results based on limitation.

thank you once more. HELP ME.

[bradgrafelman]

if(!isset($_GET['page']){  

is missing a ')'.

if(!isset($_GET['page'])){  

should work.

[paulnaj]

Hi rutin,

Yeah ... sorry about my bag of typo's :queasy: (Hey brad ... I found a few more!)

I didn't take time to debug it and it just didn't work properly(actually I started to just explain in words but found as usual that it's easier to just write the code and comment).

Also, I understood why you're still not sure how the categories fit in ... try this ... I've debugged it this time ...

 <html> 
<head> 
<title></title> 
</head> 
 <?php   

// Define a page size somehow 
define('PAGE_SIZE', 10);  

// Check for valid category 
if(!isset($_GET['kat'])){  

    $_GET['kat'] = 1;  

}  

//////////////////////////////////////////////////////////////// 
// CONNECT TO YOUR DATABASE 
// Got to put in the right values and un-comment 
//mysql_connect('host', 'user', 'pass'); 
//mysql_select_db('dbname'); 
$sql = "SELECT * FROM portofolio WHERE category='".$_GET['kat']."'"; 
$result = mysql_query($sql);  

$total_num_portfolios = mysql_num_rows($result);  

$total_num_pages = ceil($total_num_portfolios/PAGE_SIZE);  

// Check to see if 'page' is in range 
if(!isset($_GET['page'])){  

    $_GET['page'] = 1;  

} else if($_GET['page'] > $total_num_pages){  

    $_GET['page'] = $total_num_pages;  

} else if($_GET['page'] < 1){  

    $_GET['page'] = 1;  

}  

//////////////////////////////////////////////////////////////// 
// First build the page menu 
// Make a function ... 
function menu_item($text, $page){ 
    return '<a href="'.$_SERVER['PHP_SELF'].'?kat='.$_GET['kat'].'&page='.$page.'">'.$text.'</a>'; 
} 
?>  

<table border="1" cellpadding="2" cellspacing="0"> 
    <tr> 
        <td># portfolios:</td> <td><?php echo $total_num_portfolios; ?></td> 
        <td># pages:</td> <td><?php echo $total_num_pages; ?></td> 
    </tr> 
</table> 
<hr> 
<table border="1" cellpadding="2" cellspacing="0"> 
    <tr> 
        <td><?php echo menu_item('First', 1); ?></td> 
        <td><?php echo menu_item('Previous', $_GET['page'] - 1); ?></td> 
        <td><?php echo menu_item('Next', $_GET['page'] + 1); ?></td> 
        <td><?php echo menu_item('Last', $total_num_pages); ?></td> 
    </tr> 
</table> 
<hr> 
<table> 
<?php  

//////////////////////////////////////////////////////////////// 
// Now get your paged result 
$offset = ($_GET['page'] - 1)*PAGE_SIZE; 
$sql .= ' LIMIT '.$offset.', '.PAGE_SIZE;  

$result = mysql_query($sql);  

?>  

<table border="1" cellpadding="2" cellspacing="0"> 
<?php  

while($row = mysql_fetch_row($result)){  

    echo '<tr><td>'.join('</td><td>', $row).'</td></tr>';  

}  

?>   

</table> 
<body> 
</body> 
</html> 

See how you get on.

Paul 🙂

[rutin]

Thank you very much, my problem solved.
I am very happy.

Thanks a lot.

Rutin,