[mouse_catz00]

i need help in my project. i must save picture in mysql database.

[didgy58]

do you have to save pictures or couldnt you just save the image name into mysql and then when u pull the record from the database and would like to view the picture u basically put it in a image tage

<img src="direct to the image folder/ $variable user to hold the sql return['imagename']" />

i think its something along that lines i have the code and ill grab it for u shortly and repost but its something like that off the top of my head

dan

[didgy58]

$pic=$row['Picture'];

><img src='../images/$pic' border=0 alt=''></

thats how i have gone about using images with my database

hope that helps.

[MitkOK]

Alternative way, which I do not prefer :
- http://dev.mysql.com....0/en/blob.html
- http://www.weberdev....ample-3688.html

It's better to upload image in directory and put image path in MySQL field.

[atomixx]

mouse_catz00, on 23 Jan, 2008 - 12:52 AM, said:

i need help in my project. i must save picture in mysql database.

hi mouse
it is hell of a mission to get the jpg data in and out of mysql successfully.
I eventualy uploaded the pics via ftp and inserted the location relative to location of my site.
just be careful it changes between linux and windows.

use this but change the variabls acording to you display page

<img src=<?php echo $row_Recordset1['image']; ?> width="320" height="240" />


linux: sqlentry would be "dir/filename.ext" if the display page is at the root of the site
windows: sqlentry would be "dir\filename.ext" if the display page is at the root of the site

hope this helps

[akozlik]

I wrote a tutorial on this exact thing:

Uploading Images with PHP