picture into mySQL...?

[Anon]

Is it possible to only type the link to a picture on a internet server, then press the submit button, and then get the picture at the chosen link, and upload it to MY server..? and into my MySQL database...?

[[deleted]]

Yes.

Try searching the articles section.

[Anon]

Well, I don't know if you understood what I ment, or I didn't find what you ment I should find...!??!?!.. but.. if I find a picture at www.domain.com/img.gif and want to upload THAT picture into MY database, is it then possible to just type the http location in a form field, and then when I press submit, can it then get the picture FROM the other server and into MY database..`???

[[deleted]]

Well, that function is not in any scripts on this site, but it does contain the functions to upload data into your database.

First, you probably don't want to upload image into the database in the first place, a database is not the place to store pictures.

Second, you can use fopen to open a filepointer to an image and simply safe the file to disk.
From there, uploading to the database is a doddle.

look at "storing binary data in a database"

[Anon]

Thanks.. but.. what is the best way to upload a picture to my own server without using a ftp program. Is it easy to make a "script" that does it..? on the web..?

And..why shouldn't pictures be stored in a database..??

[[deleted]]

The best way IS to use an FTP program.
The second method would be to use the HTTP upload feature (as described in the manual and the articles)

And the method I guess you are looking for is to let your script download the file from wherever it is located through HTTP or FTP. (fopen)

Why shouldn't you put images in a database?
Because a database is designed to let you search and access data.
If you upload images into it all you are doing is creating a fancy-filesystem.
You already have a filesystem on your harddisk, so uploading the images to a database only adds the overhead of the database, making it slower and using more resources.
The most common solution is to store the file on disk as a normal file, and only store the location of that saved file in the database. That still lets you search for the image in the database, but once you found it the image can be accessed directly from disk. Saves you time and resources.