Home > Article > Backend Development > A complete PHP image upload, thumbnail generation, and database code insertion process_PHP tutorial
A complete PHP image upload, thumbnail generation, and database code insertion process_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:40:571016browse
The following is a complete code written in PHP to upload images while generating thumbnails and inserting them into the database.
$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 "
echo " alert(The file type you uploaded is wrong, this system only supports PNG , JPG, GIF three formats);";
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(Upload failed , the image size cannot exceed $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(Upload successful.);";
echo " location=../uploadpicture.php? albumID=$albumID;";
echo "
}
?>
I hope you can gain something from the above code.