<? 
  $dbhost="localhost"; 
  $dbname="haber"; 
  $dbuser="root"; 
  $dbpass=""; 
  $bagla=mysql_connect($dbhost,$dbuser,$dbpass); 
  @mysql_select_db("$dbname") or die ("Veritabanına Bağlanamadık"); 
  ?> 
  <style> 
  TD {font-family: verdana, Arial, Helvetica; font-size:10px; color: #333333;} 
  a:active { text-decoration: none; color: #666666} 
  a:link { text-decoration: none; color: #666666} 
  a:visited { text-decoration: none; color: #666666} 
  a:hover { text-decoration: none; color: #FF6600} 
  </style>

CREATE TABLE `haberler` ( 
    `no` int(10) unsigned NOT NULL auto_increment, 
    `baslik` varchar(100) NOT NULL default '', 
    `tarih` varchar(15) NOT NULL default '', 
    `haber` text NOT NULL, 
    PRIMARY KEY  (`no`), 
    FULLTEXT KEY `baslik` (`baslik`), 
    FULLTEXT KEY `tarih` (`tarih`), 
    FULLTEXT KEY `haber` (`haber`) 
  ) TYPE=MyISAM;

<?include("ayar.php");?> 
  <form method="POST" action="ekle.php"> 
  <table> 
  <tr> 
  <td nowrap> 
  Haber Başlığı 
  </td> 
  <td> 
  <input type="text" name="baslik" size="30"> 
  </td> 
  </tr> 
  <tr> 
  <td nowrap> 
  Haber Tarihi 
  </td> 
  <td> 
  <?$tarih=date("d-m-y");?> 
  <input type="text" name="tarih" size="30" value="<?echo"$tarih";?>"> 
  </td> 
  </tr> 
  <tr> 
  <td nowrap> 
  Haber Açıklaması 
  </td> 
  <td> 
  <input type="text" name="haber" size="30"> 
  </td> 
  </tr> 
  <tr> 
  <td nowrap> 
  Haber Başlığı 
  </td> 
  <td> 
  <input type="submit" value="HABERİ EKLE" name="ekle"> 
  </td> 
  </tr> 
  </table> 
  </form> 
  <table> 
  <? 
  $islem="SELECT * FROM haberler WHERE no ORDER BY no DESC"; 
  $sonuc=mysql_db_query($dbname,$islem); 
  while ($php=mysql_fetch_array($sonuc)) 
  { 
  ?> 
  <tr> 
  <td nowrap> 
  <?=$php[baslik]?> 
  </td> 
  <td> 
   [ <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=4183406&url=sil.php?no=<?$php[no];?>" data-href="sil.php?no=<?$php[no];?>">SİL</a> ]  
  </td> 
  </tr> 
  <? 
  } 
  ?> 
  </table> 
  

<? 
  include("ayar.php"); 
  $islem="INSERT INTO haberler (baslik,tarih,haber) VALUES ('$baslik','$tarih','$haber')"; 
  $sonuc=mysql_db_query($dbname,$islem); 
  mysql_close($bagla); 
  header("Location:$HTTP_REFERER"); 
  ?>

<? 
  include("ayar.php"); 
  $islem = "DELETE FROM haberler WHERE no=$no"; 
  $sonuc = mysql_query($islem,$bagla); 
  header("Location:$HTTP_REFERER"); 
  ?>

<?include("ayar.php");?> 
  <? 
  $islem="SELECT * FROM haberler WHERE no ORDER BY no DESC"; 
  $sonuc=mysql_db_query($dbname,$islem); 
  while ($php=mysql_fetch_array($sonuc)) 
  { 
  ?> 
  <b><?=$php[baslik];?></b> 
  <br> 
  <b><?=$php[tarih];?></b> - <?$php[haber];?> 
  <br><br> 
  <? 
  } 
  ?>