bu koddaki dropdownlar databaseden alıyor bilgileri text giriş ve checkbox bu üçündeki veriyi veri tabanına nasıl kaydedebilirim kaç gündür uğraşıyorum "Emlak 2000" scriptinden değiştirdim biraz yani üyeliksiz direk kaydetme lazım o scriptte admin onayı falan gerekiyor. yardımlarınızı bekliyorum
<html>
<!--#include file="koru.asp"-->
<!--#include file="baglanti.asp"-->
<!-- #BeginEditable "doctitle" -->
<!-- #EndEditable -->
<%
Session.CodePage=1254
%>
<%
Set ks1 = baglanti.Execute("sp_kategoriler")
tur_db = ks1("id")
tur = koru(Request.QueryString("tur"))
if tur = "" Then
tur = tur_db
End if
il_id = koru(Request.QueryString("il_id"))
if il_id = "" Then
il_id = "34"
End if
strSQL = "SELECT * FROM kategoriler WHERE id ="& tur
Set ks2 = baglanti.Execute(strSQL)
%>
<style type="text/css">
<!-
P {
background-color :#D4D0C8;
</style>
<link href="stil.css" rel="stylesheet" type="text/css">
<form action="ilan_kaydet.asp?kategori=<%=tur%>" method="post" name="ilan_ekle" id="ilan_ekle">
<body leftmargin="0" topmargin="1" rightmargin="0" bottommargin="0" bgcolor="#D4D0C8" marginheight="0" marginwidth="0">
<table width="548" align="left" cellpadding="0" cellspacing="0" class="tborder" bordercolorlight="#AAAAAA" bordercolordark="#AAAAAA" style="border-color: #AAAAAA; border-width: 1px">
<tr>
<td width="144">
<tr>
<td height="18" colspan="2" align="left" bgcolor="#D4D0C8"><strong class="baslik">İ*** Ekle</strong> </td>
</tr>
<tr>
<td align="left" width="144">Kategori</td>
<td align="left" width="548"><select name="kategori" class="input" id="kategori" onChange="self.location=this.options[this.selectedIndex].value">
<%
Do While Not ks1.EOF
%>
<option value="ekle.asp?icerik=3&tur=<%=ks1("id")%>&il_id=<%=il_id%>" <%if CINT(tur) = ks1("id") Then%>selected="selected"<% End if %>><%=ks1("emlak_kategorileri")%></option>
<%
ks1.MoveNext
Loop
%>
</select> </td>
</tr>
<%
strSQL = "SELECT * FROM iller"
Set ks3 = baglanti.Execute(strSQL)
%>
<tr>
<td align="left" width="144">İl</td>
<td align="left" width="756"><select name="il" id="il" class="input" onChange="self.location=this.options[this.selectedIndex].value">
<%
Do While Not ks3.EOF
%>
<option value="ekle.asp?icerik=3&tur=<%=tur%>&il_id=<%=ks3("id")%>" <% if ks3("id") = il_id Then %> selected="selected" <% End if %>><%= ks3("il") %></option>
<%
ks3.MoveNext
Loop
%>
</select></td>
</tr>
<%
strSQL = "SELECT * FROM ilceler WHERE id ='"&il_id&"'"
Set ks4 = baglanti.Execute(strSQL)
%>
<tr>
<td align="left" width="144">İlçe</td>
<td align="left" width="756">
<select name="ilce" id="ilce" class="input">
<%
Do While Not ks4.EOF
%>
<option value="<%= ks4("ilceler") %>"><%= ks4("ilceler") %></option>
<%
ks4.MoveNext
Loop
%>
</select> </td>
</tr>
<tr>
<td align="left" width="144">Semt</td>
<td align="left" width="756"><input name="semt" type="text" class="input" id="semt" size="20" maxlength="20" />
*</td>
</tr>
<tr>
<td align="left" width="144">Başlık</td>
<td align="left" width="756"><input name="baslik" type="text" class="input" id="baslik" size="25" maxlength="20">
*</td>
</tr>
<tr>
<td align="left" valign="top" width="144"> </td>
<td valign="top" align="left" width="756">Örn: Kelepir Daire </td>
</tr>
<tr>
<td align="left" width="144">Fiyat</td>
<td align="left" width="756"><input name="fiyat" type="text" id="fiyat" size="9" maxlength="13" class="input" />
YTL*</td>
</tr>
<% if ks2("metrekare") = True Then%>
<tr>
<td align="left" width="144">Metrekare</td>
<td align="left" width="756"><input name="metrekare" type="text" class="input" id="metrekare" size="5" maxlength="20" />
*</td>
</tr>
<% End if %>
<% if ks2("oda_sayisi") = True Then %>
<tr>
<td align="left" width="144">Oda Sayısı </td>
<td align="left" width="756"><input name="oda_sayisi" type="text" class="input" id="oda_sayisi" size="5" maxlength="20" />
*</td>
</tr>
<% End if %>
<% if ks2("salon_sayisi") = True Then %>
<tr>
<td align="left" width="144">Salon Sayısı </td>
<td align="left" width="756"><input name="salon_sayisi" type="text" class="input" id="salon_sayisi" size="5" maxlength="20" />
*</td>
</tr>
<% End if %>
<% if ks2("banyo_sayisi") = True Then %>
<tr>
<td align="left" width="144">Banyo Sayısı </td>
<td align="left" width="756"><input name="banyo_sayisi" type="text" class="input" id="banyo_sayisi" size="5" maxlength="20" />
*</td>
</tr>
<% End if %>
<% if ks2("binadaki_kat_sayisi") = True Then%>
<tr>
<td align="left" width="144">Binadaki Kat Sayısı </td>
<td align="left" width="756"><input name="binadaki_kat_sayisi" type="text" class="input" id="binadaki_kat_sayisi" size="8" maxlength="20" />
*</td>
</tr>
<% End if %>
<% if ks2("bulundugu_kat") = True Then %>
<tr>
<td align="left" width="144">Bulunduğu Kat </td>
<td align="left" width="756"><select name="bulundugu_kat" class="input" id="bulundugu_kat">
<option value="Bodrum">Bodrum</option>
<option value="Yarı Bodrum">Yarı Bodrum</option>
<option value="Zemin">Zemin</option>
<option value="Giriş">Giriş</option>
<option value="Yüksek Giriş">Yüksek Giriş</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
</select>
*</td>
</tr>
<% End if %>
<% if ks2("isitma") = True Then %>
<tr>
<td align="left" width="144">Isıtma</td>
<td align="left" width="756"><select name="isitma" class="input" id="isitma">
<option value="Soba">Soba</option>
<option value="Doğal Gaz Soba">Doğal Gaz Soba</option>
<option value="Kat Kaloriferi">Kat Kaloriferi</option>
<option value="Doğal Gaz Kombi">Doğal Gaz Kombi</option>
<option value="Merkezi Sistem Kömür">Merkezi Sistem Kömür</option>
<option value="Merkezi Sistem D.Gaz">Merkezi Sistem D.Gaz</option>
</select> </td>
</tr>
<% End if %>
<tr>
<td align="left" valign="top" width="144">Açıklamalar</td>
<td align="left" width="756"><textarea name="aciklama" cols="27" rows="6" id="aciklama" class="input"></textarea></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"> </td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><strong>Özellikler</strong></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top">
<table width="900" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="left">
<table width="454" cellspacing="0" cellpadding="0" align="left" bgcolor="#D4D0C8">
<tr>
<% if ks2("deniz_manzarasi") = True Then %>
<td align="justify"><input name="hidrofor" type="checkbox" id="hidrofor" value="True" />Hidrofor</td>
<% End if %>
<% if ks2("balkon") = True Then %>
<td width="35%" align="justify"><input name="deniz_manzarasi" type="checkbox" id="deniz_manzarasi" value="True" />Deniz Manzarası</td>
<td width="27%" align="justify"><input name="balkon" type="checkbox" id="balkon" value="True" />Balkon</td>
<% End if %>
</tr>
<tr>
<% if ks2("dublex") = True Then %>
<td align="justify"><input name="kapici" type="checkbox" id="kapici" value="True" />Kapıcı</td>
<% End if %>
<% if ks2("beyaz_esya") = True Then %>
<td align="justify"><input name="dublex" type="checkbox" id="dublex" value="True" />Dublex</td>
<td align="justify"><input name="beyaz_esya" type="checkbox" id="beyaz_esya" value="True" />Beyaz Eşya </td>
<% End if %>
</tr>
<tr>
<% if ks2("kapali_garaj") = True Then %>
<td align="justify"><input name="jakuzi" type="checkbox" id="jakuzi" value="True" />Jakuzi</td>
<% End if %>
<% if ks2("site_icinde") = True Then %>
<td align="justify"><input name="kapali_garaj" type="checkbox" id="kapali_garaj" value="True" />Kapalı
Garaj</td>
<td align="justify"><input name="site_icinde" type="checkbox" id="site_icinde" value="True" />Site İçinde </td>
<% End if %>
</tr>
<tr>
<% if ks2("asansor") = True Then %>
<td align="justify"><input name="parke_zemin" type="checkbox" id="parke_zemin" value="True" />Parke Zemin </td>
<% End if %>
<% if ks2("surekli_sicak_su") = True Then %>
<td align="justify"><input name="asansor" type="checkbox" id="asansor" value="True" />Asansör</td>
<td align="justify"><input name="surekli_sicak_su" type="checkbox" id="surekli_sicak_su" value="True" />Sürekli Sıcak Su </td>
<% End if %>
</tr>
<tr>
<% if ks2("guvenlik") = True Then %>
<td align="justify"><input name="mustakil" type="checkbox" id="mustakil" value="True" />Müstakil</td>
<% End if %>
<% if ks2("triplex") = True Then %>
<td align="justify"><input name="guvenlik" type="checkbox" id="guvenlik" value="True" />Güvenlik</td>
<td align="justify"><input name="triplex" type="checkbox" id="triplex" value="True" />Triplex</td>
<% End if %>
</tr>
<tr>
<% if ks2("dogalgaz") = True Then %>
<td align="justify"><input name="otopark" type="checkbox" id="otopark" value="True" />Otopark</td>
<% End if %>
<% if ks2("yuzme_havuzu") = True Then %>
<td align="justify"><input name="dogalgaz" type="checkbox" id="dogalgaz" value="True" />Doğal Gaz </td>
<td align="justify"><input name="yuzme_havuzu" type="checkbox" id="yuzme_havuzu" value="True" />Yüzme Havuzu </td>
<% End if %>
</tr>
<tr>
<% if ks2("hidrofor") = True Then %>
<td align="justify"><input name="tenis_kortu" type="checkbox" id="tenis_kortu" value="True" />Tenis Kortu</td>
<% End if %>
<% if ks2("jenarator") = True Then %>
<td align="justify"><input name="celik_kapi" type="checkbox" id="celik_kapi" value="True" />Çelik Kapı</td>
<td align="justify"><input name="jenarator" type="checkbox" id="jenarator" value="True" />Jenaratör</td>
<% End if %>
</tr>
<tr>
<% if ks2("kapici") = True Then %>
<td align="justify"><input name="somine" type="checkbox" id="somine" value="True" />Şömine</td>
<% End if %>
<% if ks2("mobilya") = True Then %>
<td align="justify"><input name="fitness_salonu" type="checkbox" id="fitness_salonu" value="True" />Fitness Salonu</td>
<td align="justify"><input name="mobilya" type="checkbox" id="mobilya" value="True" />Mobilya</td>
<% End if %>
</tr>
<tr>
<% if ks2("jakuzi") = True Then %>
<td align="justify"><input name="klima" type="checkbox" id="klima" value="True" />Klima</td>
<% End if %>
<% if ks2("teras") = True Then %>
<td align="justify"><input name="imarli" type="checkbox" id="imarli" value="True" />İmarlı</td>
<td align="justify"><input name="teras" type="checkbox" id="teras" value="True" />Teras</td>
<% End if %>
</tr>
<tr>
<% if ks2("parke_zemin") = True Then %>
<td align="justify"><input name="projeli" type="checkbox" id="projeli" value="True" />Projeli</td>
<% End if %>
<% if ks2("oyun_parki") = True Then %>
<td align="justify"><input name="ifranli" type="checkbox" id="ifranli" value="True" />İfranlı</td>
<td align="justify"><input name="oyun_parki" type="checkbox" id="oyun_parki" value="True" />Oyun Parkı </td>
<% End if %>
</tr>
<tr>
<% if ks2("mustakil") = True Then %>
<td align="justify"><input name="zemin_etudlu" type="checkbox" id="zemin_etudlu" value="True" />Zemin
Etütlü</td>
<% End if %>
<% if ks2("bahce") = True Then %>
<td align="justify"><input name="sanayi_elektrigi" type="checkbox" id="sanayi_elektrigi" value="True" />Sanayi Elektriği</td>
<td align="justify"><input name="bahce" type="checkbox" id="bahce" value="True" />Bahçe</td>
<% End if %>
</tr>
<tr>
<% if ks2("otopark") = True Then %>
<td align="justify"><input name="parselli" type="checkbox" id="parselli" value="True" />Parselli</td>
<% End if %>
<% if ks2("kablo_tv") = True Then %>
<td align="justify"><input name="yola_yakin" type="checkbox" id="yola_yakin" value="True" />Yola Yakın</td>
<td align="justify"><input name="kablo_tv" type="checkbox" id="kablo_tv" value="True" />Kablo Tv </td>
<% End if %>
</tr>
<tr>
<% if ks2("tenis_kortu") = True Then %>
<td align="justify"><input name="su" type="checkbox" id="su" value="True" />Su</td>
<% End if %>
<% if ks2("su_deposu") = True Then %>
<td align="justify"><input name="su_deposu" type="checkbox" id="su_deposu" value="True" />Su Deposu</td>
<td align="justify"> </td>
<% End if %>
</tr>
</table> </div>
</td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"> <p><input type="submit" name="Submit" value="Kaydet ve İlerle -->" class="btn blue" /></td>
</tr>
</table>
</form>
<p>
<%
ks1.Close
Set ks1 = Nothing
ks2.Close
Set ks2 = Nothing
%>
</p>
</body></html>