下面是PHP編寫上傳圖片同時生成縮略圖和插入數據庫的一個完代碼。
<?php
$title = $_POST[title];
$descrīption = $_POST[descrīption];
$albumID = $_POST[albumID];
$iscommend = $_POST[iscommend];
$isvisible = $_POST[isvisible];
$uploadtime = date("Y-m-d H:i:s");
$MAX_FILE_SIZE = floor($_POST[MAX_FILE_SIZE] / 1024);
$FileExtName = strtolower(pathinfo($_FILES[url][name],PATHINFO_EXTENSION));
if(!(($FileExtName == gif) or ($FileExtName == jpg) or ($FileExtName == jpeg) or ($FileExtName == png))){
echo "<scrīpt language=javascrīpt>";
echo " alert(您上傳的文件類型不對,本系統僅支持PNG,JPG,GIF三種格式。);";
echo " location=../uploadpicture.php?albumID=$albumID;";
echo "</scrīpt>";
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 "<scrīpt language=javascrīpt>";
echo " alert(上傳失敗,圖片大小不能超過 $MAX_FILE_SIZE KB。);";
echo " location=../uploadpicture.php?albumID=$albumID;";
echo "</scrīpt>";
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 "<scrīpt language=javascrīpt>";
echo " alert(上傳成功。);";
echo " location=../uploadpicture.php?albumID=$albumID;";
echo "</scrīpt>";
}
?>
看啦上面的代碼希望大家能有所收獲。