mtb_crm_asp/system/Searchproduct.asp

<!--#include file="Conn.asp"-->
<%Checklogin("信息管理")%>
<%
str=TextEnCode(Request.QueryString("str"))

Set Rs=Server.CreateObject("Adodb.Recordset")
	sql="select id,ProductImg,ProductName,unit from Products where productName like '%"&str&"%'"
    Rs.open sql,conn,1,3
	Do while Not Rs.bof and Not Rs.eof
		%>
		<li data-id="<%=Rs("id")%>" data-unit="<%=Rs("unit")%>"><div class="list-content"><div class="pic"><img src="<%=Rs("ProductImg")%>" ></div><div class="name"><%=Rs("ProductName")%></div></div></li>
		<%	
		Rs.moveNext
	loop
	Rs.close
Set Rs=Nothing
conn.close
Set conn=Nothing
%>