HOW TO SAVE IMAGE FILE (.jpeg,.gif dll) TO SQL SERVER

alisetan

slm,

nak mintak sifu2 kat sini pesal menda nih.
Task terbaru, bos ali soh ali simpan plak imej(jpeg,gif dll) ke dlm server sql.
kita org guna php sebagai bahasa pengaturcaraan.

lepas dah simpan, kena panggil dalam template word plak (.doc)..

ada sesapa pernah buat tak?

thanks

azradiza

haku penah buat system save images into Oracle db( save as blob ) ..
tapi pastu db jadik slow coz banyak sangat space allocated utk the images..
so kitorang remove the image from db and save dlm directory dlm webserver instead ....
time ni kitorang pakai asp.net ...

alisetan

tuh lah sy pun rs db akan jd slow kalau nak access.

FMKiller

try encode image tuh jadik base 64, then simpan dalam database.

1. <?php
   
2. // function to encode the image
   
3. // returns the image as base64 encoded string
   
4. function encode_img($img)
   
5. {
   
6.     $fd = fopen ($img, 'rb');
   
7.     $size=filesize ($img);
   
8.     $cont = fread ($fd, $size);
   
9.     fclose ($fd);
   
10.     $encimg = base64_encode($cont);
    
11.     return $encimg;
    
12. }
    
13. 
    
14. // use this to split the code into managable pieces
    
15. // if you want to save the string to a file
    
16. $imgcode = chunk_split($encimg,20,'\'.
    
17. \'');
    
18.   
    
19. // function to display the image
    
20. function display_img($imgcode,$type)
    
21. {
    
22.     header('Content-type: image/'.$type);
    
23.     header('Content-length: '.size($imgcode));
    
24.     echo base64_decode($imgcode);
    
25. }
    
26. 
    
27. // use like
    
28. encode_img('path/to/image.gif'); // to encode the image
    
29. display_img($imgcode,'gif'); // to show the image
    
30.   
    
31. ?>

Copy the Code

aku amek kat sini: http://fundisom.com/phparadise/p ... base64_image_encode

ohmalaysia

try encode image tuh jadik base 64, then simpan dalam database.




aku amek kat sini:
FMKiller Post at 15-6-2010 17:37

    thanks 4 da tips.

BorderManager

apasal tak simpan je filename kat db, bila nak download, link kan balik je, sebab kalau simpan dlm db, db jadi besar.....

FMKiller

mungkin sebab memang matlamat nak membagakkn db kot..