 |
เรื่องการ edit และให้มีการ resize สอบถามหน่อยครับ งมมาทั้งคืนเเล้วครับ |
|
 |
|
|
 |
 |
|
ตัวอัฟโหลด ไม่ยอม resize และไปเก็บ ในฐานข้อมูลอะครับ table ฐานข้อมูลชื่อว่า FilesName กับ Thumbnails รบกวนหน่อยนะครับ
Code (PHP)
<?
//*** Update Record ***//
$objConnect = mysql_connect("localhost","root","123456") or die("Error Connect to Database");
$objDB = mysql_select_db("test");
mysql_query("SET NAMES utf8");
$strSQL = "UPDATE test ";
$strSQL .=" SET NAME = '".$_POST["txtName"]."' WHERE id = '".$_GET["id"]."' ";
$objQuery = mysql_query($strSQL);
if(trim($_FILES["filUpload"]["tmp_name"]) != "")
{
$images = $_FILES["filUpload"]["tmp_name"];
$new_images = "Thumbnails_".$_FILES["fileUpload"]["name"];
move_uploaded_file($_FILES["filUpload"]["tmp_name"],"myfile/".$_FILES["filUpload"]["name"]);
$width=100; //*** Fix Width & Heigh (Autu caculate) ***//
$size=GetimageSize($images);
$height=100;
$images_orig = ImageCreateFromJPEG($images);
$photoX = ImagesX($images_orig);
$photoY = ImagesY($images_orig);
$images_fin = ImageCreateTrueColor($width, $height);
ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);
ImageJPEG($images_fin,"myfile/".$new_images);
ImageDestroy($images_orig);
ImageDestroy($images_fin);
{
echo "Resize Successful.<br>";
//*** Update New File ***//
$strSQL = "UPDATE test ";
$strSQL .="(Thumbnails,FilesName) VALUES ('".$new_images."','".$_FILES["filUpload"]["name"]."'
WHERE id = '".$_GET["id"]."' ";
$objQuery = mysql_query($strSQL);
echo "Copy/Upload Complete<br>";
}
}
?>
Tag : PHP, MySQL
|
|
 |
 |
 |
 |
Date :
2011-08-15 10:36:34 |
By :
noppawut |
View :
774 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
Warning: getimagesize(C:\Windows\Temp\php293D.tmp) [function.getimagesize]: failed to open stream: No such file or directory in C:\AppServ\www\adit\PageUploadToMySQL5.php on line 25
Warning: imagecreatefromjpeg(C:\Windows\Temp\php293D.tmp) [function.imagecreatefromjpeg]: failed to open stream: No such file or directory in C:\AppServ\www\adit\PageUploadToMySQL5.php on line 27
Warning: imagesx(): supplied argument is not a valid Image resource in C:\AppServ\www\adit\PageUploadToMySQL5.php on line 28
Warning: imagesy(): supplied argument is not a valid Image resource in C:\AppServ\www\adit\PageUploadToMySQL5.php on line 29
Warning: imagecopyresampled(): supplied argument is not a valid Image resource in C:\AppServ\www\adit\PageUploadToMySQL5.php on line 31
Warning: imagedestroy(): supplied argument is not a valid Image resource in C:\AppServ\www\adit\PageUploadToMySQL5.php on line 33
Resize Successful.
Copy/Upload Complete
View files
error ที่ขึ้นครับ
|
 |
 |
 |
 |
Date :
2011-08-15 10:40:05 |
By :
noppawut |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ได้ละครับ
|
 |
 |
 |
 |
Date :
2011-08-15 11:36:11 |
By :
noppawut |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ครับ คุณวิน ขอบคุณมากครับ
|
 |
 |
 |
 |
Date :
2011-08-15 13:26:48 |
By :
noppawut |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|