Merhaba arkadaşlar kendime bi haber ekleme sayfası yapmak istedim. Haber formu multipart/data formu kullanmak istedim. Sorunum şu. Sayfayı çalıştırıp haber eklediğimde hiç bir hata vermiyor ama veri tabanına sadece tarih kaydediyor , başka hiç bir veri kaydetmiyor.
Veritabonu tablo ismi : tbl haber
sütun isimleri : id,baslik,ozet,resim,tarih
<!--#include file ="conn.asp"-->
<head>
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" />
<meta http-equiv="Content-Language" content="tr">
</head>
<script language="javascript" type="text/javascript" src="jscripts/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
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>
<table border="1" width="100%" id="table1" height="50" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF">
<form action="haberekle.asp?islem=ekle" method="post" enctype="multipart/form-data">
<tr>
<td width="239" height="25" bordercolor="#C0C0C0"> HABER BAŞLIĞI</td>
<td height="25" bordercolor="#C0C0C0">
<p><input type="text" name="baslik" size="88"></p>
</td>
</tr>
<tr>
<td width="239" bordercolor="#C0C0C0"> HABER ÖZETİ</td>
<td bordercolor="#C0C0C0"><input type="text" name="ozet" size="88"></td>
</tr>
<tr>
<td width="239" bordercolor="#C0C0C0"> HABER RESMİ</td>
<td bordercolor="#C0C0C0"><input class="formic" type="file" name="resim"></td>
</tr>
<tr>
<td width="239" bordercolor="#C0C0C0"> HABER İÇERİĞİ</td>
<td bordercolor="#C0C0C0"><textarea name="haber" rows="12" cols="65"> </textarea></td>
</tr>
<tr>
<td width="239" bordercolor="#C0C0C0"> </td>
<td bordercolor="#C0C0C0"><input type="submit" value="Gönder" name="B3"></td>
</tr>
</table>
</form>
<%
dim islem
islem = Request.QueryString("islem")
if islem = "ekle" then
baslik = Request.Form("baslik")
ozet = Request.Form("ozet")
resim = Request.Form("resim")
haber = Request.Form("haber")
set kaydet = Server.CreateObject("Adodb.Recordset")
SQL = "Select * from tblhaber "
kaydet.open SQL,conn,1,3
kaydet.Addnew
kaydet("baslik") = baslik
kaydet("ozet") = ozet
kaydet("haber") = haber
kaydet("tarih") = Date()
kaydet.update
kaydet.close
set kaydet = nothing
conn.close
set conn = nothing
end if
%>