以下代码是关于搜索功能的,谁能用sp的框架进行发送和接收

#1 初学者

$sql="SELECT * FROM `ysj_information` WHERE `name` LIKE '%{$search}%' order by ysj_id desc";
$query=mysql_query($sql);
$res=array();
  while($search1=mysql_fetch_assoc($query)) {
   $search1['name']=str_replace($search,"{$search}",$search1['name']);//设置高亮显示
   $res[]=$search1;
   }
$num=count($res);

2011-12-02 13:27:43

#2 jake

$result = spClass('ysj_information')->findAll("`name` LIKE '%{$search}%' ", 'ysj_id desc');
$num = count($result);
显示的时候再加所谓的高亮就好。

2011-12-02 13:34:28