• 14-12-2010, 21:19:49
    #1
    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
    #2
    <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