建站代码网

热门标签

通过区域来搜索数据库

提供搜索数据库能让用户查询你目标哪个元件的功能。然而允许用户针对数据库的分配,他们会查询给出额外值。在这个例子中,利用我们的美国州的数据库(州,州的名称和首都),用户会搜索任何的三个区域(通过下拉菜单输入)而不是目标的特定的表格元件应用。注意:数据库只有50个意见,因此最好是搜索单字母和双字母的组合。

<html> <title>CodeAve.com(Search db by Field)</title> <body bgcolor="#FFFFFF"> <% u_input = trim(request.form("u_input")) 'u_input is the varible for user input ‘剪切功能会删除使用输入周围的任何空白 u_field=request.form("u_field") 'the dropdown varible for user inputted search field if u_input <> "" then ' If the user entered a value query the db accessdb="state_info" ' name of the access db table_name="states" ' name of the table within the access db cn="driver={microsoft access driver (*.mdb)};" cn=cn & "dbq=" & server.mappath(accessdb) set rs = server.createobject("ADODB.Recordset") sql = "select * from "& table_name &" where " & u_field & " like '%%" & u_input & "%%' " response.write sql rs.Open sql, cn if rs.eof or rs.bof then response.write "No results found..." observations=0 else observations=1 end if 'end check for observations end if 'end check for user input %> <% 'If there are observations then display them if observations > 0 then %> <table> <tr> <% 'Write the field names for each table_element in rs.fields %> <td><b><%= table_element.name%></B></TD><% next %> </tr> <tr> <% 'Write the values rs.movefirst do while not rs.eof for each cell in rs.fields %> <td><%= cell.value %></td><% next %> </tr> <% rs.movenext loop %> </table> <% end if 'end of check of obs for display %> <form action ="<%= request.servervariables("script_name") %>" method="post"> <input type="text" name="u_input" value="<%= u_input %>"> <select name="u_field" size="1"> <option <% ' write out all the search fields and select if u_field = "state" or u_field = "" then response.write "selected " end if %>value="state">State</option> <option <% if u_field = "statename" then response.write "selected " end if %>value="statename">State Name</option> <option <% if u_field = "capital" then response.write "selected " end if %>value="capital">Capital</option> </select> <input type="submit" value="Submit"> </form>


X