veritabanı güncelleme

    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" />
    <!-- TinyMCE -->
<script type="text/javascript" src="jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
    tinyMCE.init({
        // General options
        mode : "textareas",
        theme : "advanced",
        language : "tr",
        plugins : "safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",
        // Theme options
        theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
        theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
        theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
        theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak",
        theme_advanced_toolbar_location : "top",
        theme_advanced_toolbar_align : "left",
        theme_advanced_statusbar_location : "bottom",
        theme_advanced_resizing : true,
        // Example content CSS (should be your site CSS)
        content_css : "css/content.css",
        // Drop lists for link/image/media/template dialogs
        template_external_list_url : "lists/template_list.js",
        external_link_list_url : "lists/link_list.js",
        external_image_list_url : "lists/image_list.js",
        media_external_list_url : "lists/media_list.js",
        // Replace values for the template plugin
        template_replace_values : {
            username : "Some User",
            staffid : "991234"
        }
    });
</script>
<!-- /TinyMCE -->


<?php

include ("guvenlik.php");
include ("veritabani.php");

$idreyiz = $_GET["id"];


$haberoku = mysql_query("select * from haber where id='$idreyiz'");
while($haberyaz = mysql_fetch_array($haberoku)){
$haberbaslik = $haberyaz['baslik'];
$haberaciklama = $haberyaz['aciklama'];
$habericerik = $haberyaz['icerik'];

echo '
<form name="form1" method="post" action="haberduzenle2.php?id=$idreyiz">
<table width="593" height="173" border="0" cellspacing="0">
  <tr>
    <td colspan="2"><div align="center"><em><strong>Haber Düzenle</strong></em></div></td>
  </tr>
  <tr>
    <td width="159"><strong>Haber Basligi:</strong></td>
    <td width="430"><label>
      <input name="baslik" type="text" id="baslik" size="50" value="'.$haberbaslik.'">
    </label></td>
  </tr>
  <tr>
    <td><p><strong>Haber Açiklamasi:</strong></p>    </td>
    <td><label>
      <textarea name="aciklama" id="aciklama" cols="47" rows="2" value>'.$haberaciklama.'</textarea>
    </label></td>
  </tr>
  <tr>
    <td><strong>Haber Içerigi:</strong></td>
    <td><label><textarea name="haber" id="haber" cols="47" rows="2">'.$habericerik.'</textarea>
    </label></td>
  </tr>
  <tr>
    <td colspan="2"><div align="right"><em>
      <label>
      <input type="submit" name="button" id="button" value="Ekle" />
      </label>
    </em></div></td>
  </tr>
</table>
</form>';
}
?>

<?php

include ("guvenlik.php");
include ("veritabani.php");

$id = $_GET["id"];
$baslik = $_POST["baslik"];
$aciklama = $_POST["aciklama"];
$haber = $_POST["haber"];


$sorgupic = mysql_query("UPDATE `haber` SET `baslik` = \'$baslik\', `aciklama` = \'$aciklama\', `icerik` = \'$haber\' WHERE `haber`.`id` = $id");
if ($sorgupic){
echo "haber eklendi. <a href='yonetim.php?git=haberler'>buraya tıklayarak devam et</a>";
} else {
echo "haber eklenemedi. üzgünüz. <a href='yonetim.php?git=haberekle'>buraya tıklayarak devam et</a>.";
}

?>