<?php

include ("ust.php");
include ("db_baglanti.php");

// DB ile baglanti olussun.

db_baglanti();

// uyeleri veriden çagiralim
$ac=mysql_query("select*from uyeler");
$toplam=mysql_num_rows($ac);

echo'<table border="1" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td width="2%" bgcolor="#00FFFF"><b>id</b></td>
    <td width="18%" bgcolor="#00FFFF"><b>Ad soyad</b></td>
    <td width="16%" bgcolor="#00FFFF"><b>Nick</b></td>
    <td width="21%" bgcolor="#00FFFF"><b>eposta</b></td>
    <td width="18%" bgcolor="#00FFFF"><b>kayit tarihi</b></td>
  </tr>';


// Sayfalama basladi

$limit=10;
$sayfa = !empty($_GET["sayfa"]) ? intval($_GET["sayfa"]) : 1;
$s = ($sayfa-1)*$limit;



$sorgu2 = mysql_query("SELECT id,ad_soyad,kullanici_ismi,eposta,kayit_tarihi FROM uyeler ORDER BY id DESC LIMIT $s,$limit");
$toplam2 = mysql_num_rows($sorgu2);
$a = ceil($toplam/$limit)+1;


for($i=1;$i<$a;$i++) {
if($sayfa==$i) { echo "<font color=\"#FF0000\"><font face=\"Tahoma\" size=\"2\">[<b>$i</b>]</font></font>"; } else {
echo "<font face=\"Tahoma\" size=\"2\">[<a href='?sayfa=$i'>$i</a>]</font>";
}
}

$ileri = $sayfa+1;
$b = ceil($toplam/$limit);

echo "<br>";

// Sayfalama bitti




// Uye listesi

while($yaz=mysql_fetch_array($sorgu2)):

$id = $yaz['id'];
$ad_soyad = $yaz['ad_soyad'];
$kullanici_ismi = $yaz['kullanici_ismi'];
$eposta = $yaz['eposta'];
$kayit_tarihi = $yaz['kayit_tarihi'];

echo '

  <tr>
    <td width="2%">'.id.'</td>
    <td width="18%">'.$ad_soyad.'</td>
    <td width="16%">'.$kullanici_ismi.'</td>
    <td width="21%">'.$eposta.'</td>
    <td width="18%">'.$kayit_tarihi.'</td>
  </tr>


';
endwhile;

echo'
</table>';

include ("alt.php");
?>

$ac=mysql_query("select * from uyeler ORDER BY id DESC $s,$limit");