ayarlar.php yi aşağıda veriyorum..
tablo yapısı
CREATE TABLE `ayar` (
`id` tinyint(11) NOT NULL auto_increment,
`site_basligi` varchar(255) NOT NULL default '',
`okulun_adi` varchar(255) NOT NULL default '',
`ust_resim` varchar(255) NOT NULL default '',
`adres` varchar(255) NOT NULL default '',
`mail` varchar(255) NOT NULL default '',
`meta_kelime` varchar(255) NOT NULL default '',
`meta_açiklama` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=2 ;
<?php
include ("yol.php");
switch ($_GET['mode']){
case ayarlarduzelt:
$sorgu = mysql_query("SELECT * FROM ayar WHERE id = '$_GET[id]'");
while ($bilgi = mysql_fetch_array($sorgu)){
echo $_GET[id];
?>
<form action="yonetim.php?mode=ayarlarduzelt&id=<?=$_GET['id']?>" method="POST" >
<table width="400" border="1" cellspacing="0" cellpadding="0">
<tr><td width="50"><font face="Verdana" size="2" color="Black">Site Basligi:</font></td>
<td width="260"><input type="Text" name="site_basligi" size="105" value="<?=$bilgi[site_basligi];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Okulun Adi:</font></td>
<td width="260"><input type="Text" name="okulun_adi" size="105" value="<?=$bilgi[okulun_adi];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Ust Resim:</font></td>
<td width="260"><input type="Text" name="ust_resim" value="<?=$bilgi[ust_resim];?>" size="55" cols="39"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Adres:</font></td>
<td width="260"><input type="Text" name="adres" size="105" value="<?=$bilgi[adres];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Mail:</font></td>
<td width="260"><input type="Text" name="maill" size="105" value="<?=$bilgi[maill];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Meta kelime:</font></td>
<td width="260"><input type="Text" name="meta_kelime" size="105" value="<?=$bilgi[meta_kelime];?>"></td>
</tr>
<tr><td width="50"><font face="Verdana" size="2" color="Black">Meta Aciklama:</font></td>
<td width="260"><input type="Text" name="meta_açiklama" size="105" value="<?=$bilgi[meta_açiklama];?>"></td>
</tr>
<tr><td>
<input type="hidden" name="kaydet" value="1" />
<input type="hidden" name="id" value="<?=$bilgi['id'];?>" />
<input type="Submit" name="Send Mail" value="Gonder"> </td></tr>
</table></form><br>
<?
//echo $_GET['id'];
$id = $_POST['id'];
$site_basligi=$_POST['site_basligi'];
$okulun_adi=$_POST['okulun_adi'];
$ust_resim=$_POST['ust_resim'];
$adres=$_POST['adres'];
$maill=$_POST['maill'];
$meta_kelime=$_POST['meta_kelime'];
$meta_açiklama=$_POST['meta_açiklama'];
}
if ($kaydet == 1)
{
$yaz = mysql_query("UPDATE ayar set
site_basligi='".$site_basligi."',
okulun_adi='".$okulun_adi."',
ust_resim='".$ust_resim."', adres='".$adres."',
maill='".$maill."', meta_kelime='".$meta_kelime."',
meta_açiklama='".$meta_açiklama."', WHERE
id='".$id."'"); echo ("UPDATE ayar set
site_basligi='$site_basligi', okulun_adi='okulun_adi',
ust_resim='ust_resim', adres='adres', maill='maill',
meta_kelime='meta_kelime', meta_aciklama='meta_aciklama'
WHERE id=$id");
echo ("UPDATE ayar set site_basligi='$site_basligi', okulun_adi='okulun_adi', ust_resim='ust_resim', adres='adres', maill='maill', meta_kelime='meta_kelime', meta_aciklama='meta_aciklama' WHERE id='.$id.'");
echo $yaz;
print mysql_error();
echo "<script language='javascript'>alert('Düzenleme İşlemi Başarıyla Tamamlanmıştır...'); .href='yonetim.php?mode=ayarlar.php';</script>";
}else{
echo "Hata oluştu";
}
break;
default:
?>
<center>
<?
$toplam_kayit = mysql_query("Select * from ayar");
$say = mysql_num_rows($toplam_kayit);
?>
<font face="Century Gothic" color="#51A8FF">Toplam Kayıt : </font><?=$say;?>
<a href="yonetim.php?mode=ayarlarekle"></center>
<table width="800" border="1" cellspacing="0" cellpadding="0" align="CENTER">
<tr>
<td colspan="9" align="CENTER" valign="MIDDLE">AYARLAR</td>
</tr>
<tr>
<td align="CENTER"><b>id<b></td>
<td align="CENTER"><b>Site Basligi<b></td>
<td align="CENTER"><b>Okulun Adi<b></td>
<td align="CENTER"><b>Ust Resim<b></td>
<td align="CENTER"><b>Adres<b></td>
<td align="CENTER"><b>Mail<b></td>
<td align="CENTER"><b>Meta Kelime<b></td>
<td align="CENTER"><b>Meta Aciklama<b></td>
<td align="CENTER"><b>Duzelt<b></td>
<td align="CENTER"><b>Sil<b></td>
</tr>
<?
$oku = mysql_query("SELECT * FROM ayar ORDER BY id DESC");
while ($okunan = mysql_fetch_array($oku)){
?>
<tr>
<td align="CENTER"><?=$okunan['id']?> </td>
<td align="CENTER"><?=$okunan['site_basligi']?> </td>
<td align="CENTER"><?=$okunan['okulun_adi']?> </td>
<td align="CENTER"><?=$okunan['ust_resim']?> </td>
<td align="CENTER"><?=$okunan['adres']?> </td>
<td align="CENTER"><?=$okunan['maill']?> </td>
<td align="CENTER"><?=$okunan['meta_kelime']?> </td>
<td align="CENTER"><?=$okunan['meta_açiklama']?> </td>
<td align="CENTER" bgcolor="#FFC891"><a href="yonetim.php?mode=ayarlarduzelt&id=<?=$okunan['id']?>">Düzelt</a></td>
<td align="CENTER" bgcolor="#FF4A4A"><a href="yonetim.php?mode=ayarlarsil&id=<?=$okunan['id']?>"> Sil </a></td>
</tr>
<?php
}
}
?> </table>