• 29-07-2010, 18:14:06
    #1
    author_article_detail.php Dosyasında bi hata var sanırım yazarların yazdıkları boş çıkıyor bu sorunu nasıl giderebiliriz gönüllü arkadaşlar varsa PM atabilirmi

    çok acil lütfen
  • 29-07-2010, 18:32:19
    #2
    Kodları paylaşta görelim hatayı bulup ona göre yorumlayalım
  • 29-07-2010, 19:50:55
    #3
    <?php
    
    //
    // +---------------------------------------------------------------------------+
    // | NizipRehber Haber Portalı v1.0 [ nrnews_v1.0 ]                            |
    // +---------------------------------------------------------------------------+
    // |                                                                           |
    // | Gereksininimleri   : PHP 4 veya üzeri, GD2+ kütüphanesi                   |
    // |                                                                           |
    // +---------------------------------------------------------------------------+
    // |                                                                           |
    // | Geliştirici    	: Mahmut ÖZDEMİR                                       |
    // | E-posta        	: mahmuttt88 {at} yahoo {dot} com                      |
    // | Web adresi     	: http://www.mahmutozdemir.org/       	               |
    // | Tel		     	: +90 5373622826 / +90 5457604888 / +90 5543184701     |
    // |                                                                           |
    // +---------------------------------------------------------------------------+
    // |                                                                           |
    // | Copyright (C) 2007                                                        |
    // |                                                                           |
    // | Bu Yazılım ÜCRETSİZ DEĞİLDİR. Yazılımın Tüm Hakları Mahmut ÖZDEMİR'e      |
    // | aittir.															       |
    // |                                                                           |
    // +---------------------------------------------------------------------------+
    //
    			
    			//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    			//~~~~~~~~~~~~~ Üst Çağırılıyor ~~~~~~~~~~//
    			//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    		
    			include("header.php");
    		?>
    		
    		<?php
    	
    			//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    			//~~~~~~~~~~~~~ Yazı Sorgusu ~~~~~~~~~~~~~//
    			//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    		
    			$article_id = intval($_GET['article_id']);
    	
    			$db->write_query("UPDATE articles set hits = hits + 1 where article_id = $article_id");
    			
    			$query = $db->read_query("
    									SELECT article.title, article.article, article.date, article.author_id,
    									article.hits, author.name, author.image, author.email
    									FROM articles as article, authors as author
    									WHERE article.author_id = author.author_id
    									AND article.active = 'Y'
    									AND article.article_id = $article_id
    									") or die($db->sql_error());
    									
    			$articleDetail = $db->sql_fetcharray($query);
    	
    		?>
    		<table class="body" width="770" border="0" align="center" cellpadding="0" cellspacing="0">
    		  <tr>
    			<td class="leftright">
    			  <table width="770" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td width="120" valign="top"  style="background:#EFEFEF;">
    				  <?php
    				  include("left.php");
    				  ?>
    				  </td>
                      <td width="490" valign="top" class="centerColumn">
    				 <!-- Orta Kısım -->
    				<div id="font_tools">
    					  <div class="tools">
    					<div class="fonts">
    						Karakter boyutu :
    						<img style="cursor: pointer;" src="images/font_01.gif" align="absmiddle" onClick="return changeSize('text_detail', '12', 'content')" alt="12 Punto"/>
    						<img style="cursor: pointer;" src="images/font_02.gif" align="absmiddle" onClick="return changeSize('text_detail', '14', 'content')" alt="14 Punto"/>
    						<img style="cursor: pointer;" src="images/font_03.gif" align="absmiddle" onClick="return changeSize('text_detail', '16', 'content')" alt="16 Punto"/>
    						<img style="cursor: pointer;" src="images/font_04.gif" align="absmiddle" onClick="return changeSize('text_detail', '18', 'content')" alt="18 Punto"/>
    					</div>
    					<div class="goback"><img src="images/back_red.gif" align="absmiddle" /> <a href="./index.php">Ana sayfaya Dön</a></div>
    			
    				</div></div>
    				<table width="100%" border="0" cellspacing="3" cellpadding="0">
    					<tr>
    					  <td>
    					  <div id="article_detail">
    					  	<div class="author_image">
    							<div><img src="images/authors/<?=$articleDetail[image]?>" width="150" height="170" /></div>
    							<div class="about"><b><?=stripslashes($articleDetail[name])?></b></div>
    							<div class="about"><?=stripslashes($articleDetail[email])?></div>
    						</div>
    						<div class="title"><?=stripslashes($articleDetail[title])?></div>
    						<div class="br1pxdot"><img src="images/spacer.gif" /></div>
    						<div class="date"><?php echo time_to_now($articleDetail[date]);?></div>
    						<div class="br1pxdot"><img src="images/spacer.gif" /></div>
    						<div class="detail content_12" id="text_detail"><?=stripslashes($articleDetail[article])?></div>
    						<div class="read_count">Bu yazı toplam <?=$articleDetail[hits]?> defa okundu.</div>
    					  </div>
    					  <script type="text/javascript">changeTarget(document.getElementById("text_detail"))</script>
    					  </td>
    					</tr>
    					<tr>
    					  <td>
    					  <select style="width:100%; font: 100 12px Arial, Helvetica, sans-serif; color:#666666"  onchange="return changeArticle(this.value);">
    					  	<option>-- Yazara Ait Diğer Köşe Yazıları --</option>
    					  	<?php
    						$query = $db->read_query("
    													SELECT article_id, title, date
    													FROM articles
    													WHERE author_id = '$articleDetail[author_id]'
    													AND article_id <> $article_id
    													AND active = 'Y'
    													ORDER BY date DESC
    													") or die($db->sql_error());
    						
    						while($row = $db->sql_fetcharray($query)){
    						?>
    					  	<option value="<?=$row[article_id]?>"><?=date("d.m.Y",$row[date])?> - <?=stripslashes($row[title])?></option>
    						<?php
    						}
    						?>
    					  </select></td>
    					</tr>
    					<tr>
    					  <td>
    					  <!-- Ara Çizgiler -->
    						<div class="center_line"><img src="images/spacer.gif" height="5" /></div>
    						
    						<!-- Yazı Araçları -->
    						<div id="textTools">
    							<div class="item"><img src="images/comment_add.gif" align="absmiddle" /> <a href="javascrit:;" onClick="return openPopUp_520x390('comment_add.php?id=<?=$article_id?>&type=article','');">Yorum Ekle</a> </div>
    							<div class="item"><img src="images/print.gif" align="absmiddle" /> <a target="_blank" href="article_print.php?article_id=<?=$article_id?>">Yazdır </a></div>
    							<div class="item"><img src="images/up.gif" align="absmiddle" /> <a href="#top">Yukarı Çık</a> </div>
    						</div>
    						
    						<!-- Ara Çizgiler -->
    						<div class="center_line"><img src="images/spacer.gif" height="5" /></div>
    						</td>
    				    </tr>
    					<?php
    					
    					$query = $db->write_query("
    												SELECT name, title, comment, date
    												FROM comments
    												WHERE id = $article_id
    												AND type = 'article'
    												AND active = 'Y'
    												ORDER BY date DESC
    												") or die($db->sql_error());
    												
    					$total_comments = $db->sql_numrows($query);
    					
    					if(!$total_comments){
    					
    					echo "<tr><td>Bu Yazıya Henüz Yorum Eklenmemiş.</td></tr>";
    					
    					}
    					
    					$query = $db->read_query("
    												SELECT name, title, comment, date
    												FROM comments
    												WHERE id = $article_id
    												AND type = 'article'
    												AND active = 'Y'
    												ORDER BY date DESC
    												LIMIT 3
    												") or die($db->sql_error());
    												
    					while($row = $db->sql_fetcharray($query)){
    					?>
    					<tr>
    					  <td id="comments">
    					  <div class="comment">
    						<div class="name"><?php echo stripslashes($row[name]);?></div>
    						<div class="title"><?php echo stripslashes($row[title]);?></div>
    						<div class="comment"><?php echo stripslashes($row[comment]);?></div>
    						<div class="date"><?php echo time_to_now($row[date]);?></div>
    					</div></td>
    					</tr>
    					<?php
    					}
    					if($total_comments>3){
    					?>
    					<tr id="comments">
    					  <td class="allComments"><a href="javascript:;" onclick="return openPopUp_520x390('comments.php?id=<?=$article_id?>&type=article','');">Tüm Yorumları Göster(<?=$total_comments?>)</a></td>
    				  </tr>
    				  <?php
    					}
    					?>
    				  </table>
    				  <!-- //Orta Kısım -->
    				  </td>
                      <td width="150" valign="top" style="background:#EFEFEF;">
    				  <?php
    				  include("right.php");
    				  ?>
    				  </td>
                    </tr>
                  </table></td>
    		  </tr>
    		</table>
    <?php
    		
    		//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    		//~~~~~~~~~~~~~ Alt Çağırılıyor ~~~~~~~~~~//
    		//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    	
    		include("footer.php");
    		
    		//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    		//~~~~~~~~~~~~~ MySQL Kapatılıyor ~~~~~~~~//
    		//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
    	
    		$db->sql_close();
    ?>


    İlgilenirsen sevinirim
  • 05-08-2010, 11:38:03
    #4
    Konu Güncel