28
●1.864
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<title> Ürün Kategorileri </title>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body leftmargin="0" topmargin="5" bgcolor="#e8eef0">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1"><img src="../ustsol.jpg" width="23" height="26"></td>
<td align="center" bgcolor="#2359b2" class="arialbeyaz16">SİPARİŞ LİSTESİ</td>
<td width="1"><img src="../ustsag.jpg" alt="" width="23" height="26"></td>
</tr>
</table>
<?
$baglanti=mysql_connect("localhost","root","");
if (!$baglanti){ echo"mysql sunucu kapalı veya bilgiler hatalı"; exit;}
$test=mysql_select_db("ziyaretci",$baglanti);
if (!$test){ echo"veritabanı adı yanlış"; exit;}
if ($secim == 1) // silme işlemi
$sorgu=mysql_query("DELETE FROM defter where id='$id'");
$sql_urun_anakategori = mysql_query("select * from defter ORDER by id DESC");
$urun_anakategori = mysql_fetch_array($sql_urun_anakategori);
?><br>
echo $urun_anakategori;
<div align="center">
<table border="0" align="left" cellpadding="2" cellspacing="2" bgcolor="#CCCCCC" id="table1">
<tr>
<td height="23" colspan="16" bgcolor="#E8EEF0" class="arialsiyah11b"><div align="left"></div></td>
</tr>
<tr>
<td width="28" bgcolor="#E8EEF0" class="arialsiyah11b">Ad soyad</td>
<td width="41" bgcolor="#E8EEF0" class="arialsiyah11b">konu</td>
<td width="45" bgcolor="#E8EEF0" class="arialsiyah11b">mesaj</td>
<td width="35" bgcolor="#E8EEF0" class="arialsiyah11b">Tarih</td>
<td width="51" bgcolor="#E8EEF0" class="arialsiyah11b">Firma Adı</td>
<td width="22" bgcolor="#E8EEF0" class="arialsiyah11b">Sil</td>
<td width="60" bgcolor="#E8EEF0" class="arialsiyah11b">Güncelle</td>
</tr>
<?
$adet=0;
do {
++$adet;
if( ($adet % 2) == 0 ) $renk="#e8eef0";
else $renk="#D3DFE4";
$id = $urun_anakategori["id"];
?>
<tr bgcolor='<? echo $renk ?>'>
<td height="25" class="arialsiyah12"><div align="center" <?=$id?>>
<div align="left"><? echo $urun_anakategori["z_ismi"] ?></div>
</div></td>
<td height="25" class="arialsiyah12"><div align="left"><? echo $urun_anakategori["z_konu"] ?></div></td>
<td height="25" class="arialsiyah12"><div align="left"><? echo $urun_anakategori["z_mesaj"] ?></div></td>
<td height="25" class="arialsiyah12"><div align="left"><? echo $urun_anakategori["z_tarih"] ?></div></td>
<td height="25" class="arialsiyah12"><div align="left"><? echo $urun_anakategori["z_firma"] ?></div></td>
<td class="bod" align="center"><div align="left"><a style="color:#0066FF" href='liste.php?secim=1&id=<?echo $urun_anakategori["id"] ?>'>Sil</a></div></td>
<br />
<td class="bod" align="center"><div align="left"><a style="color:#0066FF" href='liste.php?secim=1&id=<?echo $urun_anakategori["id"] ?>'>Güncelle</a></div></td>
</tr>
<?
}
while ( $urun_anakategori = mysql_fetch_array($sql_urun_anakategori) );
?>
</table>
<p></p>
<p> </p>
</div>
</body></html> 
if (empty ($z_ismi)) exit;yazmışsın. $z_ismi diye bir değiken olmadığından çıkar. Eğer z_ismi alanına göre kontrol yapacaksan:
if(!isset($_POST['z_ismi']) && empty($_POST['z_ismi'])) exit();şeklinde kullabilirsin. Birde foruma eklerken kodlarını taglari içine al ki okunması rahat olsun.
))CREATE TABLE `defter` ( `id` int(3) NOT NULL auto_increment, `z_ismi` char(75) character set utf8 collate utf8_turkish_ci NOT NULL, `z_konu` text character set utf8 collate utf8_turkish_ci NOT NULL, `z_mesaj` char(74) character set utf8 collate utf8_turkish_ci NOT NULL, `z_tarih` int(12) NOT NULL, `z_firma` text character set utf8 collate utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;veritabanın ok gözüküyor. ama z_tarih isimli tabloyu eğer tarihlerle çalışacaksan date time, veya timestamp olarak ayarla.