Modificare il file:
\Offerte\search.asp
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#Include file="admin/cn.asp"--> <% dim rs dim rs2 dim cn dim msg set cn = Server.CreateObject("Adodb.Connection") set rs = server.CreateObject("Adodb.Recordset") cn.Open conn sqlstring = "Select * From ProductCategories" rs.open sqlstring, cn %> <html> <head> <title>Ricerca</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="style.css" rel="stylesheet" type="text/css"> <link href="images/style.css" rel="stylesheet" type="text/css"> <style type="text/css"> .benven { font-family: Verdana, Geneva, sans-serif; color: #00F; } .benven1 { font-family: Verdana, Geneva, sans-serif; } </style> </head> <body> <div align="center"> <table width="100%" border="0"> <tr bgcolor="#FFFFCC"> <td colspan="2" bgcolor="#6699FF"><div align="center"><font face="Georgia, Times New Roman, Times, serif" class="Titolo_art"><span class="benven">Ricerca Occasioni</span></font><font size="4" face="Georgia, Times New Roman, Times, serif"><br> <img src="../img/Logo04-100x99.png" width="100" height="99"><br> <font color="#0000FF" size="2" class="benven">Sfoglia le occasioni on-line</font></font></div></td> </tr> <tr> <td colspan="2" valign="top"><p class="benven"><strong><a href="default.asp">Home occasioni</a> <a href="https://www.martinucci-regali.com"><br> <br> Home Sito</a></strong></p></td> </tr> <tr> <td width="22%" valign="top"><table width="92%" border="1"> <tr> <td><table width="100%" border="0"> <tr> <td bgcolor="#6699FF"><strong class="benven"><span class="Titolo_art">occasioni</span></strong></td> </tr> <%if not rs.eof then while not rs.eof %> <tr> <td class="benven"><a href="default.asp?cid=<%= rs("CategoryID")%>"><%= rs("CategoryName")%></a></td> </tr> <% rs.movenext wend end if %> </table> <form name="form1" method="post" action=""> <input name="keywords" type="text" id="keywords"> <input type="submit" name="Submit" value="Cerca"> </form> <p> </p> <table width="100%" border="0"> <tr> <td bgcolor="#6699FF"> </td> </tr> </table> <p> </p></td> </tr> </table> <p> </p></td> <td width="76%" valign="top"> <p><SPAN class="benven" closure_uid_i7pyw5="396"><span class="benven">Risultati della ricerca delle occasioni di Martinucci Prima Infanzia</span></SPAN><font color="#FF0000"> <% sqlstring = "Select * From Products Where Details like '%" & request.form("keywords") &_ "%' or productname like '%" & request.form("keywords") & "%'" rs.close rs.open sqlstring,cn,3,3 if not rs.eof then response.Write("Ricerca per '<B>" & request.form("keywords") & "</B>', Totale " & rs.recordcount & " articoli trovati") while not rs.eof %> </font></p> <table width="100%" border="0"> <tr> <td bgcolor="#6699FF" class="Titolo_art"><strong><%=rs.fields("productname")%></strong></td> </tr> <%if rs.fields("image")<>"" then%> <tr> <td height="20"><img name="image" src="\public\immagini\Articoli/<%=rs.fields("image")%>" alt=""></td> </tr> <tr> <%end if%> </tr> <tr> <td class="benven"><%=rs.fields("details")%></td> </tr> </table> <br> <% rs.movenext wend else 'response.Write("No products") end if %> <p> </p> <p> <img src="../img/Logo04-100x99.png" width="100" height="99" align="middle"></p></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2" valign="top" bgcolor="#6699FF"><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" class="benven1">Creato da DaMa SOFTWARE 2012</font></div></td> </tr> </table> </div> </body> </html>
[
Íàçàä
]