<?php
include("./baglan.php");

$sql = mysql_query("SELECT * FROM taksi");
while($config = mysql_fetch_array($sql)){
    $groups[$config['grup']] = '';
}
echo '<center><form><select size="1" name="mekanturu" onchange="formHandlermekanturu(this.form)"><option value="0">Lütfen bir semt seçin</option>';
foreach($groups as $key => $value){
    echo '<option value="oku.php?semt='.$key.'">'.$key.'</option>';
}

echo '</select></form><br /></center>';

$sayfa=intval($_REQUEST['sayfa']);

if(empty($sayfa)) { 
$sayfa ="1"; 
} 

$limit=6;
$sonsayfa = ($sayfa-1)*$limit; 
$semt=$_GET['semt'];


if(empty($_GET['semt'])) {
    $sorgu=mysql_query("SELECT * FROM taksi LIMIT $sonsayfa,$limit");
} else { 
    $sorgu=mysql_query("SELECT * FROM taksi WHERE grup like '".$_GET['semt']."' LIMIT $sonsayfa,$limit ");
}

$kacadet=mysql_num_rows($sorgu);
$kacsayfa = $kacadet / $limit;
$kacsayfa = ceil($kacsayfa);

while($al=mysql_fetch_array($sorgu)) { 
$ad=$al['isim'];
$tel=$al['telefon'];
$adres=$al['adres'];
$grup=$al['grup'];

?>

<table width="288" height="160" border="1" align="center" bordercolor="#000000">
  <tr>
    <td width="56" height="24"><strong>isim</strong></td>
    <td width="217"><? echo "$ad"; ?></td>
  </tr>
  <tr>
    <td height="27"><strong>telefon</strong></td>
    <td><? echo "$tel"; ?></td>
  </tr>
  <tr>
    <td><strong>adres</strong></td>
    <td><? echo "$adres"; ?></td>
  </tr>
  <tr>
    <td height="23"><strong>grup</strong></td>
    <td><? echo "$grup"; ?></td>
  </tr>
</table>
<br />

<? } 
?>
<center>
<?php

echo " $kacsayfa ";  // sorun cikti.  degisken deger aliyor mu bakalim. ~ doomsday

?>
<br />
<?php 

if(empty($semt)) {
while($a < 10){
echo '<a href=oku.php?sayfa='.$a.'>'.($a).'</a> | ';
$a++;
} 
} else { 
while($a < 10){
echo '<a href=oku.php?semt='.$semt.'&sayfa='.$a.'>'.($a).'</a> | ';
$a++;
}  
}
?>
<hr />

</center>


<script language="JavaScript">
function formHandlermekanturu(form){
    var URL= form.mekanturu.options[form.mekanturu.selectedIndex].value;
    if(form.mekanturu.selectedIndex != 0)
    window.location.href = URL;
}
</script>