Arkadaşlar Admin Panelimde Şöyle Bir Sayfam Var
<?php session_start();
if (@$_SESSION[adminid]=="")
{
echo "<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"0;URL=login.php\">";
exit();
} require_once('../Connections/baglan.php'); ?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
$query_Recordset1 = "SELECT * FROM ilanlar left join resimler on (resimler.id = ilanlar.id) WHERE ilanlar.durum=0 or ilanlar.durum=7 and ilanlar.tipi=1 ORDER BY ilanlar.ziyaret DESC";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = $dba->query($query_limit_Recordset1) ;
$row_Recordset1 = $dba->fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
@$all_Recordset1 = $dba->query($query_Recordset1);
@$totalRows_Recordset1 = $dba->num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
background-image: url(header-bg (Custom) (Custom).jpg);
background-repeat: repeat;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #e0e0e0;
}
.style1 {
font-size: 14px;
color: red;
}
.style2 {color: #0000FF}
.style3 {
font-size: 14px;
font-weight: bold;
}
-->
</style></head>
<body>
<table width="90%" align="center" style="border:#0F5A84 solid 1px">
<tr>
<td><table width="100%" align="center" bordercolor="#FFFFFF">
<tr>
<td colspan="6" bgcolor="#FFFFFF" scope="col"><div align="center" class="style2">İlanların Ziyaret Edilme Sayıları (Sadece Aktif İlanlar Listelenir) </div></td>
</tr>
<tr>
<th width="9%" bgcolor="ECECEC" scope="col">İ*** </th>
<th width="30%" bgcolor="ECECEC" scope="col">İl / İlçe / Semt </th>
<th width="15%" bgcolor="ECECEC" scope="col">Tarihi</th>
<th width="18%" bgcolor="ECECEC" scope="col"> İlan Türü</th>
<th width="13%" bgcolor="ECECEC" scope="col">Metre</th>
<th width="15%" bgcolor="ECECEC" scope="col"> Fiyatı </th>
</tr>
</table></td>
</tr><tr>
<td><?php do { $baslik=permayap($row_Recordset1["baslik"]);$idsi=$row_Recordset1['id'];?>
<?php
if (isset($row_Recordset1['id'])){ ?>
<table width="100%" height="70" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" style="border:#0F5A84 solid 1px">
<tr align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<td width="28" rowspan="2"><div align="center">
<a href='<?php echo "/$baslik-ilan_detayi$idsi.html"?>' target='_blank' ><img src='<?php if ($row_Recordset1['resim'] =='noimage.gif'){echo "../noimage.gif";}else{echo "photo/$row_Recordset1[resim]";}?>' width='66' height='57' onmouseover="Tip('<img src=<?php if ($row_Recordset1['resim'] =='noimage.gif'){echo "noimage.gif";}else{echo "photo/$row_Recordset1[resim]";}?> width=250 height=200>',SHADOW, true, BGCOLOR, '#000000', FADEIN, 400, FADEOUT, 600, SHADOWCOLOR, '#000000', BORDERCOLOR, '#000000', OPACITY, 190,FONTCOLOR, '#FFFFFF')"></a>
<?php echo @$row_Recordset1['id']; ?> </div></td>
<td height="20" colspan="6" align="center"><div align="left"> <span class="style1">Ziyaret edilme sayısı</span> <span class="style2">(<?php echo @$row_Recordset1['ziyaret']; ?>)</span> / <?php echo @$row_Recordset1['baslik']; ?></div></td>
</tr>
<tr >
<td width="329" height="40" bgcolor="#FFFFFF"><div align="center"><span class="FontBlueBold">
<?php echo iller($row_Recordset1['il'],$row_Recordset1['ilce'],$row_Recordset1['semt']); ?>
</div></td>
<td width="149" height="40" bgcolor="#FFFFFF"><div align="center"><?php echo @$row_Recordset1[tarih]; ?></div></td>
<td width="185" bgcolor="#FFFFFF" ><div align="center">
<?php
if($row_Recordset1['durum']=='0') {
echo "Satılık"; } else { echo "Kiralık"; } ?>
/
<?php
if ($row_Recordset1['tipi']=='3') {
?>
<span class="style1">Arsa</span>
<?php } ?>
<?php
if ($row_Recordset1['tipi']=='2') {
?>
<span class="style1">İşyeri</span>
<?php } ?>
<?php
if ($row_Recordset1['tipi']=='1') {
?>
<span class="style1">Konut</span>
<?php } ?>
<?php echo @$row_Recordset1[konutturu]; ?></div></td>
<td width="126" bgcolor="#FFFFFF"><div align="center"><?php echo @$row_Recordset1[metre]; ?> m2</div></td>
<td width="156" bgcolor="#FFFFFF"><div align="center"><span class="style11"><?php echo @$row_Recordset1[fiyat]; ?> <?php echo @$row_Recordset1[fiyatbirim]; ?></span></div></td>
</tr>
</table>
<hr/>
<?php } // Show if recordset empty ?>
<?php } while ($row_Recordset1 = $dba->fetch_assoc($Recordset1)); ?>
<table width="100%" align="center">
<tr>
<td bgcolor="#FFFFFF" scope="col"><div align="center"><span class="style3">< |
<?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Önceki sayfa</a>
<?php } // Show if not first page ?>
Toplam -<?php echo $totalRows_Recordset1 ?> - kayıttan <?php echo ($startRow_Recordset1 + 1) ?> ile <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> arası gösteriliyor |
<?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Sonraki Sayfa</a>
<?php } // Show if not last page ?>
></span></div></td>
</tr>
</table></td>
</tr>
</table>
<script type="text/javascript" src="/tooltips.js"></script>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>ben bu sayfayı ana sayfama eklemek istiyorum yalnız ilk 10 tanesi gözüksün burada sayfa oluşturuyor ve diğer sayfalara atıyor ben sadece 10 tane gözükecek şekilde yapmak istiyorum limit 10 diyorum ama o zamanda gözükmüyor kısacası bilmiyorum yardımcı olabilirmisiniz ?