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./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./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; } |
|
来自: star_xiong > 《php》