writing insert statement for image in php

Question

My DB developer made me a db with a field in the SQL table as image type. I am trying to take the image someone uploads and just insert it in.

$imagePath  = Input::file('image');
$image     =  $imagePath->getPathName();

$image returns the temp path name

$file = fopen($image, "rb");
$content = fread($file, filesize($image));
fclose($file);

$SqlConn =  "INSERT INTO [poll14] ([image]) VALUES ($content)";

But I get this error: An error occurred substituting the named parameters. How am I supposed to be inserting the data in?

You also need to read about, understand and start using parameterized queries. What you have here is wide open to sql injection. — Sean Lange, Jul 22 '16 at 15:27

score 0 · Answer 1 · edited May 23 '17 at 11:45

0

Try this, which is similar to your requirement here

insert into poll14 (ImageColumn) 
SELECT BulkColumn 
FROM Openrowset( Bulk 'image..Path..here', Single_Blob) as img

edited May 23 '17 at 11:45

Community

1
1

answered Jul 22 '16 at 15:46

singhswat

832
7
20

That worked great. Now how can I implement this in a stored procedure? – user1899829 Jul 22 '16 at 16:27
@user1899829 Did u manage to get the stored proc working ? You have forgotten to accept the answer – singhswat Aug 02 '16 at 08:54

writing insert statement for image in php

1 Answers1