4、修改代碼操作 1、查找： //刪除數(shù)據(jù)庫的內(nèi)容 在前面添加以下代碼：

//刪除縮略圖 if($arcRow['litpic']!=""){ $dsql->ExecuteNoneQuery("Delete From sq_uploads where url='$arcRow[litpic]'"); $truedir = GetTruePath($arcRow['siterefer'],$arcRow['sitepath']); $litpicfile = $truedir.$arcRow['litpic']; @unlink($litpicfile); }//刪除大圖 $arcbodyQuery = "Select * from ".$arcRow['addtable']." where aid='$aid'"; $arcbodyRow = $dsql->GetOne($arcbodyQuery); $imgsrcarray=GetImageSrc($arcbodyRow['body']); foreach ($imgsrcarray as $v) { if((trim($v)!="")&&(!eregi("^http://",$v))){ $dsql->ExecuteNoneQuery("Delete From sq_uploads where url='$v'"); $truedir = GetTruePath($arcRow['siterefer'],$arcRow['sitepath']); $picfile = $truedir.$v; @unlink($picfile); } }

Select a.ID,a.title,a.typeid,

Select a.ID,a.title,a.typeid,a.litpic,

//刪除文章同時刪除大圖函數(shù)function GetImageSrc($body){ if( !isset($body)) return; else{ preg_match_all("/<(img|IMG)(.*)(src|SRC)=["|'|]{0,}([h|/].*(jpg|JPG|gif|GIF))["|'|s]{0,}/isU",$body,$out);return $out[4]; } }