• 23-06-2013, 22:31:46
    #1
    arkadaşlar nette bir yorum scripti buldum ve kurdum şimdi ben bunu haber sayfalarıma bağlamak istiyorum yani her haber de habere yapılan yorum gözüksün ...

    Haber sayfam ;
    <?php include('Connections/baglan.php'); ?><?php
    $haberid=intval($_GET["id"]);
    $sqlhaberler="Select * FROM haberler where id='$haberid'";
    $haberler=$dba->query($sqlhaberler);
    @$sonuchaberler= mysql_fetch_array($haberler);
    $totalRows_a = $dba->num_rows($haberler);
    $sqlhaberlerziyaretartir="update haberler set ziyaret=ziyaret+1 where id='$haberid'";
    $dba->query($sqlhaberlerziyaretartir);
    
    ?><?php include("add.php"); ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml"><head><title>
    
    <?php echo @$sonuchaberler['konu']; ?> /Haberler,Duyurular,Önemliler...</title>
    <meta name="keywords" content="<?php echo $sonucilanlar['anahtar']; ?>">
    <meta name="robots" content="index, all" />
    <meta http-equiv="content-Type" content="text/html; charset=iso-8859-9" />
    <meta name="description" content="<?php echo @$sonuchaberler['konu']; ?> <?php echo @$sonuchaberler['aciklama']; ?> <?php echo @$sonuchaberler['baslik']; ?>">
    <meta name="keywords" content="<?php echo @$sonuchaberler['konu']; ?>">
    
    </head>
    <body>
    <meta name="robots" content="index, follow/" />
    
    <link rel="stylesheet" type="text/css" href="style.css" media="screen" />
    
    
    
    </head>
    <body>
    <div id="main_container">
    <?php include "ust.php"; ?>
    <div id="main_content">
    <div class="column444">
    
    
    <div style="float:left"><div width="960px;"  style="float:left">
    <img src="dosya.gif" border="0"> <a href="index.html" style="text-decoration:none"><b>Ana Sayfa</b></a> <img src="dosya.gif" border="0"> <a href="haberler.html" style="text-decoration:none"><b>Haberler</b></a> <img src="dosya.gif" border="0"> <a href="<?php 
    echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;   
    ?>" style="text-decoration:none"><b><?php echo @$sonuchaberler['konu']; ?></b></a>
    
    
    
    </div>
    
    <table style="margin:5px 0px 0px 0px;padding:0px;" width="960px" border="0" cellpadding="0" cellspacing="0" bordercolor="#c3c3c3">
    
    
    
    
    
    
    <tr><td><table width="952px" border="0" cellpadding="0" cellspacing="0">
    
    
    
    
    
    <tr>
    
    <td width="690px" valign='top' aling='left' style="padding:0px;">
    
    <div >
    
    <table align="left" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border-radius:5px;border:1px solid #c3c3c3;padding:0px;">
    <tr><td style="padding:0px;">
    <table><tr width="100%"><td style="padding:0px;">
    <p aling="left" style="padding:0px;"><font color="black" size="5"><font face="Trebuchet MS"><b><?php echo @$sonuchaberler['konu']; ?></b></font></font> - 
    <a href="haberler.html" style="text-decoration: none;"><font style="background-color:red;" size="2" color="white"><b>tüm haberler</b></font></a></p>
    </td></tr><tr width="100%"><td style="background-color:#f1f1f1;border:1px;border-style:solid;border-color:#dddddd;padding:0px;"align="left"><font   color="black">
    <p aling="left" style="padding:0px;"><font size=1><b>Haber Tarihi; <?php echo @$sonuchaberler['tarih']; ?></b></font>  - <font size=2>Bu haber <b><font color="red"><?php echo @$sonuchaberler['ziyaret']+1; ?></font></b></font><font size=2> kere görüntülendi.</font> 
     </p></font>
    
    
    
    
    </td>
    
    </tr>
    
    
    
    <tr width="100%">
    <td style="padding:0px;">
    <div><table>
    <tr>
    
    <td  style="padding:0px;">
    <font size=3><?php echo @$sonuchaberler['baslik']; ?></font>
    </td>
    
    
    </tr></table></div>
    
    
    <table style="margin: 0pt 5px 5px 0pt; float: left;">
    <tr><td style="padding:0px;">
    <?php if ( empty($sonuchaberler['resim'])) { echo " <img src='noimage.gif' border='0' style='max-width:280px;'>"; } else { echo "<img src='admin/photo/$sonuchaberler[resim]'  style='max-width:280px;' >"; } ?>
    <br>
    <div style="margin: 0pt 5px 5px 0pt; float: left;background-color:#f1f1f1;border:1px;border-style:solid;border-color:#dddddd;width:280px;">
    
    
       <a href="http://www.facebook.com/sharer.php?u=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="facebook.png" border="0" alt="Paylaş!"></a>
       <a href="http://twitter.com/home?status=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="twitter.png" border="0"  alt="Paylaş!"></a>
       <a href="http://www.google.com/bookmarks/mark?op=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="faviconr.png" border="0"  alt="Paylaş!"></a>
       <a href="http://friendfeed.com/?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="internal.png" border="0"  alt="Paylaş!"></a>
       <a href="http://www.linkedin.com/shareArticle?mini=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="in.png" border="0"  alt="Paylaş!"></a>
       <a href="http://del.icio.us/post?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="delicious.png" border="0"  alt="Paylaş!"></a>
       <a href="http://digg.com/submit?phase=2&amp;amp;url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="digg.png" border="0"  alt="Paylaş!"></a>
       <a href="http://myweb2.search.yahoo.com/myresults/bookmarklet?u=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="yahoo.png" border="0"  alt="Paylaş!"></a>
       <a href="http://www.google.com/bookmarks/mark?op=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="google-share.png" border="0"  alt="Paylaş!"></a>
       <a href="http://meneame.net/submit.php?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="live-spice.png" border="0"  alt="Paylaş!"></a>
       <a href="http://reddit.com/submit?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="myspace.png" border="0"  alt="Paylaş!"></a>
       <a href="http://www.technorati.com/faves?add=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="technorati.png" border="0"  alt="Paylaş!"></a>
       <a href="http://www.stumbleupon.com/submit?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank" style="text-decoration: none;"><img src="sss.gif" border="0"  alt="Paylaş!"></a>
    </div>
    <br><br>
    
    <div style="margin: 0pt 0px 0px 0pt; float: left;background-color:#ffffff;border:1px;border-style:solid;border-color:#dddddd;width:280px;">
    <p  style="height:20px;background-color:#fa8407;" aling="left"><font  color="#ffffff" face="Trebuchet MS" size="3"><b>En Çok Okunan Haberler ;</b></font></p>
    
    <?php 
    		  
                      $Recordset1f=$dba->query("SELECT * FROM haberler ORDER BY haberler.ziyaret DESC limit 5");
    		  while($row_Recordset1f=$dba->fetch_assoc($Recordset1f)){
    		  $basliks=permayap($row_Recordset1f["konu"]);$idsis=$row_Recordset1f['id'];?>
    
    
    <table><tr>
    
    
    
    
    
    <td  align="left" style="padding:0px;">
    
    
    
    <div class="productImageWrap" id="productImageWrapID_<?php echo @$row_Recordset1f['id']; ?>">
    <?php if ( empty($row_Recordset1f['resim'])) { echo " <img src='noimage.gif' border='0' style='max-width:80px;'>"; } else { echo "<img src='admin/photo/$row_Recordset1f[resim]'  style='max-width:80px;' >"; } ?>
    <br><?php echo "<a href=$basliks-haber_detayi$idsis.html class=sub_lnk style='text-decoration:none;' target='_blank' onmouseover=\"Tip('İlan Numarası :$idsis<br>$row_Recordset1f[konu]',SHADOW,true,BGCOLOR,'#ffffff',FADEIN,400,FADEOUT,600,SHADOWCOLOR,'#000000',BORDERCOLOR,'#000000',OPACITY,190,FONTCOLOR,'#000000')\">";?>
    </div>
    </td>
    
    <td style="padding:0px;">
    <?php echo "<a href=$basliks-haber_detayi$idsis.html style='text-decoration: none;' class=sub_lnk target='_blank'>";?>
    
    
    <p aling="left" style="padding:0px;">
    
    <font size=1><font color=darkblue>-<b>Okunma <font color=red>(<?php echo @$row_Recordset1f['ziyaret']; ?>)</font></b></font></font> 
    
    <br>- <font size=1><font color=black><?php
    $detay = $row_Recordset1f['konu'];
    $uzunluk = strlen($detay);
    $limit = 500;
    if ($uzunluk > $limit) {
    $detay = substr($detay,0,$limit) . "...";
    }
    echo $detay;?></font></font>
    
    
    
    
    </p></td>
    
    
    </td></tr></table>
    
    
       <?php } ?></div>
    
    </td></tr></table>
    <?php echo @$sonuchaberler['aciklama']; ?>
    <div>
    <?php echo $sonucilanlar['burkay']; ?><br>
    <p aling="left" style="background-color:#f9f9f9;">
    
    <font size="5"><font color="#ed1c24"><font face="Trebuchet MS">Paylaş;</font></font></font><br>
       <img src="facebook.png" border="0"> <a href="http://www.facebook.com/sharer.php?u=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Facebook</a>
       <img src="twitter.png" border="0"> <a href="http://twitter.com/home?status=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Twitter</a>
       <img src="faviconr.png" border="0"> <a href="http://www.google.com/bookmarks/mark?op=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Google+</a>
       <img src="internal.png" border="0"> <a href="http://friendfeed.com/?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Friendfeed</a>
       <img src="in.png" border="0"> <a href="http://www.linkedin.com/shareArticle?mini=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Linkedin</a>
       <img src="delicious.png" border="0"> <a href="http://del.icio.us/post?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Delicous</a>
       <img src="digg.png" border="0"> <a href="http://digg.com/submit?phase=2&amp;amp;url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Digg</a>
       <img src="yahoo.png" border="0"> <a href="http://myweb2.search.yahoo.com/myresults/bookmarklet?u=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Yahoo</a>
       <img src="google-share.png" border="0"> <a href="http://www.google.com/bookmarks/mark?op=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Google</a>
       <img src="live-spice.png" border="0"> <a href="http://meneame.net/submit.php?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Live Space</a>
       <img src="myspace.png" border="0"> <a href="http://reddit.com/submit?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">MySpace</a>
       <img src="technorati.png" border="0"> <a href="http://www.technorati.com/faves?add=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Technorati</a>
       <img src="sss.gif" border="0"> <a href="http://www.stumbleupon.com/submit?url=<?php echo 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'] ;  ?>" target="_blank">Stumble</a>
    
    </p>
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    </div>
    </td>
    </tr>
    </table></td></tr></table>
    
    </div>
    <table><tr><td valign="top" style="padding:0px;">
    <table align="left" cellpadding="0" cellspacing="0" style="width:440px;margin-top:5px;margin-bottom:8px;background-color:#ffffff;border-radius:5px;border:1px solid #c3c3c3;padding:0px;">
    <tr><td style="padding:0px;">
    
    <p  style="height:20px;background-color:#ed1c24;" aling="left"><font  color="#ffffff" face="Trebuchet MS" size="3"><b>Editörün Seçtikleri ;</b></font> </p>
    
    
    
    <?php 
    		 $Recordset1f=$dba->query("SELECT * FROM haberler  WHERE haberler.vitrin ORDER BY haberler.id DESC  limit 10");
    		  while($row_Recordset1f=$dba->fetch_assoc($Recordset1f)){
    		  $basliks=permayap($row_Recordset1f["konu"]);$idsis=$row_Recordset1f['id'];?>
    
    <div  style="border:1px; border-style: dotted;  border-color:#cccccc; width:210px; height:180px; float:left; background:#ffffff url(aramaana.png) repeat-x; padding:0px 0px 0px 0px;margin:1.5px;border-radius:3px;">
    
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
    
    <tr>
    <td  align="left" style="padding:0px;">
    
    
    
    <div class="productImageWrap" id="productImageWrapID_<?php echo @$row_Recordset1f['id']; ?>">
    <?php if ($row_Recordset1f['resim'] =='noimage.gif') { echo "<img src=noimage.gif style='max-width:210px;max-height:150px;'></a>"; } else { echo "<a href=$basliks-haber_detayi$idsis.html class=sub_lnk target='_blank'><img src=admin/photo/$row_Recordset1f[resim] style='max-width:210px;max-height:150px;' border='0'></a>"; } ?>
    <br><?php echo "<a href=$basliks-haber_detayi$idsis.html class=sub_lnk style='text-decoration:none;' target='_blank' onmouseover=\"Tip('İlan Numarası :$idsis<br>$row_Recordset1f[konu]',SHADOW,true,BGCOLOR,'#ffffff',FADEIN,400,FADEOUT,600,SHADOWCOLOR,'#000000',BORDERCOLOR,'#000000',OPACITY,190,FONTCOLOR,'#000000')\">";?>
    
    
    
    <?php echo "<a href=$basliks-haber_detayi$idsis.html class=sub_lnk style='text-decoration:none;' target='_blank' onmouseover=\"Tip('İlan Numarası :$idsis<br>$row_Recordset1f[konu]',SHADOW,true,BGCOLOR,'#ffffff',FADEIN,400,FADEOUT,600,SHADOWCOLOR,'#000000',BORDERCOLOR,'#000000',OPACITY,190,FONTCOLOR,'#000000')\">";?>
    <span class="style4"><font color="black" size="2"><b><?php echo "$row_Recordset1f[konu]";?></b></font>
    
    <br>
    <font size=1><font color="darkblue">-<b>Okunma</b></font> <b><font color="red">(<?php echo @$row_Recordset1f['ziyaret']; ?>)</font></b></font> 
    
    
    
    </span>
    
    
    
    </div>
    
    
    </td>
    
    
    </tr></table>   </div>  
                    <?php } ?>
    
    
    
    
    
    
    
    
    </td></tr></table>
    
    
    
    
    </td><td valign="top"syle="padding:0px;" >
    
    
    
    
    <table style="width:235px;padding:0px;margin-bottom:8px;background-color:#fdfdfd;border-radius:5px;border:1px solid #c3c3c3;padding:0px;"  cellpadding="0" cellspacing="0" >
    <tr><td style="padding:0px;">
    <p  style="height:20px;background-color:#1c214b;margin-bottom:5px;border-radius:3px;" aling="left"><font  color="#ffffff" face="Trebuchet MS" size="3"><b>Son Eklenen Gayrimenkuller ;</b></font> </p>
    
    
    
    <?php 
    		 $Recordset1f=$dba->query("SELECT * FROM ilanlar left join resimler on (resimler.id = ilanlar.id) WHERE ilanlar.durum=0 or ilanlar.durum=7 ORDER BY ilanlar.id DESC limit 12");
    		  while($row_Recordset1f=$dba->fetch_assoc($Recordset1f)){
    		  $basliks=permayap($row_Recordset1f["baslik"]);$idsis=$row_Recordset1f['id'];?><script>var miniGalleryOptions<?php echo $idsis;?>f={thumbnailId:'thumb<?php echo $idsis;?>f',slideshowGroup:'group<?php echo $idsis;?>f',numberPosition:'caption'};</script>
    
    <div style="border:1px; border-style: dotted;  border-color:#cccccc;border-bottom:3px #F74949 solid; width:110px; height:150px; float:left;background:#ffffff url(aramaana.png) repeat-x; padding:0px 0px 0px 0px;margin:1.5px;border-radius:3px;">
    <table width="100%" border="0" cellpadding="0" cellspacing="0" style="padding:0px 0px 0px 0px;">
    <tr>
    <td style="padding:0px;">
    <div class="productImageWrap" id="productImageWrapID_<?php echo @$row_Recordset1f['id']; ?>">
    <?php if ($row_Recordset1f['resim'] =='noimage.gif') { echo "<img src=noimage.gif style='max-width:110px;max-height:100px;'></a>"; } else { echo "<a href='$basliks-ilan_detayi$idsis.html' target='_blank' onmouseover=\"Tip('İlan Numarası :$idsis<br>$row_Recordset1f[baslik]',SHADOW,true,BGCOLOR,'#ffffff',FADEIN,400,FADEOUT,600,SHADOWCOLOR,'#000000',BORDERCOLOR,'#000000',OPACITY,190,FONTCOLOR,'#000000')\"><img src=admin/photo/$row_Recordset1f[resim]  style='max-width:110px;max-height:100px;' border='0'></a>"; } ?>
    
    
    <div align="left" >
    <?php echo "<a href=$basliks-ilan_detayi$idsis.html style='text-decoration:none;' class='sub_lnk' target='_blank' onmouseover=\"Tip('İlan Numarası :$idsis<br>$row_Recordset1f[baslik]',SHADOW,true,BGCOLOR,'#ffffff',FADEIN,400,FADEOUT,600,SHADOWCOLOR,'#000000',BORDERCOLOR,'#000000',OPACITY,190,FONTCOLOR,'#000000')\">";?>
    
    
    
    <font size=1><font color=#E62727><b><?php
    $detay = $row_Recordset1f['baslik'];
    $uzunluk = strlen($detay);
    $limit = 30;
    if ($uzunluk > $limit) {
    $detay = substr($detay,0,$limit) . "...";
    }
    echo $detay;?></b></font></font>
    
    <br>
    <font color=red><font size=2><b><?php echo $row_Recordset1f['fiyat']; ?></b></font></font><?php echo $row_Recordset1f['fiyatbirim']; ?>
    <br><font size=1><font color=#333333>-İlan No: <b><?php echo $row_Recordset1f['id']; ?></b></font>
    
    </div></div> 
    </td></tr></table>  
             </div> 
    
    <?php } ?>
    
    
    
    
    
    
    
    
    
    
    </td></tr>
    
    </table>
    
    
    
    
    
    
    </td></tr></table>
    
    
    
    
    
    <font size="1"  color="#ed1c24"> Dikkatinizi Çekebileceker ; Editörler Tarafın Derlenen Haberler,Duyurular,Bilgi Bankaları, Manşetler...</font>
    
    
    
    <table style="width:686px;border:1px solid #dddddd;box-shadow: 0px 0px 2px #e5e5e5;border:1px solid #e8e8e8;background:#f7f7f7 url(tre.png) repeat-x;" align="left" border="0" cellpadding="0" cellspacing="0"><tr>
    <td style="padding:0px;" align="left"><div align="left"><a href="http://files.appsgeyser.com/VERi%20EMLAK%20Mobil.apk" style="text-decoration: none;"><img src="mobil/android.png"border="0"/></a></div></td>
    
    <td style="padding:0px;" align="left"><div align="left"><a href="mobil/index.php" style="text-decoration: none;"><font size="3" color="red">
    <b>Mobil</b></font><br><font size="1" color="black">Mobile Web</font></a></div></td>
    
    </tr></table>
    
    </td>
    
    
    <td valign="top" width="250px" style="padding:0px 0px 0px 3px;">
     
    
    
    
    <div class="yantaraf" style="margin-bottom:5px;">
    
    <center>
    
    
    
    
    <table style="box-shadow: 0px 0px 2px #e5e5e5;margin-top:0px;width:255px;border:1px solid #e8e8e8;background:#ffffff url(aramaana.png) repeat-x;"  border="0" cellpadding="0" cellspacing="0" ><tr >
    
    <tr><style>.aramaarkaci  {
    
    width:240px;
    
        
    border:0px; border-radius:0px; border-style: solid;  border-color:#333333;
    background-color:#ffffff;}
    </style>
    <td valign="top"  align="center" style="padding:0px;"><p style="width:250px;height:18px;background-color:#FF6262;padding:0px 0px 5px 5px;"  align="left"><font color=#ffffff><font size="3" face="Trebuchet MS"><b>Gayrimenkul Arama;</b></font></font></p
    
    
    
    <div   class="aramaarkaci">
    <div width="234px" class="form">
    <form action="hizliarama.html" method="get" name="formu" target="_self" id="formu">
    <center><table><tr><td style="padding:0px;">
    <b><p aling=right>
    <font color=black>İl :</font></p></b></td><td style="padding:0px;">
    <select name="il" class="form1">
    <option></option></select></td></tr><tr>
    <td style="padding:0px;">
    <b><p aling=right>
    <font color=black>İlçe :</font></p></b> </td><td style="padding:0px;">
    <span style="text-align:left">
    <select name="ilce" class="form1"><option></option></select></span></td></tr><tr>
    <td style="padding:0px;">
    <b><p aling=right>
    <font color=black>Semt :</font></p></b></td><td style="padding:0px;">
    <select name="semt" class="form1"><option></option></select></td></tr>
    
    <script type="text/javascript">mformu=new Form('formu');adres_3=mformu.adres('','il','ilce','semt');adres_3.secim='evet';adres_3.getir('','','','');</script>
    <tr><td style="padding:0px;">
    <b><p aling=right>
    <font color=black>İlan Tipi:</font></p></b></td><td style="padding:0px;">
    <select name="tip" class="form1" id="tip" onchange="firmabilgileri(this.form)"><option value="">Emlak Tipi</option> <option value="3">Arsa</option> <option value="1">Konut</option> <option value="2">İşyeri</option> </select>
    </td></tr><tr><td style="padding:0px;">
    <b><p aling=right>
    <font color=black>İlan Türü:</font></p></b></td><td style="padding:0px;">
    <select name="arass" class="form1" id="select4"><option value="">Emlak Durumu</option> 
    <option value="7">Kiralık</option> <option value="0">Satılık</option> </select></td></tr>
    </table></center>
    
    
    <br><input name="image22" type="image" src="images/arabuton.png" border="0" style="border:solid #3082BB 0px" /></form>
    <a href="detayliarama.html"><font size="1" color="#6e6e6e">Detaylı Arama</font></a><br>
    
    <br><center><div id="aramaFormu">
    <font size=1>
    <form action="siteiciarama.html" method="get" name="er" target="_parent" id="er" enctype="multipart/form-data" onsubmit="return ase()">
    <input type="text" name="id" value="İLAN NUMARASI - REF NO"  onfocus="this.value=''" onkeydown="sayiMi()" /> 
    <button type="submit"></button></form>
    </font>
    </div></center>
    
    <a href="satiliklar.html?islem=konutsatilik"><font size=1><font color=#6e6e6e>Satılık Konut</font></font></a> | 
    <a href="satiliklar.html?islem=isyerisatilik"><font size=1><font color=#6e6e6e>Satılık İşyeri</font></font></a> | 
    <a href="satiliklar.html?islem=arsasatilik"><font size=1><font color=#6e6e6e>Satılık Arsa</font></font></a><br>
    <a href="kiraliklar.html?islem=konutkiralik"><font size=1><font color=#6e6e6e>Kiralık Konut</font></font></a> | 
    <a href="kiraliklar.html?islem=isyerikiralik"><font size=1><font color=#6e6e6e>Kiralık İşyeri</font></font></a> | 
    <a href="kiraliklar.html?islem=arsakiralik"><font size=1><font color=#6e6e6e>Kiralık Arsa</font></font></a> | 
    <br><a href="javascript:void(0);" onclick="return hs.htmlExpand(this,{src:'site_ici_arama.php',objectType:'iframe',width:800,height:670,wrapperClassName:'draggable-header',outlineType:'rounded-white',headingText:'<div style=margin-left:300px;>Site içi Arama</div>',objectLoadTime:'after'})"><font size=1><font color="#6e6e6e">Kelime,Portföy Numarası,Açıklama Detayına Göre Hızlı Arama...</font></font></a></div></div></td></tr></table>
    </center>
    
    </div>
    
    
    
    
    
    <a href="ofislerimiz.html"><font size="5" color="darkblue">Ofisler</b></font></a>
    
    
    
    <div class="yantaraf" style="margin-bottom:5px;">
    <table style="box-shadow: 0px 0px 2px #e5e5e5;padding-top:10px 0px 0px 0px;width:257px;border:1px solid #e8e8e8;background:#f7f7f7 url(tre.png) repeat-x;"  border="0" cellpadding="0" cellspacing="0" ><tr >
    
    
    <td valign="top"  align="center" style="padding:0px;text-align:center;">
    <p  style="width:252px;background-color:#7092be;" align="center"><a href="haberler.html" style="text-decoration: none;"><font color=white><b><font size=1> >> Tüm Haberler</font></b></font></a></p>
        <font size=4><img src="admin/img/folder.gif" border="0">SON <b><font color=red>HABER</font></b>LER</font> 
            <div class="form"><table width="100%" border="0" cellpadding="0" cellspacing="0" style="border-style:none">
    <tr>
    <td style="padding:0px;" colspan="0" align="left" valign="top">
    <?php $say=0; $sqlhaberler="select * from haberler  order by id desc limit 0,15"; $sonuchaberler=$dba->query($sqlhaberler); while (@$haberler=$dba->fetch_array($sonuchaberler)) { $say++; ?>
    <div align="left" class="style60" id="baslik<?php echo $say; ?>" <?php if ($say>1) { echo "style=display:none"; } ?>> <?php $hbaslik=permayap($haberler['konu']);$hid=$haberler['id'];?>
    
    </div><?php } ?></td></tr>
    <tr><td  style="padding:0px;" width="100%"><?php $say=0; @mysql_data_seek($sonuchaberler,0); while (@$haberler=$dba->fetch_array($sonuchaberler)) {$hbaslik=permayap($haberler['konu']);$hid=$haberler['id']; $say++; ?>
    
    <div align="center" id="hresim<?php echo $say; ?>" <?php if ($say>1) { echo "style=display:none"; } ?>> 
    <a href="<?php echo "$hbaslik-haber_detayi$hid.html" ?>" target="blank_" style="text-decoration: none;">
    <script language="javascript" type="text/javascript">q=document;ob=true;function show(sayi,degisen){for(var a=1;a<=sayi;a++){baslikid='baslik'+a;q.getElementById(baslikid).style.display='none';resimid='hresim'+a;q.getElementById(resimid).style.display='none'}baslikid='baslik'+degisen;q.getElementById(baslikid).style.display='block';resimid='hresim'+degisen;q.getElementById(resimid).style.display='block'}function sayiMi(){var N=event.keyCode;if((((N==9)||(N==8))||((N==46)||(N==111)))||(((N>95&&N<106)||(N>47&&N<58))||((N>95&&N<106)||(N>32&&N<40)))){event.returnValue=ob}else event.returnValue=false}</script>
    <center><p  style="width:252px;background-color:#4b4b4b;" ><?php if ( empty($haberler['resim'])) { echo "<img src=noimage.gif style='max-width:252px;' border=0>"; } else { echo "<img src='admin/photo/$haberler[resim]' border='0' style='max-width:252px;' >"; } ?></p></center></a></div>
    <?php } ?>
    <table width="100%" height="77" border="0" cellpadding="0" cellspacing="0" bordercolor="f9f9f9"><?php $bu=0; @mysql_data_seek($sonuchaberler,0); while (@$haberler=$dba->fetch_array($sonuchaberler)) {$hbaslik=permayap($haberler['konu']);$hid=$haberler['id']; $bu++; ?><tr><td style="padding:0px;"  valign="middle" <?php if ($bu %0==0) { echo ""; } ?>><div align="left">
    
    <a href="<?php echo "$hbaslik-haber_detayi$hid.html" ?>" target="blank_" style="text-decoration: none;" onmouseover="show(<?php echo @$say; ?>,<?php echo @$bu; ?>)"><img src="hbr.png" width="10" height="10" border="0"> <b><?php echo substr(@$haberler['konu'],0,40); ?></b></a></div></td></tr><?php } ?></table></td></tr></table></div>
    </td></tr></table></div>
    
    <div class="yantaraf" >
    <center><a href="haberci.html"><font size="5" color="red">+Haberdar Et</b></font></a> 
    <a href="talepgonder.html"><font size="5" color="darkblue">Gayrimenkulum Var!,<b>Gayrimenkul Arıyorum...</b></font></a>
    </center>
     </div>
    <div class="left_box"><div class="top_left_box"></div><div class="center_left_box"><div class="box_title"><span>Ankete Katıl !</span></div> 
          <?php include_once('anket.php');?></div><div class="bottom_left_box"></div></div>
    </div>
    
    
    
    
    
    <div class="yantaraf"><table style="box-shadow: 0px 0px 2px #e5e5e5;margin-top:0px;width:255px;border:1px solid #e8e8e8;background:#ffffff url(aramaana.png) repeat-x;"  border="0" cellpadding="0" cellspacing="0" ><tr >
    <tr><td><iframe frameborder="0" width="100%" height="165" scrolling="No" src="/Mail/uyeol.php" ></iframe>
    </td></tr></table></div></div>
    
    
    
    
    
    
    
    
    
    
    
    
    
    </td>
    
    </tr>
    </table></td></tr></table>
    
      
    </div></div><div id="footer"><div id="copyright"><div style="float:left;padding:3px"><a href="index.html"><img src="images/footer_logo.gif" width="42" height="35" alt="" title="" border="0" /></a></div> <div style="float:left;padding:14px 10px 10px 10px"><span class="right"><?php include "footer.php"; ?></span></div></div></div></div></body></html>

    yorumekle.php sayfam
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
    <head>
    	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
    		<style type="text/css">
    		body{margin:0; padding:0; font:12px tahoma; background-color:lightgray;}
    		.uyari{border:1px solid #ccc; border-radius:3px; padding:5px; margin:5px;}
    		#geneldiv{background-color:#fff; padding:2px; margin:10px; width:70%; margin-right:auto; margin-left:auto; border-radius:3px;}
    		a{text-decoration:none; color:gray;}
    		a:hover{color:red;}
    	</style>
    	<title></title>
    </head>
    <body>
    <div id="geneldiv">
    <div align="center">	
    <form action="" method="post">
    			<table align="center">
    				<tr>
    					<td>Ekleyen</td>
    					<td><input type="text" name="ekleyen" /></td>
    				</tr>
    				<tr>
    					<td>E-Mail</td>
    					<td><input type="text" name="email" /></td>
    				</tr>
    				<tr>
    					<td>Yorumunuz</td>
    					<td><textarea name="yorum"></textarea></td>
    				</tr>
    				<tr>
    					<td colspan="2"><input type="submit" value="Yorumu Ekle" /></td>
    				</tr>
    			</table>
    	</form>
    	
    	<?php
    			include "baglan.php";
    			
    			if($_POST){
    			
    					$ekleyen=$_POST["ekleyen"];
    					$email=$_POST["email"];
    					$yorum=mysql_real_escape_string($_POST["yorum"]);
    				
    				if(!$ekleyen|| !$email ||!$yorum){
    				
    					echo "<div class='uyari'align='center' style='color:red'>Tüm Alanları Eksiksiz Doldurunuz !</div>";
    				
    				}else{
    				
    				$query=mysql_query("INSERT INTO yorumlar
    					(ekleyen,email,yorum,onay)values('$ekleyen','$email','$yorum','0')
    				");
    				if($query){
    					echo "<div class='uyari'align='center'>Yorum Başarıyla Eklendi. Admin Onay Sürecindedir <a href='index.php'>Geri Dön</a></div>";
    				}else{
    					echo "<div class='uyari'align='center'>Yorum Eklenirken Bir Sorun Oluştu !</div>";
    				}
    				
    				}
    			}
    	?>
    	</div>
    </body>
    </html>

    mesaja sığmadığı için ikinci bir mesajla devamı aşağıda
  • 23-06-2013, 22:32:40
    #2
    ve yorumların listelendiği index.php sayfam ben biraz yapma çalıştım join ile ama olmadı yorumlar yapılıyor ama gözükmüyor yapılan sayfada.
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
    <head>
    	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
    	<style type="text/css">
    		body{margin:0; padding:0; font:12px tahoma; background-color:lightgray;}
    		.uyari{border:1px solid #ccc; border-radius:3px; padding:5px; margin:5px;}
    		#geneldiv{background-color:#fff; padding:2px; margin:10px; width:70%; margin-right:auto; margin-left:auto; border-radius:3px;}
    		a{text-decoration:none; color:gray;}
    		a:hover{color:red;}
    		table tr td{padding:2px}
    		.yorumdiv{border:1px solid #ccc; border-radius:3px; padding:5px; margin:5px;width:600px; margin-right:auto; margin-left:auto;}
    	</style>
    	<title></title>
    	
    </head>
    <body>
    <div id="geneldiv">
    
    <div align="center">
    
     </div>
    	<?php
    		include "baglan.php";
    		
    		$query=mysql_query("Select * from yorumlar left join haberler on (y_id=haberid) where onay='1' order by haberid desc");
    		if(mysql_affected_rows()){
    			while($row=mysql_fetch_array($query)){
    				$ekleyen=$row["ekleyen"];
    				$yorum=$row["yorum"];
    				$email=$row["email"];
    				$tarih=$row["tarih"];
    				echo"<div class='yorumdiv' align='center'>
    					<table cellpaddin='0' cellspacing='0' width='500'>
    						<tr>
    							<td><font color='red'><b>$ekleyen</b></font></td>
    							<td></td>
    							<td><font color='red'>$email</font></td>
    						</tr>
    						<tr>
    							<td colspan='3' align='left'><font color='#bbb'>$tarih</font></td>
    						</tr>
    						<tr>
    							<td colspan='3'>$yorum</td>
    						</tr>
    					</table>
    				</div>";
    			}
    		}else{
    			echo "<div class='uyari' align='center'>Hiç Yorum Eklenmemiş</div>" ;
    		}
    	?>
    	</div>
    </body>
    </html>

    yardımlarınız için şimdiden teşekkür ederim