saving graphic files

Anon

hello guys, i am new to php and i am currently doing an e-commerce website. i was wondering how do we store an image file in MYSQL database, as far as i know, you can only store the path of your graphic files and how do i do that???
and one more question, how do i do attachments like how HOTMAIL does??..i mean with those pop up windows where it allows u to browse to the source and up load it??

thanks

Anon

Hi
You can store pics as BLOBs in the DB. I would recommend against it for performance reasons.

You can store the path to the pic easily.
I store the images in a folder called IMAGES and then store the path as a string, "/images/pic1.gif"

Then, when retreiving the image to the page,
strImage = $row["imagepath"];
echo strImage

this places the image on the browser.

hth
Bastien

Anon

hello :
if you can upload file in your server directory. I think to save your file path in database is not too hard. you only to get upload file name and save file name.

If you have any question in these topic.
We can talk about it ...

Casper

Anon

I know u still wonder how u attach a file to ur mail

Currentl i am working on it and mail the code soon....

As far as this image concept is concerned u can upload a image to a folder upload and insert the name in DB..

now fetch the result from Db and
<img src=upload/$image>

Mandar Kelkar

Anon

I can upload this image and to get file name to save in DB. So this is not problem in my code.
Sorry, i don't know your question and what's means?

Casper

Anon

hello guys
thanks for the help.
Casper...my question is hard to understand right?. so let me explain more in detail.
i am currently doing a e-commerce which sells handphones and PDAs for my project. So let say that i am an administrator for the site and i want to add new handphone models pictures and the details to the database.
Let say my pictured folder is localhost/phoneproject/picture
now i have the pictures in a diskette..
so how do i make it posibble like how did HOTMAIL did by poping up a window for you to browse to the source and then upload it to the localhost/phoneproject/picture directory and save the path to the database
i hope u understand my question now..
thanks

Anon

It's looks easy to solve your problem.
you only to get file name and save file name in DB.And copy(source path,save path) function is easy to solve your problem.
1.The "source path" is client PC file path that you went to upload .
2."save path" is your save path in your web server or anywhere.Like this.."http://localhost/xxx/zzz"
the "xxx and zzz" is in c:/apache/htdocs/your web server/xxx/zzz
when you upload file ,the file will save in zzz folder.And you can use
strrchr() get upload file name.
When you get file name you must remember to
add this file name in "save path" LOOK like
$file_name=strrchr($source_path,"\");
copy($source path,$save_path.$file_name);
"\" is microsoft OS .If you use linux ..
use "//".
i hope it's can help you.