回 帖 发 新 帖 刷新版面

主题:急啊!!关于图片上传问题,请高手帮看看,来者加分,非常感谢

图片怎么都进不了数据库表,只能进文件夹,下面是有关的两个部分文件页,请高手帮看看是不是哪写错了,真是急,弄半天了,都没弄好
add_newshouse.asp
<form name="form1" method="post" action="save_newhouse.asp" onSubmit="return checkdata()">
        <table width="100%" border="1" align="center" cellpadding="0" bgcolor="#E5F3F8" style="border-collapse:collapse" bordercolor="#ffffff">
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">楼盘名称: </td>
            <td height="26" class="font">
              <input name="house_name" type="text" class="textinput" size="30" maxlength="50"></td>
            <td align="right" class="font">开 发 商: </td>
            <td class="font">
              <input name="kfs" type="text" class="textinput" size="30" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">开发商网站: </td>
            <td class="font" height="26"> 
              <input name="kfs_http" type="text" class="textinput" size="30" maxlength="50"></td>
            <td align="right" class="font">区  域: </td>
            <td class="font"> 
              <select name="qy" class="textinput" >
                <option value="" selected>请选择区域</option>
               <option value=""></option>

                      <option value="其他">其他</option>
              </select>            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">地  址: </td>
            <td height="26" class="font" colspan="3"> 
              <input name="address" type="text" class="textinput" size="80" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">交通状况: </td>
            <td height="26" class="font"> 
              <input name="traffic" type="text" class="textinput" size="30" maxlength="50">            </td>
            <td align="right" class="font">房屋类型: </td>
            <td class="font"> 
              <input name="house_lx" type="text" class="textinput" size="30" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">面积范围: </td>
            <td height="26" class="font"> 
              <input name="mj" type="text" class="textinput" size="30" maxlength="50">            </td>
            <td align="right" class="font">起  价: </td>
            <td class="font"> 
              <input name="first_pay" type="text" class="textinput" size="30" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">均  价: </td>
            <td height="26" class="font"> 
              <input name="jun_pay" type="text" class="textinput" size="30" maxlength="50">            </td>
            <td align="right" class="font">许 可 证: </td>
            <td class="font">
              <input name="xk" type="text" class="textinput" size="30" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">图  片: </td>
            <td height="26" class="font" colspan="3"> 
              <input name="bookpic" type="text" class="textinput" size="30">
&nbsp;
              <input type="button" name="Submit2" value="上传小图片" onClick="window.open('../upload.asp?formname=myform&editname=bookpic&uppath=bookpic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">            </td>
          </tr>
                    
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">&nbsp;</td>
            <td height="26" class="font" colspan="3"> 
              <input name="zhuang" type="text" class="textinput" size="30">
&nbsp;
              <input type="button" name="Submit2" value="上传大图片" onClick="window.open('../upload.asp?formname=myform&editname=zhuang&uppath=bookpic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">            </td>
          </tr>
           <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">室内环境图片上传:</td>
            <td height="26" class="font" colspan="3"> 
              <input name="p1" type="text" class="textinput" size="30" >
               
                <input type="button" name="Submit22" class="gowbk" value="上传配置图片一" onClick="window.open('../upload.asp?formname=myform&editname=p1&uppath=bookpic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td rowspan="3" align="right" class="font">
            注: 房产配置图片共四张,<br>上传后显示在房产介绍内,<br>如不上传即不显示
            
            </td>
            <td height="26" class="font" colspan="3"> 
              <input name="p2" type="text" class="textinput" size="30" >
               
                <input type="button" name="Submit23" class="gowbk" value="上传配置图片二" onClick="window.open('../upload.asp?formname=myform&editname=p2&uppath=bookpic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">            </td>
          </tr>
           <tr align="left" valign="middle"> 
            <td height="26" class="font" colspan="3"> 
              <input name="p3" type="text" class="textinput" size="30">
               
                <input type="button" name="Submit24" class="gowbk" value="上传配置图片三" onClick="window.open('../upload.asp?formname=myform&editname=p3&uppath=bookpic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">         </td>
          </tr>
           <tr align="left" valign="middle"> 
            <td height="26" class="font" colspan="3"> 
              <input name="p4" type="text" class="textinput" size="30" >
               
                <input type="button" name="Submit25" class="gowbk" value="上传配置图片四" onClick="window.open('../upload.asp?formname=myform&editname=p4&uppath=bookpic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">          </td>
          </tr>
          
          
          <tr> 
            <td height="26" align="right" valign="top" class="font">楼盘简介: </td>
            <td align="left" valign="top" colspan="3" > 
              <textarea name="jj_bz" cols="82" rows="8" class="textinput" >暂无简介</textarea></td>
          </tr>
           <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">状  态: </td>
            <td class="font" height="26"> 
              <input name="zt" type="text" class="textinput" size="30" maxlength="50"></td>
            <td align="right" class="font">售楼热线: </td>
            <td class="font"> 
              <input name="sell_tel" type="text" class="textinput" size="30" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">售楼地址: </td>
            <td height="26" class="font" colspan="3"> 
              <input name="sell_address" type="text" class="textinput" size="80" maxlength="50">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">传  真: </td>
            <td height="26" class="font"> 
              <input name="fax" type="text" class="textinput" size="30" maxlength="50">            </td>
            <td align="right" class="font">E-mail: </td>
            <td class="font"> 
              <input name="email" type="text" class="textinput" size="30" maxlength="50" value="无">            </td>
          </tr>
          <tr align="left" valign="middle"> 
            <td height="26" align="right" class="font">联 系 人: </td>
            <td height="26" class="font"> 
              <input name="man" type="text" class="textinput" size="30" maxlength="50">            </td>
            <td align="right" class="font">是否加色: </td>
            <td class="font"> 
              <select name="color">
                <option value="#FF6600">加色</option>
                <option value="" selected>不加色</option>
              </select>            </td>
          </tr>
          <tr> 
            <td align="right" valign="top" class="font">公车路线: </td>
            <td width="513" align="left" valign="top" colspan="3"> 
              <textarea name="bus" cols="82" rows="8" class="textinput" ></textarea>            </td>
          </tr>
           <tr>
            <td height="30" colspan="4" align="center" valign="middle">
              <input type="submit" name="Submit" value="提交发表" class="textbotton">
                
              <input type="reset" name="Submit2" value="重新填写" class="textbotton">            </td>
          </tr>
        </table>
      </form>

回复列表 (共2个回复)

沙发

save_newhouse.asp(是不是这个文件写错了,请高手帮看看,谢谢)

<!--#include file="conn.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆!');window.location.href='login.asp';</script>"
response.End
else
if session("flag")>1 then
response.Write "<p align=center><font color=red>您没有此项目管理权限!</font></p>"
response.End
end if
end if%>
<%
        dim rs,sql,jj_bz,bus
    
        bus=request("bus")
    bus=replace(bus," ","&nbsp;")
        bus=replace(bus,chr(13)&chr(10),"<Br>")

        jj_bz=request("jj_bz")
    jj_bz=replace(jj_bz," ","&nbsp;")
        jj_bz=replace(jj_bz,chr(13)&chr(10),"<Br>")
    

    sql="select * from [house_new]"
    set rs=server.createobject("adodb.recordset")
        rs.open sql,conn,3,3
        rs.addnew

        rs("house_name")=request("house_name")
        rs("kfs")=request("kfs")
        rs("kfs_http")=request("kfs_http")
        rs("qy")=request("qy")
        rs("address")=request("address")
        rs("traffic")=request("traffic")
        rs("house_lx")=request("house_lx")
        rs("mj")=request("mj")
        rs("first_pay")=request("first_pay")
        rs("jun_pay")=request("jun_pay")
        rs("xk")=request("xk")
        rs("bookpic")=request("bookpic")
        rs("jj_bz")=jj_bz
        rs("zt")=request("zt")
        rs("sell_tel")=request("sell_tel")
        rs("sell_address")=request("sell_address")
        rs("fax")=request("fax")
        rs("email")=request("email")
        rs("man")=request("man")
        rs("color")=request("color")
        rs("zhuang")=request("zhuang")
        rs("p1")=request("p1")
        rs("p2")=request("p2")
        rs("p3")=request("p3")
        rs("p4")=request("p4")

        rs("bus")=bus
        rs("date")=now()

        rs.update
        rs.close
        set rs=nothing

%>
<script language="javascript">
window.alert("添加成功!");
//window.close();
window.location.href='newhouse.asp'
</script>

板凳

rs("kfs")=request("kfs")
        rs("kfs_http")=request("kfs_http")
        rs("qy")=request("qy")

你从form表中获取用户填写信息插入数据库,为什么会是 rs("house_name")=request("house_name")?
应该是这样吧?
rs("house_name")=request.form("house_name")?
加上form就对了

我来回复

您尚未登录,请登录后再回复。点此登录或注册