php缩略显示数据,PHP上传图片同时生成缩略图和插入数据库

$FileExtName =

strtolower(pathinfo($_FILES['url']['name'],PATHINFO_EXTENSION));

if(!(($FileExtName == 'gif') or ($FileExtName == 'jpg') or ($FileExtName

== 'jpeg') or ($FileExtName == 'png'))){

echo "";

echo " alert('您上传的文件类型不对，本系统仅支持PNG，JPG，GIF三种格式。');";

echo " location='../uploadpicture.php?albumID=$albumID';";

echo "";

exit;

}

$Filename = date("YmdHis").substr(microtime(),2,5).'.'.$FileExtName;

$PictureDir =

substr(pathinfo($_SERVER['scrīpt_FILENAME'],PATHINFO_DIRNAME),0,strlen(pathinfo($_SERVER['scrīpt_FILENAME'],PATHINFO_DIRNAME))-8);

$UploadURL = $PictureDir.'/'.$PictureFolder.$Filename;

$ThumbsURL = $PictureDir.'/'.$ThumbsFolder.$Filename;

if (!move_uploaded_file($_FILES['url']['tmp_name'], $UploadURL)){

echo "";

echo " alert('上传失败，图片大小不能超过 $MAX_FILE_SIZE KB。');";

echo " location='../uploadpicture.php?albumID=$albumID';";

echo "";

exit;

}

list($RealWidth, $RealHeight) = getimagesize($UploadURL);

if($RealWidth < $MaxThumbWidth){

$percent = 1;

} else {

$percent = $MaxThumbWidth / $RealWidth;

}

$NewWidth = $RealWidth * $percent;

$NewHeight = $RealHeight * $percent;

$thumb = imagecreatetruecolor($NewWidth, $NewHeight);

list($width, $height, $PictureType, $attrib) = getimagesize($UploadURL);

switch($PictureType)

{

case "1": $source = imagecreatefromgif($UploadURL); break;

case "2": $source = imagecreatefromjpeg($UploadURL); break;

case "3": $source = imagecreatefrompng($UploadURL); break;

}

imagecopyresized($thumb, $source, 0, 0, 0, 0, $NewWidth, $NewHeight,

$RealWidth, $RealHeight);

switch($PictureType)

{

case "1": imagegif($thumb, $ThumbsURL); break;

case "2": imagejpeg($thumb, $ThumbsURL); break;

case "3": imagepng($thumb, $ThumbsURL); break;

}

$newpicture_SQL = "INSERT INTO pictures

(flag,title,url,descrīption,uploadtime,updatetime,isvisible,iscommend)

VALUES

('$albumID','$title','$Filename','$descrīption','$uploadtime','$uploadtime','$isvisible','$iscommend');";

$setCover = "Update pictures SET url = '$Filename' WHERE id =

$albumID;";

$totalPictures_SQL = "SELECT * FROM pictures WHERE flag = $albumID;";

$totalPictures = mysql_query($totalPictures_SQL, $hesweb) or

die(mysql_error());

$totalRows_totalPictures = mysql_num_rows($totalPictures);

$newpicture = mysql_query($newpicture_SQL, $hesweb) or

die(mysql_error());

$pictureID = mysql_insert_id($hesweb);

$coverFlag = "UPDATE pictures SET iscover = '1' WHERE id = $pictureID;";

if($totalRows_totalPictures < 1){

$cover = mysql_query($setCover, $hesweb) or die(mysql_error());

$flag = mysql_query($coverFlag, $hesweb) or die(mysql_error());

}

if($coverFlag){

echo "";

echo " alert('上传成功。');";

echo " location='../uploadpicture.php?albumID=$albumID';";

echo "";

}

?>