Interbase Blobs

Anon

Hi,

Can anyone help me, we are trying to write simple memo blobs into an interbase database using php4. We have tried the following example found on a PHP website:-

$blob_id = ibase_blob_create();
ibase_blob_add($blob_id, "string1");
ibase_blob_add($blob_id, "string2");
ibase_blob_add($blob_id, "string3");
$blob_id_str = ibase_blob_close($blob_id);

ibase_query("INSERT INTO BLOB_TABLE (BLOB_NUM, BLOB_1) VALUES (1, ?)",$blob_id_str);

Unfortunately when we run this script the web page is never displayed. We don't get an error or any kind of response. The table exists and the blob is defined as text. We take the blob out and all works fine. Has anyone actually had blobs working in PHP. Are we missing something or is there something we need to put in the php.ini file. All other interbase functions work so I know the php_interbase.dll is installed. We are have tried this on Windows 2000 server (linked with PHP.EXE [CGI]) and a Linux Raq4 box.

Thanks

Simon Farmer

Anon

Ciao,

I'm experiencing the same problem with interbase blobs and php4,
maibe, do You have some other info about???

franco.

Anon

Hi,

Yep solved the problem.

The lockup is cause by the way PHP/Interbase handles placeholders. Now as far as I can remember, this bug is listed to have been fixed (in CVS) the middle of last year but doesn't seem to have filtered down to the latest PHP 4 until now. If you are using Linux then simply recompile the latest 4.0.4 and install. If you are using Windows 9X/NT/2000 then install the lastest binary archive found at www.php.net/downloads.php

If you need anymore info on interbase then please jot me a line as I have spent quite some time on it now using PHP and have solved most problems.

Thanks,

Simon.

Anon

First, sorry for mu elementary english.

Thank You a lot for replay,

I've so installed on my linux box the new PHP 4.0.4 module, recompiled and installed with no problem, but I'm getting the same problem.

Here is a code portion of my uploader for interbase binary blob field:

if( isset( $HTTP_POST_VARS['id'])
&& is_readable( $HTTP_POST_FILES['binary']['tmp_name'] ))
{
$conn= ibase_connect('localhost:/HTTP/common/gdb/prova.gdb'
,$LOGON, $LOGONPWD );

$fh= fopen( $HTTP_POST_FILES['binary']['tmp_name'], "r" );

$blob_id_str= ibase_blob_import( $conn, $fh );

// the above line will output something like: blob_id_str= X ""|¾&
echo 'blob_id_str= ' . $blob_id_str . '<br>';

// the above line will output something like: hex blob_id_str= 580d2208040e2208000000007cbe260800000000

echo 'hex blob_id_str= '. bin2hex( $blob_id_str ). '<br>';

// now, when try to inserting:
ibase_query( "insert into filestore(id,binary) values ('". $HTTP_POST_VARS['id'] ."',$blob_id_str)");
fclose( $fh );
// an error occour:
// PHP Warning: InterBase: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 49 "" in prova.phtml on line 36

the same result I'm experiencing using ibase_open and close, alwais, the returned blob_id_str seems to be pure binary.

Thank You for interest.

Franco

Anon

Hi,

Yep no problem, the problem you are having is that you need to use a place holder.

Blobs can't be handled by a query statement in Interbase, there are special blob commands. This is fine because they have been implemented in PHP.

In the VALUES part of you query you need to put a ? which basically tells PHP that more work is required. Then as the second, third, etc parameter of you ibase_query needs to be the blob id's, in your case $blod_id_str.

Heres the actual query statement that you should use:-

ibase_query( "insert into filestore(id,binary) values ('". $HTTP_POST_VARS['id'] ."', ? )",$blob_id_str);

If you have anymore problems then please don't hesitate to contact me. :-)

Thanks

Simon

PS. Have you done any work with magic quotes as I have enabled these in the PHP.INI on our Linux box and they don't seem to work whereas they do on a Windows Box? If you haven't seen the docs about magic quotes then please drop me a bell where I will explain what they do.

Anon

Ciao,
First, sorry for my elementary english.

So simple??

Yes, simple with Your explication the problem was solved!

Tank You very mutch.

Franco