PHPCMS V9批量数据库修改图片集或缩略图代码

由于一些采集的原因,需要写一段代码用于完善,代码不重要,重要的是能够完成当前任务即可,记录~ 备用,代码如下:
 
$link=mysql_connect('localhost','root','root') or die('mysql_error');
$db=mysql_select_db('notebook') or die ('db_error');
$sql="select * from v9_qqxyk_data order by id limit 10000,1000";
$result=mysql_query($sql);
 
function loseSpace($pcon){
 $pcon = preg_replace("/ /","",$pcon);
 $pcon = preg_replace("/ /","",$pcon);
 $pcon = preg_replace("/　/","",$pcon);
 $pcon = preg_replace("//r/n/","",$pcon);
 $pcon = str_replace(chr(13),"",$pcon);
 $pcon = str_replace(chr(10),"",$pcon);
 $pcon = str_replace(chr(9),"",$pcon);
 return $pcon;
}
 
while($rows=mysql_fetch_array($result))
{
$str="$rows[tpzs]";
$str=loseSpace($str);
echo $rows['id']."<br>";
//Cuoxin.com
$pattern="/<[img|IMG].*?src=[/'|/"](.*?(?:[/.gif|/.jpg]))[/'|/"].*?[//]?>/";
preg_match_all($pattern,$str,$match);
$pic=$match[1][0];
$dbn=mysql_select_db('phpcms_liuxue') or die ('db_error');
$sqln="UPDATE `phpcms_liuxue`.`v9_qqxyk` SET `thumb` = '$pic' where id=$rows[id]";
$resultn=mysql_query($sqln);