Sayfalama - R10.net

14-12-2010, 21:19:49

Kimlik doğrulama veya yönetimden onay bekliyor.

Merhaba Arkadaşlar, sql' den çekilen dataları istediğim gibi sayfalıyorum ama link

http://localhost/detay.php?id=4

şeklinde olunca sayfalama yapamadım, örnekleri inceledim ama bir yerlerde hep hata aldım.
Linkin dökümü aşağıdaki gibidir.

<table width="800" border="1" align="center">
  <tr>
    <td>İçerik-1</td>
    <td>İçerik-2</td>
    <td>İçerik-3</td>

  </tr>
     	<?
$sql=mysql_query("select  * from TABLO order by id desc");
while ($sor=mysql_fetch_array($sql))
 {
?>
  <tr>
    <td><?=$sor[icerik1];?></td>
    <td><?=$sor[icerik2];?></td>
    <td><?=$sor[icerik3];?></td>

    <?}?>
  </tr>
</table>

Yardımcı olursanız sevinirim. Teşekkürler.

14-12-2010, 21:36:26

Squit

<html>
<head>
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css">
html,
body {
background-color: transparent;
}
</style>
</head>
<?php
 include './inc/dbsettings.php';
	$db	= "player";
	mysql_connect($dbhost, $dbuser, $dbpw) OR
	die("HATA: DB bağlanamadı. ".mysql_error());		
	mysql_select_db($db) OR
	die("HATA: DB zaten bağlı. ".mysql_error());
$test = "SELECT * from player";
		$testquery = mysql_query($test);
			$num2 = mysql_num_rows($testquery);

		if($_GET['max']) {
			$get = $_GET['max'];
		} else {
		$get = '0';
		}
			
	$max = $get + 20;
	$max2 = $get - 20;
			
if($get > $num2) {
echo "<center><a href=\"squit.php?page=ranking&max=$max2\">&laquo; Ileri</a></center>"; }
elseif($get >= 20 && $get < $num2) { echo "<center><a href=\"squit.php?page=ranking&max=$max2\">&laquo; Geri</a> <a href=\"squit.php?page=ranking&max=$max\">Ileri &raquo;</a></center>"; }
elseif ($num2 <= 20) { echo ""; }
else { echo "<center><a href=\"squit.php?page=ranking&max=$max\">Ileri &raquo;</a></center>"; }
echo "</center><br></center>";
?>

<table width=400 style="font-size:11px; font-family:verdana; color:#000000;" cellspacing="0" cellpadding="0" align=center>
<tr>
<td width=100% height=34 colspan=3 align=center class="content" style="font-size:12px; font-family:verdana; color:#000000;"><b></b>
</td>
</tr>
<tr>

<td style="font-size:12px; border:1px #000000 solid;"><center><b>Sira</b></center></td>
<td style="font-size:12px; border:1px #000000 solid;"><center><b>Nick</b></center></td>
<td style="font-size:12px; border:1px #000000 solid;"><center><b>Level</b></center></td>
</tr>
	<tr>


<?php



	include('./inc/dbsettings.php'); // Connect to DB
		mysql_select_db('player'); // Select DB 'player'
		
	
		
// Select player etc from db //


	$rank = "SELECT * from player WHERE name NOT LIKE '[%]%' AND name NOT LIKE 'Squit' AND name NOT LIKE '[%]%' AND name NOT LIKE '[%]%' AND job NOT LIKE '0' AND job NOT LIKE '1' AND job NOT LIKE '2' AND job NOT LIKE '4' AND job NOT LIKE '5' AND job NOT LIKE '6' AND name NOT LIKE '[WD]%' AND name NOT LIKE '[TL]%' AND name NOT LIKE '[CM]%' AND name NOT LIKE '[CoMa]%' AND name NOT LIKE '[SA]%'  AND name NOT LIKE '[MoD]%'  AND name NOT LIKE '[EV]%'  AND name NOT LIKE '[TGM]%' order by level desc, exp desc, name asc limit $get,20";
		$query = mysql_query($rank);
	$i = 0 + $get;
	
			while($array = mysql_fetch_array($query)) {
				$i = $i + 1;
			
				echo "
				<tr>
				<td style=\"font-size:10px; font-family:verdana; color:#000000;\" class=content align=center>" . $i . "</td>
				<td style=\"font-size:10px; font-family:verdana; color:#000000;\" class=content align=center>",$array["name"],"</td>
				<td style=\"font-size:10px; font-family:verdana; color:#000000;\" class=content align=center>" . $array["level"] . "</td>
				</tr>";
				
				}
	echo "</tr>"; // close table

?>

</body>
</html>

hocam bu benim kendi sayfalama sistemim üstünde düzenleme yaparak yapabilirsin