Pagination

Kaip padaryti kad butu ne "Prev 1 2 3 4 5 6 7 8 9 10 11 12 Next", o "Prev 1 2 3 4 5 6 ... 12 Next" :)

$per_page = 1;
$start = $_GET['start'];
$record_count = mysql_num_rows(mysql_query("SELECT * FROM CHARACTER_SETS"));
$max_pages = $record_count / $per_page;
if(!$start)
$start = 0;
$get = mysql_query("SELECT * FROM CHARACTER_SETS LIMIT $start, $per_page");
while($row = mysql_fetch_assoc($get))
{
$xx = $row['CHARACTER_SET_NAME'];
$yy = $row['DEFAULT_COLLATE_NAME'];
echo $xx." "."<font color='red'>[$yy]</font>"."<br>";
}

$prev = $start - $per_page;
$next = $start + $per_page;

//show prev button
if(!($start<=0))
echo "<a href='index.php?start=$prev'>Prev</a>";

echo " << ";

//show page numbers
$i = 1;
for($x=0;$x<$record_count;$x=$x+$per_page)
{
if($start!=$x)	
echo "<a href='index.php?start=$x'> $i </a>";
else
echo "<a href='index.php?start=$x'><font color='red'> $i </font></a>";
$i++;
}

echo " >> ";

//show next button
if(!($start>=$record_count-$per_page))
echo "<a href='index.php?start=$next'>Next</a>";

negi nieks negaletu padet :)

istrauki skripta is kazkur ir tikiesi, kad imsim ir tyrinesim ji? internete pilna literaturos apie tai

$per_page = 1;
$start = $_GET['start'];
$record_count = mysql_num_rows(mysql_query("SELECT * FROM CHARACTER_SETS"));
$max_pages = $record_count / $per_page;
if(!$start)
$start = 0;
$get = mysql_query("SELECT * FROM CHARACTER_SETS LIMIT $start, $per_page");
while($row = mysql_fetch_assoc($get))
{
$xx = $row['CHARACTER_SET_NAME'];
$yy = $row['DEFAULT_COLLATE_NAME'];
echo $xx." "."<font color='red'>[$yy]</font>"."<br>";
}

$prev = $start - $per_page;
$next = $start + $per_page;

//show prev button
if(!($start<=0))
echo "<a href='index.php?start=$prev'>Prev</a>";

echo " << ";

//show page numbers
$i = 1;
for($x=0;$x<$record_count;$x=$x+$per_page)
{
if($start==$x)
{
echo "<a href='test.php?start=$x'><font color='red'> $i </font></a>";
}
else
{
if(($start - $x)  < 4 && ($x - $start)  < 4 )
{
	echo "<a href='test.php?start=$x'> $i </a>";
}
else if($x == 0)
{
	echo "<a href='test.php?start=$x'> $i </a>...";
}
else if($x == $record_count-1)
{
	echo "...<a href='test.php?start=$x'> $i </a>";
}
}
$i++;
}

echo " >> ";

istrauki skripta is kazkur ir tikiesi, kad imsim ir tyrinesim ji? internete pilna literaturos apie tai

as taves ir neprasau imt ir tyrinet nenori pagelbet tai ir nereike :) beja laibai aciu dzonatan, kad daugiau tokiu zmoniu forume butu :)

Kai prieisi iki frameworku, tai jie iskarto pasiulys pagingo classes, nereikes vargt