Writing a Blob in PHP to a SQL Server using MSSQL

Question

I have a set of AMFPHP services which receive from a Flex application a bytearray containing an image. So far so good. Now I need to write the bytearray to a blob field in a SQL Server database. I am using the MSSQL library and I cannot change that. How can I do that?

What code do you have now for the byte array in PHP?

mimicocotopus
– mimicocotopus

2012-08-31 21:01:24 +00:00
Commented Aug 31, 2012 at 21:01 — mimicocotopus
– mimicocotopus, Commented Aug 31, 2012 at 21:01

Eduardo Mauro · Accepted Answer · 2012-09-04 17:48:23Z

1

Below the solution:

// Stores bytearray received from a Flex app through AMPPHP

$arrData = unpack("H*hex", $image->data);
$content = "0x".$arrData['hex'];

$sql = "insert into Images (Id, ImageData) values ($id, $content)";
mssql_query($sql);

answered Sep 4, 2012 at 17:48

Eduardo Mauro

1,5151 gold badge26 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Writing a Blob in PHP to a SQL Server using MSSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related