<?php function Thumbnail_String($string, $user_width=86, $user_height=null) { ob_start(); ob_flush(); flush();
$im = imagecreatefromstring( $string ); $orig_width = imagesx($im); $orig_height = imagesy($im); if($orig_width >= $user_width) { if(strlen($user_height) === 0) { $user_height = @round($orig_height*($user_width/$orig_width)); } } else { $user_width = $orig_width; $user_height = $orig_height; } $im_new = imagecreatetruecolor( $user_width, $user_height );
imagecopyresampled($im_new, $im, 0, 0, 0, 0,
$user_width, $user_height, $orig_width, $orig_height); imagepng($im_new); imagedestroy($im); imagedestroy($im_new);
$data = ob_get_contents(); ob_end_clean();
return $data; }
// 이미지를 sql에 저장하기 $file = file_get_contents($_FILES['userfile']['tmp_name']); unlink($_FILES['userfile']['tmp_name']);
$data = Thumbnail_String($file, 50); mysqli_query($link,
"insert into from tbname VALUES('1', 'png', '".$data."');");
// sql에 저장된 이미지를 불러오기 $result = mysqli_query($link, "select thumbs from tbname WHERE id=1;"); $row = mysqli_fetch_array($result, MYSQLI_NUM);
echo "<img src='data:image/gif;base64, ".base64_encode($row[0])."'>";
?>
|