Senin, 29 Juni 2009

Simpan Gambar Pada MYSQL

Script untuk menyimpan gambar:

  2. // DATABASE
  3. $db_host = "localhost";
  4. $db_user = "root";
  5. $db_pass = "p455w0rdku";
  6. $db_name = "simpol";

  8. // BAGIAN INI KE BAWAH JANGAN DIUBAH
  9. $link = mysql_pconnect ($db_host, $db_user, $db_pass) or die ("Ga bisa connect");
  10. mysql_select_db ($db_name) or die ("Ga bisa select database");

  12. if (isset($act) && $act == "up_foto") {
  13. $id = trim($nip);
  14. $editFormAction = $_SERVER['PHP_SELF'];
  15. $img_thumb_width = 120;
  16. $path_thumbs = "items/icons";

  18. $file_type = $_FILES['imgfile']['type'];
  19. $file_name = $_FILES['imgfile']['name'];
  20. $file_size = $_FILES['imgfile']['size'];
  21. $file_tmp = $_FILES['imgfile']['tmp_name'];

  23. //check if you have selected a file.
  24. if(!is_uploaded_file($file_tmp)){
  25. echo "

    Anda belum memilih file gambar....."    ;
  26. print "refresh" content="0; URL=?mod=up_foto&nip=$nip">";
  27. exit(); //exit the script and don't do anything else.
  28. }
  29. //check file extension jika salah or bukan gambar langsung keluar
  30. $size =GetImageSize("$file_tmp");
  31. if (($size[2] <>$size[2] > 4)) {
  32. echo '

    Maaf yang Anda pilih bukan gambar'    ;
  33. print "refresh" content="0; URL=?mod=up_foto&nip=$nip">";
  34. exit();
  35. }


  38. //get the file extension.
  39. $getExt = explode ('.', $file_name);
  40. $file_ext = $getExt[count($getExt)-1];

  42. //create a random file name

  44. $rand_name= "tmp";
  45. //get the new width variable.
  46. $ThumbWidth = $img_thumb_width;

  48. //keep image type
  49. if($file_size){
  50. if($file_type == "image/pjpeg" || $file_type == "image/jpeg"){
  51. $new_img = imagecreatefromjpeg($file_tmp);
  52. }elseif($file_type == "image/x-png" || $file_type == "image/png"){
  53. $new_img = imagecreatefrompng($file_tmp);
  54. }elseif($file_type == "image/gif"){
  55. $new_img = imagecreatefromgif($file_tmp);
  56. }
  57. //list width and height and keep height ratio.
  58. list($width, $height) = getimagesize($file_tmp);
  59. $imgratio=$width/$height;
  60. if ($imgratio>1){
  61. $newwidth = $ThumbWidth;
  62. $newheight = $ThumbWidth/$imgratio;
  63. }else{
  64. $newheight = $ThumbWidth;
  65. $newwidth = $ThumbWidth*$imgratio;
  66. }

  68. //function for resize image.
  69. if (function_exists(imagecreatetruecolor)){
  70. $resized_img = imagecreatetruecolor($newwidth,$newheight);
  71. }else{
  72. die("Error: Please make sure you have GD library ver 2+");
  73. }
  74. imagecopyresized($resized_img, $new_img, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
  75. //save image
  76. ImageJpeg ($resized_img,"$path_thumbs/$rand_name.$file_ext");
  77. ImageDestroy ($resized_img);
  78. ImageDestroy ($new_img);

  80. $gb_baru = "$path_thumbs/$rand_name.$file_ext";

  82. ///ini ke bawah buat nyimpen gambar ke database

  84. $fp = fopen($gb_baru, 'r') or die('ga bisa buka gambar');

  86. $data=fread($fp,filesize("$gb_baru"));
  87. $data = mysql_escape_string($data);

  89. $updatesql=mysql_query("UPDATE foto SET FOTO='$data' where NIP='$id'") or die(mysql_error());
  90. }
  91. }
  92. ?>


  95. "100%" border="0" cellpadding="0" cellspacing="1" background="items/bg_gradasi.jpg">

  97. "73%">"items/icons/duk.gif" hspace="5" align="absmiddle" /> EDIT FOTO
  98. "27%" align="center">


  101. "POST"
     enctype="multipart/form-data" action="?mod=up_foto&nip=&act=up_foto">
  102. "58%" border="0" align="center">

  104. "176" rowspan="3" align="center" valign="middle">"3" border="0">


  107. "100%" bgcolor="#999999">"0" cellpadding="3" width="100%" border="0">


  110. "#ededed">"?mod=up_foto&nip=">"modul/foto.php?nip=" alt="Foto" name="foto" border="3" id="foto" />

  112. "23" colspan="2" valign="bottom">Silahkan klik "Browse" dan pilih foto yang baru, kemudian klik "Submit".


  115. "23" colspan="2" valign="bottom">"imgfile" type="file" id="imgfile" size="35" />


  118. "310" valign="middle">

  120. "66" align="center" valign="middle">"submit" name="Submit" value="Submit" />



Tampil Gambar

DATABASE
  1. $db_host = "localhost";
  2. $db_user = "root";
  3. $db_pass = "p455w0rdku";
  4. $db_name = "simpol";

  6. // BAGIAN INI KE BAWAH JANGAN DIUBAH
  7. $link = mysql_pconnect ($db_host, $db_user, $db_pass) or die ("Ga bisa connect");
  8. mysql_select_db ($db_name) or die ("Ga bisa select database");


  11. require_once ('../inc/db.php');
  12. $sql = mysql_query("SELECT NIP,FOTO FROM foto where foto.NIP = "$nip" ") or die(mysql_error());

  14. while ($res=mysql_fetch_array($sql)) {
  15. echo $res['FOTO'];
  16. }
  17. mysql_free_result($sql);

  19. ?>

Kemudian struktur databasenya sebagai berikut:

  1. CREATE TABLE `foto` (
  2. `NIP` varchar(27) NOT NULL default '',
  3. `FOTO` longblob,
  4. PRIMARY KEY (`NIP`)
  5. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)