<?php 

include('ayar.php');

// SAYFA BASI KELIME
$pagination = 100;

// TOPLAM KELIME ADEDI
$q = mysql_query("SELECT id FROM arama");
$num = mysql_num_rows($q);

// SAYFA SAYISI
$page = $num / $pagination;

    if (!is_integer($page)) {
    $page = intval($page) + 1;
    }


// SU ANKI SAYFA

    if ($_GET[page] == "") {
    $_GET[page] = 1;
    }

// BASLANGIC
$limit = ($_GET[page] - 1) * $pagination;


$sorgu = mysql_query("SELECT * FROM arama ORDER BY id DESC LIMIT $limit,$pagination");

echo '<p align="center"><table width="100%">';
$i=1;

    while ($oku = mysql_fetch_array($sorgu)) {

    $k = $i % 2;
    
        if ($k == "0") {
        echo '<td width="50%">'.$oku[id].' <a name="'.$oku[kelime].'" href="search.php?en='.$oku[kelime].'">'.$oku[kelime].'</a></td></tr>';
        }

        if ($k == "1") {
        echo '<tr><td width="50%">'.$oku[id].' <a name="'.$oku[kelime].'" href="search.php?en='.$oku[kelime].'">'.$oku[kelime].'</a></td>';
        }    
    $i++;
    }

echo '</table></p>';

echo "Toplam $num kayit $page sayfada listeleniyor";

    for ($i=1; $i<=$page; $i++) {
    echo '<a href="sayfalama.php?page='.$i.'">'.$i.'</a> &nbsp; ';
    }



echo '<br><br>';

?>