mysql教程_connect('localhost','root','root') or die('database connect failer');
mysql_select_db('m');
mysql_query("set Names 'gb2312'");
$sql = "Select aid,introduce from d_addonsoft order by aid desc limit 0,2";
$query = mysql_query( $sql );
while( $rs = mysql_fetch_array( $query ) )
{
$body = keywords($rs['introduce'],$array);
$s ="Update d_addonsoft set introduce ='$body' where aid=".$rs['aid'];
mysql_query($s);
echo $body,'<br />';
}
$array = array(
array('aa','/bb/'),
array('cc','111cnnet')
);
$str ='bb 矢量 cc 矢量素材';
echo keywords($str,$array);
function keywords( $str,$array )
{
$count =0;
foreach($array as $v){
echo $v[0],'<br/>';
if(strstr($str,$v[0])!==false){
if( $count <=2 ){
$str=preg_replace("/$v[0]/","<a href=".$v[1]." target=_blank >".$v[0]."</a>",$str,1);
$count++;
continue;
}
}
}
return $str;
}
?>