Asp Emlak Yardım Lütfen

08-05-2009, 15:10:18
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&ccedil;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">&nbsp;</td>
        <td valign="top" align="left" width="756">&Ouml;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&uuml;ksek Giriş">Y&uuml;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&ouml;m&uuml;r">Merkezi Sistem K&ouml;m&uuml;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&ccedil;ı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">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="2" align="left" valign="top"><strong>&Ouml;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&nbsp;&nbsp; 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 İ&ccedil;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&ouml;r</td>
            <td align="justify"><input name="surekli_sicak_su" type="checkbox" id="surekli_sicak_su" value="True" />S&uuml;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&uuml;stakil</td>
			<% End if %>
			<% if ks2("triplex") = True Then %>
            <td align="justify"><input name="guvenlik" type="checkbox" id="guvenlik" value="True" />G&uuml;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&uuml;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" />&Ccedil;elik Kapı</td>
            <td align="justify"><input name="jenarator" type="checkbox" id="jenarator" value="True" />Jenarat&ouml;r</td>
			<% End if %>
          </tr>
          <tr>
		  	<% if ks2("kapici") = True Then %>
            <td align="justify"><input name="somine" type="checkbox" id="somine" value="True" />Ş&ouml;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&ccedil;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">&nbsp;</td>
			<% End if %>
          </tr>
          </table>		</div>
		</td>
		</tr>
		</table>		</td>
      </tr>
      <tr>
        <td colspan="2" align="left" valign="top">&nbsp;<p><input type="submit" name="Submit" value="Kaydet ve İlerle --&gt;" class="btn blue" /></td>
        </tr>
      
      
    </table>
</form>
<p>

<%
	ks1.Close
	Set ks1 = Nothing
	ks2.Close
	Set ks2 = Nothing
%>
</p>
</body></html>
08-05-2009, 18:07:38

#2

anka81

checkbox ile toplu kayit : MaxiASP - ASP ve Kodlamalar
13-05-2009, 20:29:07

#3

gogoturk

Merhaba scripti yazan benim. Ama sorunu pek anlamadım. daha açık sorarsan yardım ederim.