<?php
set_time_limit(900);
$host=
$dbuser=
$dbpass=
$database=
//填写自己的mysql库连接
$strsql='Select localPath ,fileName,id,fromUrl from news_image where istrue=0 order by dateCreated desc ';
//查询图片
$array1=getResultSetData($strsql);
if(count($array1)>1){
foreach($array1 as $arr)
{
$imgurl=$arr[0]."/" .$arr[1];//图片本地路径
if(file_exists($imgurl))//判断本地
{
if(filesize($imgurl)<500)//图片大小小于500bite
{
unlink($imgurl);//删除图片
}
}
else
{
$dir=$arr[0];
mkdirm($dir);
echo "</br>".$arr[3];
$url=$arr[3];
if($fp=@fopen($url,"r"))
{
$img=GrabImage($url,$imgurl);
echo "<br>";
echo $img.': '.filesize($img).' bytes';
echo "<br>";
if(filesize($img)<500)
{
unlink($img);
}
if($img):echo '<pre><img src="'.$img.'"></pre>';else:echo "false";endif;
}}
}}
else
{
echo "图片都已经标记了!!";
}
function file_type($file,$type){
return eregi("/.($type)$",$file);
}
?>
<?
#########################
//保存远端图象
#########################
function GrabImage($url,$filename) {
if($url==""):return false;endif;
if($filename=="") {
$ext=strrchr($url,".");
// if($ext!=".gif" && $ext!=".jpg"):return false;endif;
$filename=date("dMYHis").$ext;
}
ob_start();
readfile($url);
$img = ob_get_contents();
ob_end_clean();
$size = strlen($img);
$fp2=@fopen($filename, "a");
fwrite($fp2,$img);
fclose($fp2);
return $filename;
}
?>
############################################
#获取strSql记录集存入数组中
############################################
function getResultSetData($strsql) {
global $dbuser,$dbpass,$host,$database,$printsql;
$link = mysql_connect($host,$dbuser,$dbpass);
if(! $link){
return mysql_error();
}
mysql_select_db($database);
/*mysql_query("SET NAMES UTF8"); */
if($printsql) echo "<hr/>".$strsql."<hr/>";
$result = mysql_query($strsql);
if(mysql_num_rows($result)==0){
mysql_close($link);
return "";
}
while($myrow = mysql_fetch_array($result)){
$ret[]=$myrow;
}
mysql_close($link);
return $ret;
}