日期:2014-05-17 浏览次数:20807 次
<?php $DBserver = "localhost"; $DBname = "new"; $DBuser = "root"; $DBpassword = ""; $con = mysql_connect("localhost","root",""); mysql_query("set names 'gbk'"); mysql_select_db("new"); $query = mysql_query("select page_id,page_text from pagecontents where page_id = 101370") or die(mysql_error() ); while($rows = mysql_fetch_array($query)) { $pid = $rows['page_id']; $ptext = $rows['page_text']; //部分page_text //<img src="../Documents/medies/ESIL_zhaoqifadianrelianghuishou.gif" alt="Image:ESIL_zhaoqifadianrelianghuishou.gif" width="850" height="600" longdesc="/index.php/Image:ESIL_zhaoqifadianrelianghuishou.gif" /> //<img src="../Documents/medies/ESIL_gaowenjiayarechuliliucheng1.gif" alt="Image:ESIL_gaowenjiayarechuliliucheng1.gif" width="550" height="400" longdesc="/index.php/Image:ESIL_gaowenjiayarechuliliucheng1.gif" /> preg_match_all('#width="(\d+)"\s*height="(\d+)"#i',$ptext,$m); if($m[1]>805){ $h=($m[2]*805)/$m[1] ; $k=805; $ptext = preg_replace('/(width=)"(\d+)"(\s*height=)"(\d+)"/i','$1"'.$k.'"$3"'.$h.'"',$m); } mysql_query("set names 'gbk'"); $sql = "update pagecontents set page_text = ('{$ptext}') where page_id = ('{$pid}')"; mysql_query($sql) or die(mysql_error()); } ?>
//部分page_text //<img src="../Documents/medies/ESIL_zhaoqifadianrelianghuishou.gif" alt="Image:ESIL_zhaoqifadianrelianghuishou.gif" width="805" height="568" longdesc="/index.php/Image:ESIL_zhaoqifadianrelianghuishou.gif" /> //<img src="../Documents/medies/ESIL_gaowenjiayarechuliliucheng1.gif" alt="Image:ESIL_gaowenjiayarechuliliucheng1.gif" width="805" height="568" longdesc="/index.php/Image:ESIL_gaowenjiayarechuliliucheng1.gif" />
$page_text =<<< TXT <img src="../Documents/medies/ESIL_zhaoqifadianrelianghuishou.gif" alt="Image:ESIL_zhaoqifadianrelianghuishou.gif" width="850" height="600" longdesc="/index.php/Image:ESIL_zhaoqifadianrelianghuishou.gif" /> <img src="../Documents/medies/ESIL_gaowenjiayarechuliliucheng1.gif" alt="Image:ESIL_gaowenjiayarechuliliucheng1.gif" width="550" height="400" longdesc="/index.php/Image:ESIL_gaowenjiayarechuliliucheng1.gif" /> TXT; echo preg_replace_callback('#width="(\d+)"\s*height="(\d+)"#i', 'back', $page_text ); //$m[1]是width的值 , $m[2]是height的值。 function back($m) { if($m[1]>805){ $h=round(($m[2]*805)/$m[1]); $k=805; return "width=\"$k\" height=\"$h\" "; } return $m[0]; }