Tekil Mesaj gösterimi - Linkcenneti.com (internetdestek) + seo + resim

Konu Linkcenneti.com (internetdestek) + seo + resim
27-11-2007, 16:08:18
#39
Üyeliği durduruldu
Aşağıdaki dosya ile deneyiniz. Düzelttim.
<?
include "ayar.inc.php";

$komut = $_GET[komut];
$sifre = $_POST[sifre];

$id = $_GET[id];
$email = $_GET[email];
$url = $_GET[url];
$sahip = $_GET[sahip];
$kati = $_GET[kati];


session_start();
session_register ("admin");

$admin = $_SESSION[admin];
$kategori_adi = $_GET[kategori_adi];
function mail_yolla($url,$sahip,$email,$id,$tur)
{
$giden .= "$sahip <$email>";


/* Mesaj */
if($tur == "1")
{
$baslik = "siteadi.net kaydi tamamlandı";
$mesaj = "<html><body>
Sayın $sahip,<br>
 siteadi.net adresine $url 'si kayıt edilmiştir. Sitenizin sıralamalarda üstlerde yeralmasını istiyorsanız size ait kodu sitenize yerleştirmenizi öneririz.<br><br>
Saygılarımızla,<br>
<a href=http://www.siteadi.net target=_blank>siteadi.net</a> Yönetimi<br><br>
<hr>
<br>
Size özel kodunuzu almak için <a href=http://www.siteadi.net/toplist/kod.php?id=$id target=_blank>tıklayınız</a></body></html>
";
}
if($tur == "2")
{
$baslik = "siteadi.net kaydınız yapılmadı";
$mesaj = "<html><body>
Sayın $sahip,<br>
 siteadi.net adresine $url 'si ile yapmış olduğunuz başvuru sayfamızda belirtilmiş olan kriterlere uymadığı için kabul edilmemiştir. 
<br><br>
Saygılarımızla,<br>
<a href=http://www.siteadi.net target=_blank>siteadi.net</a> Yönetimi<br><br>
<hr>
<br></body></html>
";
}
/* ekstra header'lar (from, cc, bcc) */

$header = "From: siteadi.net <kayit@siteadi.net>\n";
$header .= "X-Sender: <servis@siteadi.net>\n";
$header .= "X-Mailer: siteadi.net, PHP\n";
$header .= "X-Priority: 1\n";
$header .= "Return-Path: <kayit@siteadi.net>\n";

$header .= "Content-Type: text/html; charset=iso-8859-9n";

/* ve gönderelim */
mail($giden, $baslik, $mesaj, $header);
}


if($sifre != "sifreniz")
{
    if($admin == "ok")
    {
        echo "> ";
    }
    else
        {
        echo "Hatalı Şifre";
?>
<form name="form" method="POST" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Admin Giriş</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Şifre</td>
      <td>
        <input type="password" name="sifre" size="20" maxlength="20">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>    
<?
        die();
        }
}
else
{
    $_SESSION["admin"] = "ok";
    header("Location: admin.php?komut=istatistik");
}

    echo "<b>siteadi.net Admin<br></b>";
    echo "Diğer : <a href=\"/\" target=\"_blank\">siteadi.net</a>";
    echo " | <a href=\"$PHP_SELF?komut=istatistik\">İstatistik</a>";
    echo " | <a href=\"$PHP_SELF?komut=toplist&tip=gelen\">Toplist</a>";
    echo " | <a href=\"$PHP_SELF?komut=toplist&tip=giden\">Tıklananlar</a><br>";
    echo "Link : <a href=\"$PHP_SELF?komut=link_listele\">Listele</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=link_bekleyen\">Bekleyen</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=link_ekle\">Ekle</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=link_degistir\">Değiştir</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=link_sil\">Sil</a>";
    echo "<br>";
    echo "Kategori : <a href=\"$PHP_SELF?komut=kategori_listele\">Listele</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=kategori_ekle\">Ekle</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=kategori_degistir\">Değiştir</a>";
    echo " | ";
    echo "<a href=\"$PHP_SELF?komut=kategori_sil\">Sil</a>";
    echo "<br>";
    echo "Diğer : <a href=\"$PHP_SELF?komut=kapat\">Kapat</a>";
    echo "<br><br>";



switch($komut)
    {
        case 'istatistik':
$linkz = mysql_query("SELECT COUNT(id) FROM linkler WHERE onay='h'");
$tz = mysql_fetch_row($linkz);
$onaysiz = $tz[0];

$katz = mysql_query("SELECT COUNT(kat_id) FROM kategoriler");
$ty = mysql_fetch_row($katz);
$kategori_sayisi = $ty[0];

$tt = mysql_query("SELECT COUNT(id),SUM(gelen),SUM(giden),SUM(ekleyen='k'),SUM(ekleyen='a'),SUM(ekleyen='r') FROM linkler");
$tx = mysql_fetch_row($tt);
$link_sayisi = $tx[0];
$gelenler = $tx[1];
$gidenler = $tx[2];
$kul = $tx[3];
$adm = $tx[4];
$reklam = $tx[5];
$oran = $gidenler / $gelenler;
$onayli = $link_sayisi - $onaysiz;

echo "<b>Kategori Sayısı :</b> $kategori_sayisi";
echo "<br>";
echo "<b>Link Sayısı :</b> $link_sayisi (Kullanıcı : $kul, Admin : $adm, Reklam : $reklam)";
echo "<br>";
echo "<b>Onaylanmış Link :</b> $onayli";
echo "<br>";
echo "<b>Onaysız Link :</b> $onaysiz";
echo "<br>";
echo "<b>Gelen Hit :</b> $gelenler";
echo "<br>";
echo "<b>Giden Hit :</b> $gidenler";
echo "<br>";
echo "<b>Oran :</b> $oran";
break;

        case 'toplist':
?>
<table width="750" border="0" cellspacing="0" cellpadding="5" bgcolor="<? echo "$renk1"; ?>" align=center>
  <tr bgcolor="<? echo "$renk2"; ?>"> 
    <td>
      <center>
        <font size="2" face="Verdana"><b>#</b></font> 
      </center>
    </td>
    <td>
      <center>
        <font size="2" face="Verdana"><b>id</b></font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Link Adı</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Url</b> </font> 
      </center>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Kategori</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Sahip</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Tarih</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Hit</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>İşlem</b> </font> 
      </center>
    </td>
  </tr>

<?

$b=0;

$isimz = mysql_query("SELECT * FROM linkler WHERE onay='e' && $tip != '0' ORDER BY $tip DESC");
$i=1;
while ($link = mysql_fetch_array($isimz))
{
if($b==0) { $renk = $renk3; $b=1; }
else { $renk = $renk4; $b=0; }

echo "<tr bgcolor=$renk><td>".$i."»</td><td>".$link['id']."</td>";
echo "<td>".$link['isim']."</td>";
echo "<td><a href=\"".$link['url']."\" target=\"_blank\">".$link['url']."</a></td>";

$kategori = $link['kategori'];

$isimx = mysql_query("select * from kategoriler WHERE kat_id='$kategori'");
$kategorix = mysql_fetch_array($isimx);
$kategoriy = $kategorix['kategori_adi'];

echo "<td>$kategoriy</td>";
echo "<td><a href=\"mailto:".$link['email']."\">".$link['sahip']."</a></td>";
echo "<td>".$link['tarih']."</td>";
echo "<td>".$link['gelen']."/".$link['giden']."</td>";
echo "<td><a href=$PHP_SELF?komut=link_degistir&id=".$link['id'].">Değiştir</a>";
echo " | <a href=$PHP_SELF?komut=link_sil&id=".$link['id'].">Sil</a></td>";
echo "</tr>";
$i++;
}
echo "</table>";
            break;

        case 'link_listele':
?>
<table width="750" border="0" cellspacing="0" cellpadding="5" bgcolor="<? echo "$renk1"; ?>" align=center>
  <tr bgcolor="<? echo "$renk2"; ?>"> 
    <td>
      <center>
        <font size="2" face="Verdana"><b>id</b></font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Link Adı</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Url</b> </font> 
      </center>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Kategori</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Sahip</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Tarih</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Hit</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>İşlem</b> </font> 
      </center>
    </td>
  </tr>

<?

$b=0;

//$isimz = mysql_query("SELECT * FROM linkler WHERE onay='e' AND kategori='".$_GET["kat"]."' ORDER BY id DESC");
$isimz = mysql_query("SELECT * FROM linkler WHERE onay='e' ORDER BY id DESC");
$ekrana_salla = "";
while ($link = mysql_fetch_array($isimz))
{
if($b==0) { $renk = $renk3; $b=1; }
else { $renk = $renk4; $b=0; }

$ekrana_salla .= "<tr bgcolor=$renk><td>".$link['id']."</td>";
$ekrana_salla .= "<td>".$link['isim']."</td>";
$ekrana_salla .= "<td><a href=\"".$link['url']."\" target=\"_blank\">".$link['url']."</a> (".$link['ekleyen'].")</td>";

$kategori = $link['kategori'];

$isimx = mysql_query("select * from kategoriler WHERE kat_id='$kategori'");
$kategorix = mysql_fetch_array($isimx);
$kategoriy = $kategorix['kategori_adi'];

$ekrana_salla .=  "<td>$kategoriy</td>";
$ekrana_salla .=  "<td><a href=\"mailto:".$link['email']."\">".$link['sahip']."</a></td>";
$ekrana_salla .=  "<td>".$link['tarih']."</td>";
$ekrana_salla .=  "<td>".$link['gelen']."/".$link['giden']."</td>";
$ekrana_salla .=  "<td><a href=$PHP_SELF?komut=link_degistir&id=".$link['id'].">Değiştir</a>";
$ekrana_salla .=  " | <a href=$PHP_SELF?komut=link_sil&id=".$link['id'].">Sil</a></td>";
$ekrana_salla .=  "</tr>";
}
$ekrana_salla .=  "</table>";
echo $ekrana_salla;
            break;
        case 'link_bekleyen':
?>
<table width="750" border="0" cellspacing="0" cellpadding="5" bgcolor="<? echo "$renk1"; ?>" align=center>
  <tr bgcolor="<? echo "$renk2"; ?>"> 
    <td>
      <center>
        <font size="2" face="Verdana"><b>id</b></font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Link Adı</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Url</b> </font> 
      </center>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Kategori</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Sahip</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Tarih</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Hit</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>İşlem</b> </font> 
      </center>
    </td>
  </tr>

<?

$b=0;

$isimz = mysql_query("select * from linkler WHERE onay='h'  order by gelen DESC,id ASC LIMIT 0,50");
while ($link = mysql_fetch_array($isimz))
{
if($b==0) { $renk = $renk3; $b=1; }
else { $renk = $renk4; $b=0; }

echo "<tr bgcolor=$renk><td>".$link['id']."</td>";
echo "<td>".$link['isim']."</td>";
echo "<td><a href=\"".$link['url']."\" target=\"_blank\">".$link['url']."</a></td>";

$kategori = $link['kategori'];

$isimx = mysql_query("select * from kategoriler WHERE kat_id='$kategori'");
$kategorix = mysql_fetch_array($isimx);
$kategoriy = $kategorix['kategori_adi'];

echo "<td>$kategoriy</td>";
echo "<td><a href=\"mailto:".$link['email']."\">".$link['sahip']."</a></td>";
echo "<td>".$link['tarih']."</td>";
echo "<td>".$link['gelen']."/".$link['giden']."</td>";
echo "<td><a href=$PHP_SELF?komut=link_degistir&id=".$link['id'].">Değiştir</a>";
echo " | <a href=$PHP_SELF?komut=link_sil&id=".$link['id'].">Sil</a>";
echo " | <a href=$PHP_SELF?komut=link_onayla&id=".$link['id']."&email=".$link['email']."&url=".$link['url']."&sahip=".$link['sahip'].">Onayla</a>";
echo " | <a href=$PHP_SELF?komut=link_onaylama&id=".$link['id']."&email=".$link['email']."&url=".$link['url']."&sahip=".$link['sahip'].">RED</a></td>";
echo "</tr>";
}
echo "</table>";
            break;



        case 'link_ekle':
if($url)
        {
$tarih = date ("YmdHis", mktime());
$onay = 'e';

            if (mysql_query("INSERT INTO linkler (id,isim,url,kategori,sahip,email,ekleyen,onay,tarih) VALUES (null,'$isim','$url',$kategori,'$sahip','$email','$ekleyen','$onay','$tarih')"))
                {
echo "<b>isim :</b> $isim<br>
<b>Url :</b> $url<br>
<b>Sahip :</b> $sahip<br>
<b>Email :</b> $email<br>
<b>Kategori :</b> $kategori<br>

<br>
<a href=\"admin.php?komut=link_ekle&kat=$kategori\">Bu kategoriye yeni kayıt gir</a>";

$id=mysql_insert_id();
mail_yolla($url,$sahip,$email,$id,1);
                }
                else { echo "Kayıt yapılamadı"; echo mysql_error(); }
        }
        else
            {
            ?>
<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="400" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Link Ekleme</b></font> 
        </center>
      </td>
    </tr>
      <tr><td>Sayfanın Adı</td>
      <td>
        <input type="hidden" name="komut" value="link_ekle">
        <input type="text" name="isim" size="30" maxlength="30">
      </td></tr>
      <tr><td>URL</td>
      <td>
        <input type="text" name="url" size="30" maxlength="100">
      </td></tr>
    <tr>
      <td>Kategori Adı</td>
      <td>
<?
$isimz = mysql_query("select * from kategoriler order by kategori_adi");

echo "<select name=\"kategori\">";

while ($kategori = mysql_fetch_array($isimz))
{
 echo "<option value=\"".$kategori['kat_id']."\"";
 if($kat == $kategori['kat_id']) echo "selected";
 echo ">".$kategori['kategori_adi']."</option>";
}        

echo "</select>";
?>
      </td>
    </tr>
    <tr>
      <td>Kim Ekliyor</td>
      <td>
<select name="ekleyen">
<option value="a">Admin</option>
<option value="k">Kullanıcı</option>
<option value="r">Reklam</option>
</select>
      </td>
    </tr>
      <tr><td>Sahibi</td>
      <td>
        <input type="text" name="sahip" size="30" maxlength="30">
      </td></tr>
      <tr><td>Email</td>
      <td>
        <input type="text" name="email" size="30" maxlength="40">
      </td></tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }

        break;

        case 'link_degistir':

if($url)
        {
$tarih = date ("YmdHis", mktime());

            if (mysql_query("UPDATE linkler SET id='$id',isim='$isim',url='$url',kategori='$kategori',sahip='$sahip',email='$email',ekleyen='$ekleyen',tarih='$tarih' WHERE id='$id'"))
                {
                echo "<b>$isim</b> isimli site <b>$url</b> 'si olarak değiştirildi..";
                }
                else { echo "Değiştirilemedi..."; echo mysql_error(); }
        }
        else
            {
$isimz = mysql_query("select * from linkler where id='$id'");
$link = mysql_fetch_array($isimz);
if($link['id']=="") echo "Böyle bir kayıt bulunamadı..";
?>

<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="400" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Link Değiştir</b></font> 
        </center>
      </td>
    </tr>
      <tr><td>Sayfanın Adı</td>
      <td>
        <input type="hidden" name="komut" value="link_degistir">
        <input type="hidden" name="id" value="<? echo $link['id']; ?>">
        <input type="text" name="isim" size="30" maxlength="30" value="<? echo $link['isim']; ?>">
      </td></tr>
      <tr><td>URL</td>
      <td>
        <input type="text" name="url" size="30" maxlength="100" value="<? echo $link['url']; ?>">
      </td></tr>
    <tr>
      <td>Kategori Adı</td>
      <td>
<?
$isimz = mysql_query("select * from kategoriler order by kategori_adi");

echo "<select name=\"kategori\">";

while ($kategori = mysql_fetch_array($isimz))
{
 echo "<option value=\"".$kategori['kat_id']."\"";
 if($link['kategori'] == $kategori['kat_id']) echo selected;
 echo ">".$kategori['kategori_adi']."</option>";
}        

echo "</select>";
?>
      </td>
    </tr>
    <tr>
      <td>Kim Ekliyor</td>
      <td>
<select name="ekleyen">
<option value="a" <? if($link['ekleyen'] == "a") echo selected; ?>>Admin</option>
<option value="k" <? if($link['ekleyen'] == "k") echo selected; ?>>Kullanıcı</option>
<option value="r" <? if($link['ekleyen'] == "r") echo selected; ?>>Reklam</option>
</select>
      </td>
    </tr>
      <tr><td>Sahibi</td>
      <td>
        <input type="text" name="sahip" size="30" maxlength="30" value="<? echo $link['sahip']; ?>">
      </td></tr>
      <tr><td>Email</td>
      <td>
        <input type="text" name="email" size="30" maxlength="40" value="<? echo $link['email']; ?>">
      </td></tr>

    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;
        
        case 'link_sil':
if($id)
        {
            if (mysql_query("delete from linkler where id=$id"))
                {
                echo "Silindi..";
                }
                else { echo "Silinemedi."; echo mysql_error(); }
        }
        else
            {
            ?>
<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Link Silme</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Link ID</td>
      <td>
        <input type="hidden" name="komut" value="link_sil">
        <input type="text" name="id" size="8" maxlength="8" value="">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;

        case 'link_onayla':
if($id)
        {
            if (mysql_query("UPDATE linkler SET onay='e' where id=$id"))
                {
                echo "Onaylandı..";
mail_yolla($url,$sahip,$email,$id,1);
                }
                else { echo "Onaylanmadı."; echo mysql_error(); }
        }
        else
            {
            ?>
<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Link Onaylama</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Link ID</td>
      <td>
        <input type="hidden" name="komut" value="link_onayla">
        <input type="text" name="id" size="8" maxlength="8" value="">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;
        case 'link_onaylama':
if($id)
        {
            if (mysql_query("DELETE FROM linkler WHERE id=$id"))
                {
                echo "Onaylanmadı ve silindi..";
                mail_yolla($url,$sahip,$email,$id,2);
                }
                else { echo "Silinemedi.."; echo mysql_error(); }
        }
        else
            {
            ?>
<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Link OnaylamaMA</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Link ID</td>
      <td>
        <input type="hidden" name="komut" value="link_onayla">
        <input type="text" name="id" size="8" maxlength="8" value="">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;

        case 'kategori_listele':
?>
<table width="300" border="0" cellspacing="0" cellpadding="2" bgcolor="<? echo "$renk1"; ?>" align=center>
  <tr bgcolor="<? echo "$renk2"; ?>"> 
    <td>
      <center>
        <font size="2" face="Verdana"><b>id</b></font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>Kategori Adı</b> </font> 
      </center>
    </td>
    <td> 
      <center>
        <font size="2" face="Verdana"><b>İşlem</b> </font> 
      </center>
    </td>
  </tr>

<?

$b=0;

$isimz = mysql_query("select * from kategoriler order by kategori_adi");
while ($kategori = mysql_fetch_array($isimz))
{
if($b==0) { $renk = $renk3; $b=1; }
else { $renk = $renk4; $b=0; }

echo "<tr bgcolor=$renk><td>".$kategori['kat_id']."</td>";
echo "<td>".$kategori['kategori_adi']."</td>";
echo "<td><a href=$PHP_SELF?komut=kategori_degistir&id=".$kategori['kat_id'].">Değiştir</a>";
echo " | <a href=$PHP_SELF?komut=kategori_sil&id=".$kategori['kat_id'].">Sil</a></td>";
echo "</tr>";
}
echo "</table>";
break;

case 'kategori_ekle':
if($kati<>'')
{
if (mysql_query("INSERT INTO kategoriler (kat_id,kategori_adi)VALUES (NULL , '$kati')"))
{
echo "Kayıt yapıldı";
}
else { echo "Kayıt yapılamadı"; echo mysql_error(); }
}
else
{
?>
<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Kategori Ekleme</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Kategori Adı</td>
      <td>
        <input type="hidden" name="komut" value="kategori_ekle">
        <input type="text" name="kati" size="30" maxlength="30" value="">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Ekle">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;
        
        case 'kategori_degistir':
if($id && $kati <> '')
        {
            if (mysql_query("update kategoriler SET kategori_adi='$kati' where kat_id='$id'"))
            {
                echo "Değiştirildi..";
            }
                else { echo "Değiştirilemedi."; echo mysql_error(); }
        }
        else
            {
            $isimz = mysql_query("select * from kategoriler where kat_id='$id'");
            $kategori = mysql_fetch_array($isimz);
            if($kategori['kat_id']=="") echo "Böyle bir kayıt bulunamadı..";
        ?>

<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Kategori Değiştir</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Kategori Adı</td>
      <td>
        <input type="hidden" name="komut" value="kategori_degistir">
        <input type="hidden" name="id" value="<? echo $kategori['kat_id']; ?>">
        <input type="text" name="kati" size="30" maxlength="30" value="<? echo $kategori['kategori_adi']; ?>">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;

        case 'kategori_sil':
if($id)
        {
            if (mysql_query("delete from kategoriler where kat_id=$id"))
                {
                echo "Silindi..";
                }
                else { echo "Silinemedi."; echo mysql_error(); }
        }
        else
            {
            ?>
<form name="form" method="get" action="<? echo $PHP_SELF; ?>">
  <table border="0" align="center" width="250" cellpadding="5" cellspacing="0" bgcolor="<? echo "$renk1"; ?>">
    <tr bgcolor="<? echo "$renk2"; ?>"> 
      <td colspan="2"> 
        <center>
          <font face="Verdana" size="2"><b>Kategori Silme</b></font> 
        </center>
      </td>
    </tr>
    <tr> 
      <td>Kategori ID</td>
      <td>
        <input type="hidden" name="komut" value="kategori_sil">
        <input type="text" name="id" size="8" maxlength="8" value="">
      </td>
    </tr>
    <tr> 
      <td></td>
      <td>
        <input type="submit" name="Submit" value="Gönder">
      </td>
    </tr>
  </table>
</form>            
            <?
            }
            break;
        
        case 'kapat':
            $admin = "oki_degil";
            break;
            
        default:
            echo "Geçersiz komut";
            break;

    }
?>
bunu admin.php ye kopyala.