Merhaba arkadaşlar, Elimde ziyaretçi defteri scripti var, kurdum. Deftere Normal bir biçimde yazıyorum Deneme YAZIDIR diye(aynı bu şekilde büyüklü küçüklü) kaydediyorum defteri oku dediğimde küçük bir biçimde yazıyor, yani deneme yazıdır gibi. CSS ile alakası yok baktım oku.php adında dosyadan ama çözemedim.Şimdiden teşekkürler.
<?php
/*
Hazırlayan ve Sunan : Duran Ömer çiçek
E-Mail : yorqunqaplan@hotmail.com
Script : PHP Ziyaretçi Defteri V 3.0 Tr
*/
include "contents/son_duyuru.php";
@$defter = mysql_query("select * from defter where onay=1");
@$bak = mysql_num_rows($defter);
if($bak>0){
$page = "?form=oku";
$limit = "8"; // sayfada görüntülenecek kayıt sayısı
if(empty($_GET['p'])) { $sayfa ="1";}
else{ $sayfa=$_GET['p'];
}
@$sorgu1 = mysql_query("select * from defter where onay=1"); //tablomuza baglandik
@$sayi = mysql_num_rows($sorgu1);
$kac_tane = $sayi / $limit;
$kac_tane = ceil($kac_tane);
$limitt = "4"; // gösterilecek sayfa numara sayısı
$i=$sayfa-$limitt+2;
$sinir = $sayfa+$limitt-2;
if($sinir>$kac_tane){
$sinir=$kac_tane;
}
if($i<1){ $i="1";}
$son = ($sayfa-1)*$limit;
if($_GET['p']>$sinir){
header("location:$page");
}
@$sorgu2 = mysql_query("select * from defter where onay=1 order by id DESC limit $son,$limit");
while(@$list=mysql_fetch_array($sorgu2)){ //while
@$id = $list['id'];
@$adsoyad = $list['adsoyad'];
@$mail = $list['mail'];
@$hotmail = $list['hotmail'];
@$yahoo = $list['yahoo'];
@$gmail = $list['gmail'];
@$icq = $list['icq'];
@$mynet = $list['mynet'];
@$internet = $list['internet'];
@$sehir = $list['sehir'];
@$metin = $list['metin'];
@$onay = $list['onay'];
@$zaman = $list['tarih'];
@$admin = $list['admin'];
@$yil = substr($zaman,0,4);
@$ay = substr($zaman,5,2);
@$gun = substr($zaman,8,2);
@$tarih = date("d F Y, D",mktime(0,0,0,$ay,$gun,$yil));
@$bul = array('January','February','March','April','May','June','July','August','September','October','November','December','Mon','Tue','Wed','Thu','Fri','Sat','Sun');
@$yaz = array('Ocak','Şubat','Mart','Nisan','Mayıs','Haziran','Temmuz','Ağustos','Eylül','Ekim','Kasım','Aralık','Pazartesi','Salı','Çarşamba','Perşembe','Cuma','Cumartesi','Pazar');
@$trtarih = str_replace($bul,$yaz,$tarih);
echo "<table border='0' width='100%' id='table3' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td>
<table border='1' width='100%' id='table4' bordercolorlight='#E9E9E9' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#E9E9E9'>
<tr>
<td>
<table border='0' width='100%' id='table7' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td width='2%' height='5'></td>
<td width='96%' height='5'></td>
<td width='2%' height='5'></td>
</tr>
<tr>
<td width='2%'> </td>
<td width='96%'>
<table border='0' width='100%' id='table8' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td width='25%' valign='top'>
<table border='1' width='100%' id='table11' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#F3F3F3'>
<tr>
<td>
<!--mesaj yazan bilgileri-->
<table border='0' width='100%' id='table12' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/ziyaretci.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'> </td>
<td height='20' bgcolor='#F9F9F9'><b>$adsoyad</b></td>
</tr>
<tr>
<td height='5' width='13%'></td>
<td height='5' width='4'></td>
<td height='5'></td>
</tr>
<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/zaman.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'> </td>
<td height='20' bgcolor='#F9F9F9'>$trtarih</td>
</tr>
<tr>
<td height='5' width='13%'></td>
<td height='5' width='4'></td>
<td height='5'></td>
</tr>
<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/sehir.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'> </td>
<td height='20' bgcolor='#F9F9F9'>$sehir</td>
</tr>
<tr>
<td height='5' width='13%'></td>
<td height='5' width='4'></td>
<td height='5'></td>
</tr>";
if($admin==1){
echo "<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/mesaj.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'> </td>
<td height='20' bgcolor='#F9F9F9'><font color='#197FE0'>Ziyaretçi Mesajı</font></td>
</tr>";
}elseif($admin==2){
echo "<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/admin.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'> </td>
<td height='20' bgcolor='#F9F9F9'><font color='#6464AE'>Yönetici Mesajı</font></td>
</tr>";
}else{
echo "<tr>
<td width='13%' height='20' bgcolor='#F9F9F9'>
<p align='center'>
<img border='0' src='images/icon/mesaj.gif' width='16' height='16'></td>
<td width='4' height='20' bgcolor='#F9F9F9'> </td>
<td height='20' bgcolor='#F9F9F9'><font color='#197FE0'>Ziyaretçi Mesajı</font></td>
</tr>";
}
echo "</table>
<!--mesaj yazan bilgileri-->
</td>
</tr>
</table>
</td>
<td width='1%'> </td>
<td width='74%' valign='top'>
<table border='1' width='100%' id='table13' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' bordercolordark='#F3F3F3' style='border-collapse: collapse'>
<tr>
<td>
<table border='0' width='100%' id='table14' cellpadding='0' style='border-collapse: collapse' height='94'>
<tr>
<td height='5' bgcolor='#F9F9F9' width='100%' colspan='3'></td>
</tr>
<tr>
<td height='60' bgcolor='#F9F9F9' width='2%'></td>
<td height='60' bgcolor='#F9F9F9' width='96%' valign='top'>
<p align='justify'>$metin</td>
<td height='60' bgcolor='#F9F9F9' width='2%'> </td>
</tr>
<tr>
<td height='5' bgcolor='#F9F9F9' width='100%' colspan='3'></td>
</tr>
<tr>
<td height='5' colspan='3'></td>
</tr>
<tr>
<td height='20' align='center' bgcolor='#F9F9F9' colspan='3'>
<!--mail iconlar-->
<table border='0' id='table15' cellpadding='0' style='border-collapse: collapse'>
<tr>
<td>";
if($internet==""){
echo "<img border='0' src='images/icon/int_pass.gif' width='60' height='20'>";
}elseif($internet=="http://"){
echo "<img border='0' src='images/icon/int_pass.gif' width='60' height='20'>";
}else{
echo "<a href='$internet' target='_blank'><img border='0' src='images/icon/int.gif' width='60' height='20'></a>";
}
echo "</td>
<td> </td>
<td>";
if($mail==""){
echo "<img border='0' src='images/icon/email_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/email.gif' width='60' height='20' alt='$mail'>";
}
echo "</td>
<td> </td>
<td>";
if($hotmail==""){
echo "<img border='0' src='images/icon/msn_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/msn.gif' width='60' height='20' alt='$hotmail'>";
}
echo "</td>
<td> </td>
<td>";
if($yahoo==""){
echo "<img border='0' src='images/icon/yahoo_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/yahoo.gif' width='60' height='20' alt='$yahoo'>";
}
echo "</td>
<td> </td>
<td>";
if($gmail==""){
echo "<img border='0' src='images/icon/gmail_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/gmail.gif' width='60' height='20' alt='$gmail'>";
}
echo "</td>
<td> </td>
<td>";
if($mynet==""){
echo "<img border='0' src='images/icon/mynet_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/mynet.gif' width='60' height='20' alt='$mynet'>";
}
echo "</td>
<td> </td>
<td>";
if($icq==""){
echo "<img border='0' src='images/icon/icq_pass.gif' width='60' height='20'>";
}else{
echo "<img border='0' src='images/icon/icq.gif' width='60' height='20' alt='$icq'>";
}
echo "</td>
</tr>
</table>
<!--mail iconlar-->
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width='2%'> </td>
</tr>
<tr>
<td width='2%' height='5'></td>
<td width='96%' height='5'></td>
<td width='2%' height='5'></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>";
#--Tema Yolu Ayarları-----------------------------------------------------------------------------------------------------------------
@$tema = mysql_query("select * from tema where aktif=1");
@$goster = mysql_fetch_array($tema);
@$renk = $goster['tema'];
#--Tema Yolu Ayarları-----------------------------------------------------------------------------------------------------------------<tr>
echo "<td background='tema/$renk/1.gif' height='1'></td>
</tr>
</table><br>";
} //while
#--sayfalama ve sayaç--------------------------------------------------------------------
echo "<table border='0' width='100%' id='table3' cellpadding='0' style='border-collapse: collapse'><tr><td><table border='1' width='100%' id='table4' bordercolorlight='#E9E9E9' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#E9E9E9'> <tr><td><table border='0' width='100%' id='table7' cellpadding='0' style='border-collapse: collapse'><tr><td width='2%' height='5'></td><td width='96%' height='5'></td><td width='2%' height='5'></td></tr><tr><td width='2%'> </td><td width='96%'><table border='0' width='100%' id='table8' cellpadding='0' style='border-collapse: collapse'><tr><td><table border='1' width='100%' id='table13' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' bordercolordark='#F3F3F3' style='border-collapse: collapse'> <tr><td><table border='1' width='100%' id='table14' bordercolorlight='#F3F3F3' cellspacing='0' cellpadding='0' style='border-collapse: collapse' bordercolordark='#F3F3F3'> <tr><td><table border='0' width='100%' id='table15' cellpadding='0' style='border-collapse: collapse'><tr><td height='20' bgcolor='#F9F9F9' colspan='3' align='center'>";
$birGeri=$sayfa-1;
if($sayfa==1){
echo ("[««][«]");
}else{
echo ("<a href='$page&p=1'><span style='text-decoration: none'>[««]</span></a><a href=\"$page&p=$birGeri\"><span style='text-decoration: none'>[«]</span></a>");
}
echo " ";
for($i; $i<=$sinir; $i++){
if ($sayfa==$i){
echo("<a href=\"$page&p=$i\"><font color='#FF0000'><span style='text-decoration: none'>$i.</span></font></a>");
}else{
echo("<a href=\"$page&p=$i\"><span style='text-decoration: none'>$i.</span></a>");
}
}
echo " ";
$birIleri=$sayfa+1;
if($birIleri==$sinir+1){
echo ("[»][»»] [Toplam: $kac_tane » <font color='#FF0000'>$sayfa.</font> Sayfa]");
}else{
echo ("<a href=\"$page&p=$birIleri\"><span style='text-decoration: none'>[»]</span></a><a href=\"$page&p=$kac_tane\"><span style='text-decoration: none'>[»»]</span></a> [Toplam: $kac_tane » <font color='#FF0000'>$sayfa.</font> Sayfa]");
}
ob_end_flush();
echo "</td></tr><tr><td height='5' width='4%'></td><td height='5' width='1%'></td><td height='5'></td></tr><tr><td width='100%' height='20' bgcolor='#F9F9F9' colspan='3' align='center'>Dün : ";
$baslat =date(Y."-".m."-".d);
$year =substr($baslat, 0,4);
$month =substr($baslat, 5, 2);
$day =substr($baslat, 8, 2);
$bitis =date("Y-m-d", mktime(0, 0, 0, $month, $day-1, $year));
echo "<font size='1'>";
$sorgula = mysql_query("select tarih from ziyaret where tarih='$bitis'");
$dunku = mysql_num_rows($sorgula);
echo $dunku;
echo " | Bugün : ";
$bugun = date("Y-m-d");
$sorgu = mysql_query("select tarih from ziyaret where tarih='$bugun'");
$bugunku = mysql_num_rows($sorgu);
echo $bugunku;
echo " | Online Ziyaretçi : ";
$ip = $_SERVER['REMOTE_ADDR'];
$past = time()-150;
mysql_query("DELETE FROM online WHERE time < $past");
$result = mysql_query("SELECT time FROM online WHERE ip='$ip'");
$time = time();
if($row = mysql_fetch_array($result)){
mysql_query("UPDATE online SET time='$time', ip='$ip' WHERE ip='$ip'");
}else{
mysql_query("INSERT INTO online (ip,time) VALUES ('$ip','$time')") or die(mysql_error());
}
$result = mysql_query("SELECT ip FROM online");
$onlinekac = mysql_num_rows($result);
echo $onlinekac;
echo " | Toplam Ziyaretçi : ";
$ipsi = $_SERVER['REMOTE_ADDR'];
$tarih = date("Y-m-d");
$ipkontrol = mysql_query("select * from ziyaret where ip='$ipsi' order by id desc");
$yaz = mysql_fetch_assoc($ipkontrol);
$vip = $yaz['ip'];
$vtarih= $yaz['tarih'];
$bak = mysql_num_rows($ipkontrol);
if($bak>0){ //if-
if($vtarih<$tarih){
$kayit_1 = mysql_query("insert into ziyaret (ip,tarih) values ('$ipsi','$tarih')");
}
}//if-
else{
$kayit_2 = mysql_query("insert into ziyaret (ip,tarih) values ('$ipsi','$tarih')");
}
$toplamne = mysql_query("select * from ziyaret");
$toplamziyaret = mysql_num_rows($toplamne);
echo $toplamziyaret;
echo " | Onay Bekleyen : ";
$onaysiz = mysql_query("select * from defter where onay=0");
$onaysizsay = mysql_num_rows($onaysiz);
echo $onaysizsay;
echo " | Toplam Mesaj : ";
$topmesaj = mysql_query("select * from defter");
$toplammesaj = mysql_num_rows($topmesaj);
echo $toplammesaj;
echo "</font>";
echo "</td></tr></table></td></tr></table></td></tr></table></td></tr></table><tr><td width='2%' height='5'></td><td width='96%' height='5'></td><td width='2%' height='5'></td></tr></td><td width='2%'></td></tr></table></td></tr></table></td></tr></table>";
#--sayfalama ve sayaç--------------------------------------------------------------------
}else{
echo "<table border='0' width='364' id='table1' cellpadding='0' style='border-collapse: collapse'><tr><td align='center' height='20'></td></tr><tr><td align='center' height='56'><img border='0' src='images/icon/bildiri.gif' width='50' height='56'></td></tr><tr><td align='center' height='40'>Defterde Hiç Kayıtlı Mesaj Yok!</td></tr><tr><td align='center' height='20'></td></tr></table>";
}
?>