keyword=EnCode(request("keyword"))
set rs=server.CreateObject("adodb.recordset")
sqlstr="select s.id,s.OrderNum,s.fullPinyin,s.spotsName,(select city.cityName from [tb_City] city where city.id=s.cityID) cityName,(case s.TimeInterval when 1 then '夜间' else '白天' end) TimeInterval,s.teamPrice,s.fitPrice,s.editDate from tb_Spots s where s.useType=0"
if keyword<>"" then
sqlstr=sqlstr&" and (s.spotsName like '%"&keyword&"%' or s.contents like '%"&keyword&"%')"
end if
sqlstr=sqlstr&" order by s.OrderNum asc,s.id desc"
rs.open sqlstr,conn,1,1
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
$_REQUEST["Parameter name"], get the requested parameters
new PDO("mysql:host=database address;dbname=table name","database account","database Password");
prepare("SQL statement to be executed")
fetchAll(PDO::FETCH_ASSOC);//Get the result array
This is asp, right? This is a way to receive the data sent by the form, and then query the database based on this data.