function search($keyword){
$keyword = iconv ( "UTF-8", "gb2312", $keyword );
$db = 'data/xxx.asp';
$conn = new COM('ADODB.Connection') or die('数据库连接错误!');
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");
$sql = "select * from xxx WHERE xian='1' and (xinhao like '%".$keyword."%' or cpname like '%".$keyword."%')";
$rs = $conn->Execute($sql);
while(!$rs->EOF){
$product['title'] = $rs->Fields['xinhao']->Value;
$product['title'] = iconv ( "gb2312", "UTF-8", $product['title']);
$product['pic'] = "
http://www.xxx.com/photo/xxx/x/".$rs->Fields['tu']->Value.".jpg";
$product['code'] = $rs->Fields['cpname']->Value;
$product['code'] = iconv ( "gb2312", "UTF-8", $product['code']);
$product['url'] = "
http://www.xxx.com/gscp.asp?id=".$rs->Fields[0]->Value;;
$record[]=array('title' =>$product['title'],'description' =>$product['code'],'picurl' => $product['pic'],'url' =>$product['url']);
$rs->MoveNext();
}
$rs->Close();
$rs = null;
return $record;
}
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。