sayfalama sorunum var.sayfalama için kgPager classını kullanıyorum.normal sabit sayfalarda sorun yok lakin kategorilerimi sıralamak istediğimden ikinci sayfaya geçince sorun oluyor.
yani $get['erkan']; bu kategori idsi diyelim.bunu sıralamada nasıl diğer sayfalara aktarırım.sorunun özü bu oluyor.kodu aşağıda veriyorum sıralama classı ekte veriyorum.
şimdiden teşekkürler : )
<?PHP
header('Content-Type: text/html; charset=utf-8');
require_once('kgPager.class.php');
include("ust.php");
?>
<div id="templatemo_content">
<div id="templatemo_leftcolumn">
<div class="post">
<?PHP
@$kid= $_GET['erk'];
$query = "SELECT * FROM yaz"; // sql
$sql = mysql_query($query);
$total_records = mysql_num_rows($sql);
$scroll_page = 3;
$per_page = 2;
$current_page = @$_GET['page'];
$pager_url = 'kategori.php?page=';
$inactive_page_tag = 'id="current_page"';
$previous_page_text = '< Önceki Sayfa';
$next_page_text = 'Sonraki Sayfa >';
$first_page_text = '<< İlk Sayfa';
$last_page_text = 'Son Sayfa >>';
$pager_url_last = '';
$kgPagerOBJ = & new kgPager();
$kgPagerOBJ -> pager_set($pager_url, $total_records, $scroll_page, $per_page, $current_page, $inactive_page_tag, $previous_page_text, $next_page_text, $first_page_text, $last_page_text, $pager_url_last);
echo '</p>';
$sql = mysql_query($query." where kategoriid='$kid' LIMIT ".$kgPagerOBJ -> start.", ".$kgPagerOBJ -> per_page);
while ($read = mysql_fetch_assoc($sql)) {
$yaz1=substr($read['icerik'], 0,300);
@$kaid=$read['kategoriid'];
@$tar=$read['tarih'];
list($yıl,$ay,$gun) = explode('-',$tar);
$kate=mysql_query("SELECT * FROM kategori where kid=$kaid");
while($katet=mysql_fetch_array($kate)){
$kat1=$katet[@'kat'];
}
echo'<div class="postdate"> '.$gun.' <div class="month">'.$ay.'</div></div>
<div class="postbody">';
echo' <h2><a href='.$siteadi.'/'.$read['id'].'/'.Duzenle($read['baslik']).'.html>'.$read['baslik'].'</a></h2>';
echo' <div class="tagline">posted by admin - <span><a href='.$siteadi.'/'.$read['kategoriid'].'-'.Duzenle($kat1).'.html>'.$kat1.'</a></span></div>
<img src='.$read['resim'].' height=90 width=90 alt="'.$read['baslik'].'" />
<div class="posttext">
<p>'.$yaz1.'...
</p>
<div class="comment_more"><span>comments (6) </span>- <a href='.$siteadi.'/'.$read['id'].'/'.Duzenle($read['baslik']).'.html>
devam...</a></div>
</div> </div>
<p> </p> ';
}
echo ' </div> <p id="pager_links">';
echo @$kgPagerOBJ -> first_page;
echo @$kgPagerOBJ -> previous_page;
echo @$kgPagerOBJ -> page_links;
echo @$kgPagerOBJ -> next_page;
echo @$kgPagerOBJ -> last_page;
echo '</p>';
?>
</div> <!-- end of left column -->
<div id="templatemo_rightcolumn">
<div class="rc_panel">
<div class="rc_paneltop"></div>
<div class="rc_panelbody">
<form method="post" action="#">
<input class="textfield" name="search" type="text" value="Search..." id="keyword"/> <input class="button" type="submit" name="Submit" value="Go" />
</form>
</div>
<div class="rc_panelbottom"></div>
</div>
<div class="rc_panel">
<div class="rc_paneltop"></div>
<div class="rc_panelbody">
<h3>Categories</h3>
<ul>
<?php
$sorgu=mysql_query("SELECT * FROM kategori ORDER BY kid DESC");
while ($kayit=mysql_fetch_array($sorgu )) {
echo'<a href='.$siteadi.'/'.$kayit['kid'].'-'.Duzenle($kayit['kat']).'.html>';
echo '<li><strong>'.$kayit["kat"].'</strong></li>';
}
?>
</ul>
</div>
<div class="rc_panelbottom"></div>
</div>
<div class="rc_panel">
<div class="rc_paneltop"></div>
<div class="rc_panelbody">
<h3>Archives</h3>
<ul>
<li><a href="#">January, 2020</a></li>
<li><a href="#">Fabruary, 2020</a></li>
<li><a href="#">March, 2020</a></li>
<li><a href="#">April, 2020</a></li>
<li><a href="#">May, 2020</a></li>
</ul>
</div>
<div class="rc_panelbottom"></div>
</div>
<a href="http://validator.w3.org/check?uri=referer"><img style="border:0;width:88px;height:31px" src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0 Transitional" width="88" height="31" vspace="8" border="0" /></a>
<a href="http://jigsaw.w3.org/css-validator/check/referer"><img style="border:0;width:88px;height:31px" src="http://jigsaw.w3.org/css-validator/images/vcss-blue" alt="Valid CSS!" vspace="8" border="0" /></a>
</div> <!-- end of right column -->
</div> <!-- end of content -->
<div id="temmplatemo_bottompanel">
<div class="bp_column1">
<h3>Popular Post</h3>
<div class="popularpost">
<h4><a href="#">Lorem ipsum dolor sit amet</a></h4>
Author name - Oct 18, 2020 <span class="comment">(12)</span></div>
<div class="popularpost">
<h4><a href="#">Duis vitae velit sed dui malesuada</a></h4>
Author name - Oct 12, 2020 <span class="comment">(23)</span></div>
<div class="popularpost">
<h4><a href="#">Donec mollis aliquet ligula</a></h4>
Author name - Oct 11, 2020 <span class="comment">(32)</span></div>
<div class="popularpost">
<h4><a href="#">Quisque rhoncus nulla quis sem</a></h4>
Author name - Oct 15, 2020 <span class="comment">(25)</span></div>
</div>
<div class="bp_column2">
<h3>Photo Gallery</h3>
<a href="#"><img src="images/photo04.gif" alt="image" /></a>
<a href="#"><img src="images/photo02.gif" alt="image" /></a>
<a href="#"><img src="images/photo03.gif" alt="image" /></a>
<a href="#"><img src="images/photo01.gif" alt="image" /></a>
<div class="readmore_black"><a href="#">View All</a></div>
</div>
<div class="bg_recentproject">
<h3>Recent Project</h3>
<img src="images/recentproject.jpg" alt="iamge" />
<p>Duis vitae velit sed dui malesuada dignissim. Donec mollis
aliquet ligula. Maecenas adipiscing elementum ipsum.</p>
<div class="readmore_black"><a href="#">Read more</a></div>
</div>
</div> <!-- end of bottom panel -->
<div id="templatemo_footer">
<a href="#">Home</a> | <a href="#">About Us</a> |
<a href="#">Portfolio</a> | <a href="#">Services</a> |
<a href="#">Contact Us</a><br />
Copyright © 2008 <a href="#">Your Company Name</a> | Designed by <a href="http://www.templatemo.com" target="_blank">
TemplateMo.com</a>
</div>
</div>
</div>
</body>
</html>