Insert image into a database

See all posts Reply

Insert image into a database new!
# Reply
by Andrea, 16 years, 2 months ago
Hi,

how can I insert the resized image into a database?

Thanks a lot for your help!Reply
Re: Insert image into a database new!
# Reply
by Andrea, 16 years, 2 months ago
I'm actually using this code:

if ($handle->processed) {
  // everything was fine !
  echo 'file uploaded with success';
  echo '';
  $info = getimagesize($handle->file_dst_pathname);
  echo '  ' . $info['mime'] . ' '. $info[0] . ' x ' . $info[1] 
    .' - ' . round(filesize($handle->file_dst_pathname)/256)/4 . 'KB';
  echo 'Image Uploaded!';
  $idprogetto=$_POST["idprogetto"];
  $caption=$_POST["caption"];
  $buy=$_POST["buy"];
  $insert="INSERT INTO `images` (id,idproject,caption,buy,link)".
   "    VALUES (' ','$idproject','$caption','$buy',".
   "'".$handle->file_dst_name."')";
  $risult=mysql_query($insert, $link);
}
Reply
Re: Insert image into a database new!
# Reply
by colin, 16 years, 2 months ago
What is not working in your code? Do you want to store the image itself in the database, or simply the image path?Reply