Entry

How do I insert an image into an Interbase database?

Mar 28th, 2001 00:26
Tomeu Vidal, sriki g, Ben Udall,

You have a table with a BLOB field for store the image,
CREATE TABLE IMAGE(
IMAGEID INTEGER NOT NULL,
IMAGE BLOB,
CONSTRAINT PK_IMAGE PRIMARY KEY(IMAGEID)
);
Supose we have a trigger for fill the IMAGEID from a Generator,
so we only have to worry about filling the blob content.
You have an HTML page with a FORM as the following ....
<FORM NAME="fImage" ACTION="postImage.php" ENCTYPE="multipart/form-
data">
<INPUT TYPE="FILE" NAME="fileSource">
<INPUT TYPE="SUBMIT">
</FORM>
Form must have ENCTYPE set to multipart/form-data to permit
the image file uploading.
Next step is postImage.php PHP sript:
<?
  // Connecto to DB
  $db = ibase_connect($database, $user, $passwd);
  //preparing the insert statement
  $st = ibase_prepare($db, "INSERT INTO IMAGE(IMAGE) VALUES(?)");
  //Blob handle stuff
  $blobImagenStr = ibase_blob_import($db,fopen($fileSource, "r"));
  //Execute the insert statement and freeing the prepared statement.
  ibase_execute($st,$blobIdStr)
  ibase_free_query($st);
  //Closing the database ....
  ibase_close($db);
  //A message ....
  echo ("Ok");
?>