Aug
07
2013
批量处理文章内容
<?php
require_once (dirname ( __FILE__ ) . "./include/common.inc.php");
$dsql = "select aid,body from hk_addonarticle";
$db->Execute ( 'me', $dsql );
$Result=array();
while ( $arr = $db->GetArray () ) {
$body=preg_replace("/onclick=('|\")?(.*)\\1/sU",'',$arr ['body']);
$body=str_replace("style=\"cursor:pointer\" ","",$body);
$sql ="update hk_addonarticle set body='{$body}' where aid ={$arr['aid']};";
$rs = $db->ExecuteNoneQuery2($sql);
$Result[$rs][]=$arr['aid'];
//echo $arr['aid'] .'->'.$rs.'<hr/>';
}
foreach($Result as $key=>$Array){
if($key!="1"){
echo $key.'<hr/>';
foreach($Array as $val){
echo "<p>{$val}</p>";
}
}
}
?>
微信扫一扫，打赏作者吧～
最活跃的读者