Re: how to get blobs from SELECT in interbase with php?

Max Derkachev <kot@books.ru> wrote: > I am wondering how could i get blob value from interbase with php, > e.g. : > $query = "select blob_field from sometable"; > $sth = ibase_query($dbh, $query); > $res = ibase_fetch_object($sth); > print $res->BLOB_FIELD; > > now, when i do so, I get several bytes (i guess it's a beginning of the > blob). To get the blob data you have to do $bid = ibase_blob_open($res->BLOB_FIELD); $blobdata = ibase_blob_get($bid, $length); ibase_blob_close($bid); But so far as I know there is no way to put blob data into the table through php, because of a bug concerning the handling of binding args in ibase_query(). Please let me know if you find a way ... Lutz -- ibWebAdmin 0.2alpha *** web-based InterBase database administration *** download the latest version from http://home.knuut.de/lb/ ***