天天看點

php過濾div标簽内容,用PHP 操作ACCESS 過濾字段DIV不要的内容

set_time_limit(0);

function getContent($Content){

return preg_replace("/(.*?)/si","",$Content);

}

$mdb=new com("adodb.connection");

$mdb->open("driver={microsoft access driver (*.mdb)}; dbq=D:\\php\\htdocs\\tg\\www\\db\\db.mdb");

Echo "

PhpMDB";

Echo "";

$result=$mdb->execute("select * from picture");

while(!$result->eof){

$desc = trim((string)$result->fields("pic_desc"));

$desc = getContent($desc);

$id = (int)$result->fields("pic_id");

$sql = "update picture set pic_desc='".$desc."' where pic_id=".$id;

$mdb->execute($sql);

echo $sql."

";

$result->movenext();

}

$mdb->close;

exit;

?>