Connecting Tech Pros Worldwide Help | Site Map

PHI Interbase or Firebird database

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 17th, 2005, 01:10 AM
UnixUser
Guest
 
Posts: n/a
Default PHI Interbase or Firebird database

I am using the PHP 4.3.4 with a standard (unmodified ) php.ini file.
I am tryong to output a blob field that contains a jpeg image using
the ibase_blob_echo( row[3]) function. The blob field is the 4th
element of my select statement. when I run this through the browser I
get "Warning: ibase_blob_echo(): Invalid blob id in
/wwwroot/htdocs/hello.php" Has anyone seen this error and what can I
do to resolve this?

  #2  
Old July 17th, 2005, 01:11 AM
Randell D.
Guest
 
Posts: n/a
Default Re: PHI Interbase or Firebird database

UnixUser wrote:[color=blue]
> I am using the PHP 4.3.4 with a standard (unmodified ) php.ini file.
> I am tryong to output a blob field that contains a jpeg image using
> the ibase_blob_echo( row[3]) function. The blob field is the 4th
> element of my select statement. when I run this through the browser I
> get "Warning: ibase_blob_echo(): Invalid blob id in
> /wwwroot/htdocs/hello.php" Has anyone seen this error and what can I
> do to resolve this?[/color]

I've never displayed images from the database but I suggest:

1. Are you reading the field (column) by number, or by name - I'm
wondering if you've selected the wrong column. If not, I suggest
reading by column name anyway incase you ever perform an insert it might
send things out of sync.

2. I *believe* (ie I'm not sure) but I think you have to send headers
with the data of your image so the browser knows what you want to do...
Secondly, how are you trying to display the image, is it the result of a
<img src=/hello.php> or some other method.

Failing the above...

3. If the hello.php script isn't too long - share it here as it might
help provide a solution faster.


Hope the above gives you food for thought,
laters
randelld
  #3  
Old July 17th, 2005, 01:12 AM
UnixUser
Guest
 
Posts: n/a
Default Re: PHI Interbase or Firebird database

"Randell D." <please.post.and.share@news.group.com> wrote in message news:<zkhub.420105$pl3.314924@pd7tw3no>...[color=blue]
> UnixUser wrote:[color=green]
> > I am using the PHP 4.3.4 with a standard (unmodified ) php.ini file.
> > I am tryong to output a blob field that contains a jpeg image using
> > the ibase_blob_echo( row[3]) function. The blob field is the 4th
> > element of my select statement. when I run this through the browser I
> > get "Warning: ibase_blob_echo(): Invalid blob id in
> > /wwwroot/htdocs/hello.php" Has anyone seen this error and what can I
> > do to resolve this?[/color]
>
> I've never displayed images from the database but I suggest:
>
> 1. Are you reading the field (column) by number, or by name - I'm
> wondering if you've selected the wrong column. If not, I suggest
> reading by column name anyway incase you ever perform an insert it might
> send things out of sync.
>
> 2. I *believe* (ie I'm not sure) but I think you have to send headers
> with the data of your image so the browser knows what you want to do...
> Secondly, how are you trying to display the image, is it the result of a
> <img src=/hello.php> or some other method.
>
> Failing the above...
>
> 3. If the hello.php script isn't too long - share it here as it might
> help provide a solution faster.
>
>
> Hope the above gives you food for thought,
> laters
> randelld[/color]

I can display the image now from the database, however, I had to
create another scriptfile and requery the database from within that
file. Is there a way to pass the image as a parameter to the
hello.php scriptfile or the row[3] parameter so that I don't have to
requery or reopen the table?
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.