日期:2014-05-17 浏览次数:20900 次
<?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];
}