save image to database in php direct from a url

Question

I have tried to download images to a directory but now I want to save the images to the database using BLOB type by not using the File Chooser. I mean save the images direct from a URL:

Say:

http://someserver.com/images/imageone.gif

How can I save that directly to database? Do I have to download it first before saving to database? Please help me..

as stated above, i tried downloading the images to a directory which actually works and also tried to insert image to database using the file chooser in which you select the images from your local machine and submit (insert to database, also worked) I wanted to save it automatically straight from a URL..is it possible? — silent_coder14
– silent_coder14, Commented Jun 21, 2012 at 13:04
@silent_coder14, you mentioned that you succed to insert image to DB using file chooser, how did you do that?. I'm trying to insert image base64 url(which is realy large) using text type but it's not working. Can you help me? — nermiiine
– nermiiine, Commented Oct 3, 2017 at 8:45

Attila Szeremi · Accepted Answer · 2012-06-21 13:06:02Z

4

Like you would save any other data.

$imageContents = file_get_contents('http://someserver.com/images/imageone.gif');
$imageContentsEscaped = mysql_real_escape_string($imageContents, $link);
mysql_query("INSERT INTO table_name (imageData) VALUES ('$imageContentsEscaped')", $link);

Make sure the column you want to save the image data to is set to a binary type such as BLOB.

answered Jun 21, 2012 at 13:06

Attila Szeremi

5,4986 gold badges43 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

disjunction · Accepted Answer · 2012-06-21 13:17:33Z

1

// download image to memory
$image = file_get_contents('http://example.com/my/image.jpg');

// open PDO connection
$db = ...;

// insert downloaded data to the DB
$sql = 'insert into my_table(filename, content) values (?,?)';
$stmt = $db->prepare($sql);
$stmt->bindParam(1, 'my/image.jpg');
$stmt->bindParam(2, $image, PDO::PARAM_LOB);
$stmt->execute();

answered Jun 21, 2012 at 13:17

disjunction

6765 silver badges9 bronze badges

Collectives™ on Stack Overflow

save image to database in php direct from a url

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related