Alttaki kod admin panelini kodu<?
if (eregi("zd.php",$PHP_SELF)) {
Header("Location: index.php");
die();
}
if ($SIL=="YES") {
mysql_query("delete from zd where id = '".$ID."' limit 1");
echo "<body OnLoad=\"javascript: alert('$ID Numaralı mesaj silindi.');\">";
}
?>
<table border="0" cellspacing="5" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td width="100%" valign="top" align="center" bgcolor="#377CC8">
<font face="Verdana"><b><font color="#FF0000"><br>
</font><font color="#FFFFFF" size="4">Ziyaretçi Defteri<br>
</font></b></font></td>
</tr>
</table>
<?
$max=10;
if (!isset($pagex)) $pagex=1;
if ($pagex=="") $pagex=1;
$limit1=($pagex - 1) * $max;
$hsql1=mysql_query("select * from zd order by zaman desc");
$hrows1=mysql_num_rows($hsql1);
$hsql=mysql_query("select id, DATE_FORMAT(zaman, '%d/%m/%Y %H:%i:%s') tarih, isim, mail, baslik, mesaj, ip from zd order by zaman desc LIMIT $limit1, $max");
$hrows=mysql_num_rows($hsql);
for ($i=0; $i<$hrows; $i++) {
$fa=mysql_fetch_array($hsql);
?>
<table border="0" cellpadding="0" cellspacing="5" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
<tr>
<td background="../images/zd_bg.gif" height="28"><font color="#FFFFFF"><b> Mesaj
Atan</b></font></td>
<td background="../images/zd_bg.gif" height="28"><font color="#FFFFFF"><b> <?=$fa[baslik]?></b></font></td>
</tr>
<tr>
<td width="200" valign="top" bgcolor="#FFFFFF"><b><center><?=$fa[isim]?><? if ($fa[mail]<>"") { ?><br><a href="
mailto:<?=$fa[mail]?>"><?=$fa[mail]?><? } ?></a></td>
<td bgcolor="#FFFFFF" valign=top >
<?=nl2br(htmlspecialchars($fa[mesaj]))?>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td><?=$fa[tarih]?></td>
<td>[ <a href="?file=zd&pagex<?=$pagex."&SIL=YES&ID=".$fa[id]?>"?>">Sil</a> ]</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%"><span style="font-size: 6pt"> </span></td>
</tr>
</table>
<?
}
$ss=$hrows1/$max;
$ss=ceil($ss);
if ($ss>1) {
echo " Sayfalar: ";
for ($ci=1;$ci<=$ss;$ci++) {
if ($pagex == $ci) { echo "<b>[$ci]</b> "; } else {
echo "[<a href=\"?file=zd&pagex=$ci\">$ci<a>] ";
}
}
}
?>
alttaki kod kullanıcı sayfasındaki okuma ve yazma sayfaları<style type="text/css">
<!--
.style7 {
color: #003399;
font-family: Geneva, Arial, Helvetica, sans-serif;
font-weight: bold;
font-size:1em;
}
.style8 {font-family: Geneva, Arial, Helvetica, sans-serif}
.style9 {font-size:1em}
.style14 {
color: #003399;
font-weight: bold;
font-size:1em;
}
-->
</style>
<span class="ContentHeader">
<?
$max=5;
if (!isset($pagex)) $pagex=1;
if ($pagex=="") $pagex=1;
$limit1=($pagex - 1) * $max;
$hsql1=mysql_query("select * from zd order by zaman desc");
$hrows1=mysql_num_rows($hsql1);
$hsql=mysql_query("select id, DATE_FORMAT(zaman, '%d/%m/%Y %H:%i:%s') tarih, isim, mail, baslik, mesaj, ip from zd order by zaman desc LIMIT $limit1, $max");
$hrows=mysql_num_rows($hsql);
for ($i=0; $i<$hrows; $i++) {
$fa=mysql_fetch_array($hsql);
?>
</span>
<table border="0" cellpadding="0" cellspacing="2" style="border-collapse: collapse" bordercolor="#111111" width="430" id="AutoNumber1">
<tr bgcolor="#F2F2F2">
<td height="19" class="ContentHeader"><span class="style7"> Mesajı
Atan</span></td>
<td width="220" height="19" class="ContentHeader"><div align="left"><font class="ContentText style8 style14">
<?=$fa[baslik]?>
</font></div></td>
<td width="108" class="ContentHeader"><div align="right"><font class="ContentText style8 style14">
<?=$fa[tarih]?>
</font></div></td>
</tr>
<tr valign="bottom">
<td height="5" colspan="3" bgcolor="#FFFFFF" class="ContentHeader"><img src="images/cizgi.jpg" width="430" height="1"></td>
</tr>
<tr class="OnlineTextField">
<td width="98" valign="top" bgcolor="#FFFFFF" class="style7"><b>
<center>
<?=$fa[isim]?>
<br>
<a href="
mailto:<?=$fa[mail]?>"> </a></td>
<td colspan="2" valign=top bgcolor="#FFFFFF" >
<span class="ContentHeader style9 style8">
<?=nl2br(htmlspecialchars($fa[mesaj]))?>
</span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="5" colspan=3 class="ContentHeader style8" ><span class="ContentHeader"><img src="images/cizgi.jpg" width="430" height="1"></span>
</td>
</tr>
</table>
<span class="ContentHeader">
<?
}
$ss=$hrows1/$max;
$ss=ceil($ss);
if ($ss>1) {
echo " Sayfalar: ";
for ($ci=1;$ci<=$ss;$ci++) {
if ($pagex == $ci) { echo "<b>[$ci]</b> "; } else {
echo "[<a href=\"?module=zdoku&pagex=$ci\">$ci<a>] ";
}
}
}
?>
</span>
---------<?
if ($_POST['islem']=="kaydet") {
if ($_POST['adsoyad']!="" && $_POST['baslik']!="" && $_POST['mesaj']!="") {
mysql_query("insert into zd (zaman, isim, mail, baslik, mesaj, ip) VALUES ('".Date("Y/m/d H:i:s")."', '".$_POST['adsoyad']."', '".$_POST['mail']."', '".$_POST['baslik']."', '".$_POST['mesaj']."', '".$IP."')");
echo "<body OnLoad=\"javascript: alert('Mesajınız deftere kaydedildi.'); self.location = '?module=zdoku';\">";
} else {
echo "<body OnLoad=\"javascript: alert('Lütfen doldurulması gerekli olan alanları doldurunuz.'); self.history.back(-1);\">";
}
} else {
?>
<form method="POST" action="?module=zdyaz">
<div align="center">
<center>
<table border="0" cellspacing="5" style="border-collapse: collapse" bordercolor="#111111" width="424" id="AutoNumber1">
<tr class="ContentSubHeaderHaber">
<td width="25%" valign="top" align="right">
<font size="1" face="Verdana">(*) Adınız Soyadınız
</font> </td>
<td width="55%"> <input name="adsoyad" type="text" class="UyelikTextField" size="30"></td>
</tr>
<tr class="ContentSubHeaderHaber">
<td width="25%" valign="top" align="right">
<font size="1" face="Verdana"> E-mail
Adresiniz </font> </td>
<td width="55%"> <input name="mail" type="text" class="UyelikTextField" size="30"></td>
</tr>
<tr class="ContentSubHeaderHaber">
<td width="25%" valign="top" align="right">
<font size="1" face="Verdana">(*) Mesaj Başlığı
</font> </td>
<td width="55%"> <input name="baslik" type="text" class="UyelikTextField" size="30"></td>
</tr>
<tr class="ContentSubHeaderHaber">
<td width="25%" valign="top" align="right">
<font size="1" face="Verdana">(*) Mesajınız</font></td>
<td width="55%"> <textarea name="mesaj" cols="32" rows="11" class="UyelikTextField"></textarea></td>
</tr>
<tr class="ContentSubHeaderHaber">
<td width="25%" valign="top"> </td>
<td width="55%"> <input name="B1" type="submit" class="UyelikTextField" value="Gönder">
<input name="B2" type="reset" class="UyelikTextField" value="Temizle"></td>
</tr>
<tr class="ContentSubHeaderHaber">
<td valign="top" colspan="2">
<p align="center" class="formtext"><b><font size="1" face="Verdana">(*) işareti olan alanlar doldurulması zorunlu
alanlardır.</font></b></td>
</tr>
</table>
</center>
</div>
<input type="hidden" name="islem" value="kaydet">
</form>
<?
}
?>
alttaki kod sql tablosu --
-- Tablo yapısı: `zd`
--
CREATE TABLE IF NOT EXISTS `zd` (
`id` int(11) NOT NULL auto_increment,
`zaman` datetime NOT NULL default '0000-00-00 00:00:00',
`isim` varchar(100) NOT NULL,
`mail` varchar(100) NOT NULL,
`baslik` varchar(100) NOT NULL,
`mesaj` text NOT NULL,
`ip` varchar(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Tablo döküm verisi `zd`
--
sizden ricam kullanıcı yazdıgında onay bekliyor yazacak admin onayla kutucugu olacak onayla diyicem aktif olacak admin onaylı hale getiricem
Zaman
2010-11-13 01:46:36Php onaylı ziyaretçi defteri