Images Manipulasi gambar yang disimpan di database bertipe blob menggunakan PHP

Berikut ini saya akan jelaskan cara menampilkan gambar dibrowser yang dimana gambar tersebut disimpan di database menggunakan tipe data blob.
disini saya menggunakan tabel dengan nama file_peg_user dan file_konten adalah nama field yang menampung gambar dengan tipe blob.
Langsung saja berikut penggalan coding php nya :

1. Langsung download gambar yang ada di database tanpa menampilkan
// download foto function jin_gfile($txt) { $txt = preg_replace("/[^a-zA-Z0-9s.]/", "_", trim($txt)); return $txt; } $id_user = $_GET['id_user']; $query = "SELECT * FROM `file_peg_user` WHERE `id_user`='".$id_user."' LIMIT 1"; $qu = mysql_query($query); $num = mysql_numrows($qu); if($num > 0) { $result=mysql_fetch_object($qu); header("Content-Disposition: attachment; filename=".jin_gfile($result->file_name."")); header("Content-length: ".$result->file_size.""); header("Content-type: ".$result->file_type.""); echo $result->file_content; } else { echo "File tidak valid!"; } 2. Menampilkan gambar orginal di browser
//show foto $id_user = $_GET['id_user']; $sqll= "SELECT * FROM `file_peg_user` WHERE `id_user`='".$id_user."' LIMIT 1"; $query=mysql_query($sqll) or die(mysql_error()); $result=mysql_fetch_array($query); $content=$result['file_content']; header("Content-type: image/jpeg"); echo $content; 3. Resize gambar kemudian ditampilkan gambar
// show foto and resize $id_user = $_GET['id_user']; $sqll= "SELECT * FROM `file_peg_user` WHERE `id_user`='".$id_user."' LIMIT 1"; $query=mysql_query($sqll) or die(mysql_error()); $result=mysql_fetch_array($query); $content=$result['file_content']; $im = imagecreatefromstring($content); if ($im !== false) { header('Content-Type: image/jpeg'); $percent = 1; $width = imagesx($im); $height = imagesy($im); $newwidth = $width * $percent; $newheight = $height * $percent; $img = imagecreatetruecolor($newwidth,$newheight); imagecopyresized($img,$im,0,0,0,0,$newwidth,$newheight,$width,$height); imagejpeg($img); imagedestroy($img); } 4. mengubah resolusi foto kemudian menampilkan gambar
// show foto and resolution $id_user = $_GET['id_user']; $sqll= "SELECT * FROM `file_peg_user` WHERE `id_user`='".$id_user."' LIMIT 1"; $query=mysql_query($sqll) or die(mysql_error()); $result=mysql_fetch_array($query); $content=$result['file_content']; header("Content-type: image/jpeg"); $im = imagecreatefromstring($content); $source_width = imagesx($im); $source_height = imagesy($im); $ratio = $source_height / $source_width; $new_width = 100; // assign new width to new resized image $new_height = $ratio * 100; $thumb = imagecreatetruecolor($new_width, $new_height); $transparency = imagecolorallocatealpha($thumb, 255, 255, 255, 127); imagefilledrectangle($thumb, 0, 0, $new_width, $new_height, $transparency); imagecopyresampled($thumb, $im, 0, 0, 0, 0, $new_width, $new_height, $source_width, $source_height); imagejpeg($thumb, $filename, 9); imagedestroy($im); 5. Mengcrop gambar kemudian menampilkan gambar
// show foto dan crop $id_user = $_GET['id_user']; $sqll= "SELECT * FROM `file_peg_user` WHERE `id_user`='".$id_user."' LIMIT 1"; $query=mysql_query($sqll) or die(mysql_error()); $result=mysql_fetch_array($query); $content=$result['file_content']; header("Content-type: image/jpeg"); $img = imagecreatefromstring($content); $img = mycrop($img, ['x' => 0, 'y' => 40, 'width' =>86, 'height' => 86]); imagejpeg($img); imagedestroy($img);