分享

PHP连Access数据库(ADODB)

 star_xiong 2013-07-15
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;
}

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约