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

2020-10-10 21:15:58

字体：大中小

来源：转载

供稿：网友

由于一些采集的原因,需要写一段代码用于完善,代码不重要,重要的是能够完成当前任务即可,记录~ 备用,代码如下:

$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);