|
Search Engine on database
Posted: 30 Jul 2004
Hello dear,
I give one solution for creating the search engine.
For example you have three fields, field1, field2, field3 in table1. Following code is useful for you.
code is in asp
<html>
<body>
<%
if request.form("mode") = "search" then
dim cn
dim rs
set cn = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
cn.open "provider=microsoft.jet.oledb.4.0;data source=path of mdb file"
rs.open "select * from table1 where " & request.form("field") & "='%" & request.form("searchvalue") & "%'", cn, 1, 2
while not rs.eof
response.write rs.field(1)
rs.movenext()
wend
rs.close
cn.close
end if
%>
<form name=frm1 method=post>
<select name="field">
<option value="field1">Field 1</option>
<option value="field2">Field 2</option>
<option value="field3">Field 3</option>
</select>
<input type="text" name="searchvalue" value="">
<input type="hidden" name="mode" value="search">
<input type="submit" value="Search">
</form>
</body>
</html>
Hello friend, i not run this code, but i create search engine thus i give solution.
Some changes are required according to your requirement.
If more detail required then mail to me on : hardikpatel_se@rediffmail.com
From,
Hardik Patel
(Email ID : hardikpatel_se@rediffmail.com)
Hardik Patel
India
|
