当前位置：首页 > CMS教程 > phpcms > 列表

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

发布:smiling　来源: PHP粉丝网　添加日期：2014-10-20 14:56:02　浏览: 评论：0　

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

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

//phpfensi.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);