我有一个基于会员的网站,我建立了一个系统,注册用户可以提交评论。这些将使用PHP提交到MySQL数据库,然后查询到评论页面,如review. PHP ?id=246。但是,我希望用户能够上传图像,将图像存储在服务器上的文件夹中,将文件名存储在MySQL数据库中,然后将其全部查询到我的review.php页面上。我该怎么做呢?
提前感谢各位!
假设您有一个列为id, review_id, img
的表。另外,id列必须是自增的int。创建如下文件夹:"photos
"包含"original"one_answers"resized
"两个文件夹。
下面的代码将调整图像大小,保存原始图像和调整后的图像,并将其地址设置为db表。我希望它对你有用。
<?php
/* DB connection*/
require 'db.php';
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %sn", mysqli_connect_error());
exit();
}
/*registration sheck*/
$submit=$db->real_escape_string( $_POST['submit']);
$review=$db->real_escape_string($_POST['review']);
function createThumb($upfile, $dstfile, $max_width, $max_height){
$size = getimagesize($upfile);
$width = $size[0];
$height = $size[1];
$x_ratio = $max_width / $width;
$y_ratio = $max_height / $height;
if( ($width <= $max_width) && ($height <= $max_height)) {
$tn_width = $width;
$tn_height = $height;
} elseif (($x_ratio * $height) < $max_height) {
$tn_height = ceil($x_ratio * $height);
$tn_width = $max_width;
} else {
$tn_width = ceil($y_ratio * $width);
$tn_height = $max_height;
}
if($size['mime'] == "image/jpeg"){
$src = ImageCreateFromJpeg($upfile);
$dst = ImageCreateTrueColor($tn_width, $tn_height);
imagecopyresampled($dst, $src, 0, 0, 0, 0, $tn_width, $tn_height,$width, $height);
imageinterlace( $dst, true);
ImageJpeg($dst, $dstfile, 100);
} else if ($size['mime'] == "image/png"){
$src = ImageCreateFrompng($upfile);
$dst = ImageCreateTrueColor($tn_width, $tn_height);
imagecopyresampled($dst, $src, 0, 0, 0, 0, $tn_width, $tn_height,$width, $height);
Imagepng($dst, $dstfile);
} else {
$src = ImageCreateFromGif($upfile);
$dst = ImageCreateTrueColor($tn_width, $tn_height);
imagecopyresampled($dst, $src, 0, 0, 0, 0, $tn_width, $tn_height,$width, $height);
imagegif($dst, $dstfile);
}
}
if($submit){
$result = $db->query("INSERT INTO reviews (`review_id`) VALUE '$review'") or die($db->error));
$review_id = $db->insert_id;
if(isset($_FILES['upload_Image']['name']) && $_FILES['upload_Image']['name']!=='') {
$ext = substr($_FILES['upload_Image']['name'], strpos($_FILES['upload_Image']['name'],'.'), strlen($_FILES['upload_Image']['name'])-1);
$imgNormal = 'img'.$new_user_id.$ext;
$normalDestination = "photos/original/" . $imgNormal;
$httprootmedium = "photos/resized/" . $imgNormal;
move_uploaded_file($_FILES['upload_Image']['tmp_name'], $normalDestination);
createThumb($normalDestination,$httprootmedium,200,300); #For 500x300 Image
}
$result = $db->query("UPDATE review SET img='$imgNormal' WHERE id='$review_id'") or
?>