[php/mysql] stronicowanie wynikow Opcje

[kebq]

witam serdecznie!
mam sobie prosty kod, ktory i tak stworzyl mi kila problemow:

[PHP] pobierz, plaintext 
<?php
$litera = array("a","b","c","ć","d","e","f","g","h","i","j","k","l","ł","m","n","o","ó","p","r","s","ś","t","u","v","w","x","y","z");
for ($i=0; $i<=28; $i++)
{
echo "<a href=sennik.php?t=ih&l=".$litera[$i].">$litera[$i]</a>";
if($i=="28")
{ 
 echo"<br><br>";
}
else
{ 
 echo " :: ";
}
}
//ih - index haseł
//ph - pokaż hasło
 
$zapytanie=mysql_connect(localhost, baza_danych, user);
$select_db = mysql_select_db("nazwa_bazy");
if($t == "ih")
{
$query = mysql_query("SELECT id, tytul FROM sennik WHERE tytul LIKE '$l%' ORDER BY tytul ASC"); 
if(mysql_num_rows($query)==0)
{
echo('Brak haseł na zadanš literę.');
exit;
}
while($row = mysql_fetch_array($query))
{
$id = $row['id'];
$tytul=$row['tytul'];
echo "<a href=sennik.php?t=ph&id=".$id.">$tytul</a> <br>" ;
}
}
if($t == "ph")
{
$query = mysql_query("SELECT tytul,znaczenie FROM sennik WHERE id='$id'"); 
while($row = mysql_fetch_array($query))
{
$znaczenie = $row['znaczenie'];
$tytul=$row['tytul'];
echo "<b>$tytul</b><br><br>$znaczenie" ;
}
}
 
?>
[PHP] pobierz, plaintext 

czy jakas dobra dusza moglaby pomoc mi z wykonaniem stronicowania newsow?
nie potrzebuje zaawansowanych rozwiazan, wielkich klas etc. tylko prostego numerowania stron
bede wdzieczny za wszelka pomoc i niezlinczowanie mojej osoby

[webfreak]

[PHP] pobierz, plaintext 
 
 
	$adjacents = 3;
 
 
	$query = "SELECT COUNT(*) as num FROM $tbl_name";
	$total_pages = mysql_fetch_array(mysql_query($query));
	$total_pages = $total_pages[num];
 
 
	$targetpage = "index.php"; 	//nazwa pliku w ktorym znajduje sie ten kod
	$limit = 10; 								//ile rezultatow pokazac na strone
	$page = $_GET['page'];
	if($page) 
		$start = ($page - 1) * $limit; 			//pokazuje rezultaty z 1 strony
	else
		$start = 0;								
 
 
	$sql = "SELECT * FROM $tbl_name LIMIT $start, $limit";
	$result = mysql_query($sql);
 
 
	if ($page == 0) $page = 1;					
	$prev = $page - 1;							
	$next = $page + 1;							
	$lastpage = ceil($total_pages/$limit);		
	$lpm1 = $lastpage - 1;						
 
 
	$pagination = "";
	if($lastpage > 1)
	{	
		$pagination .= "<div class=\"pagination\">";
 
		if ($page > 1) 
			$pagination.= "<a href=\"$targetpage?page=$prev\">Ť previous</a>";
		else
			$pagination.= "<span class=\"disabled\">Ť previous </span>";	
 
 
		if ($lastpage < 7 + ($adjacents * 2))	
		{	
			for ($counter = 1; $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
			}
		}
		elseif($lastpage > 5 + ($adjacents * 2))	
		{
 
			if($page < 1 + ($adjacents * 2))		
			{
				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
			}
 
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
			}
 
			else
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"active\">$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
				}
			}
		}
 
		//Przycisk NEXT
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage?page=$next\">next ť</a>";
		else
			$pagination.= "<span class=\"disabled\">next ť</span>";
		$pagination.= "</div>\n";		
	}
 
 
 
[PHP] pobierz, plaintext 

potem w html dodajesz

[HTML] pobierz, plaintext 
<?=$pagination?>
 
[HTML] pobierz, plaintext 

Ten post edytował webfreak 26.11.2011, 13:00:57