{"id":98,"date":"2018-04-23T21:29:10","date_gmt":"2018-04-23T21:29:10","guid":{"rendered":"http:\/\/www.eyurtsever.com\/?p=98"},"modified":"2023-01-11T15:44:43","modified_gmt":"2023-01-11T12:44:43","slug":"asp-ile-formdan-gelenleri-veritabanina-ekleme","status":"publish","type":"post","link":"https:\/\/www.eyurtsever.com\/index.php\/asp-ile-formdan-gelenleri-veritabanina-ekleme","title":{"rendered":"Asp ile Formdan Gelenleri Veritaban\u0131na Ekleme"},"content":{"rendered":"

Asp ile formdan gelen verileri veritaban\u0131na nas\u0131l kaydederiz?<\/a> Asl\u0131nda \u00e7ok basit. Basit bir sorguyla bunu yapal\u0131m.
\n 
\n\u00d6nce tablomuzu olu\u015ftural\u0131m.
\nTabload\u0131 :  TblMakale
\nAlanlar :  id,baslik,detay
\n 
\n\u015fimdi bu alanlara g\u00f6re formumuzu olu\u015ftural\u0131m:
\n <\/p>\n

<form action=\"makale_kaydet.asp\" method=\"post\">\n<input type=\"text\" name=\"baslik\" \/> <br\/>\n<textarea name=\"detay\" ><\/textarea>\n<\/form>\n<\/pre>\n

\nFormumuzu olu\u015fturduk. \u015eimdi makale_kaydet.asp yi olu\u015ftural\u0131m.
\n\u00d6ncelikle veritaban\u0131 ba\u011flant\u0131m\u0131z\u0131 yapt\u0131\u011f\u0131m\u0131z\u0131 farz ediyorum. bkz: Asp veritaban\u0131 ba\u011flant\u0131s\u0131<\/a>
\n 
\nFormdan gelen de\u011ferleri a\u015fa\u011f\u0131daki gibi al\u0131yoruz:<\/p>\n
<%\nbaslik = request.form(\"baslik\")\ndetay = request.form(\"detay\")\n'formdan gelen de\u011ferleri de\u011fi\u015fkenlere atad\u0131k\n'\u015eimdi veritaban\u0131m\u0131za kaydedelim:\nbaglanti.execute(\"INSERT INTO TblHaber (baslik,detay) Values ('\"&baslik&\"','\"&detay&\"') \")\nresponse.write \" Kay\u0131t Ba\u015far\u0131l\u0131\"\n%>\n<\/pre>\n
Ve hepsi bu kadar, veritaban\u0131m\u0131za yeni kay\u0131t ekledik
\n 
\nNot: tablodaki id alan\u0131n otomatik say\u0131 olmas\u0131na dikkat edin.
\n 
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Asp ile formdan gelen verileri veritaban\u0131na nas\u0131l kaydederiz? Asl\u0131nda \u00e7ok basit. Basit bir sorguyla bunu yapal\u0131m.   \u00d6nce tablomuzu olu\u015ftural\u0131m. Tabload\u0131 :  TblMakale Alanlar :  id,baslik,detay   \u015fimdi bu alanlara g\u00f6re formumuzu olu\u015ftural\u0131m:   <form action=”makale_kaydet.asp” method=”post”> <input type=”text” name=”baslik” \/> <br\/> <textarea name=”detay” ><\/textarea> <\/form><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,13],"tags":[43,44,147,339],"_links":{"self":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/98"}],"collection":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":1,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":613,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions\/613"}],"wp:attachment":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}