How to add blob image FIrebird in php?

Question

can't add a photo to FIrebird. Writing such a code

        $imgSrc='Desert.jpg';
    $img_src = $imgSrc;
    $imgbinary = fread(fopen($img_src, "r"), filesize($img_src));
    $img_str = base64_encode($imgbinary); 

    $blh = ibase_blob_create($this->db);   
    ibase_blob_add($blh, $img_str);
    $blobid = ibase_blob_close($blh);

    $row = false;
    /*$fd = fopen('Desert.jpg', 'r');
    $blob = ibase_blob_import($fd);
    fclose($fd); */
    $query = ibase_query($this->db, "INSERT INTO \"ud_ab\" (FILES) VALUES (?)", $img_str ) or die(ibase_errmsg());
    if($query) $row = true; 
    return $row;

Tried to translate the picture in base64 format, wrote ibase_blob_add.Nothing helps

Instead of $img_str, I think you should pass $blobid (or maybe $blh) to ibase_query. Note that it is not necessary to base64 encode this, as a blob is - by default - binary data. Note that I don't program in PHP, I'm just guessing based on this question: stackoverflow.com/questions/28801781/… — Mark Rotteveel
– Mark Rotteveel, Commented Aug 16, 2017 at 13:18

rstrelba · Accepted Answer · 2017-08-17 10:38:51Z

1

This is sample code for saving images, but in blob field

define('MAX_SEGMENT_SIZE', 65535);

function blob_create($data) {
    if (strlen($data) == 0)
        return false;
    $handle = ibase_blob_create();
    $len = strlen($data);
    for ($pos = 0; $pos < $len; $pos += MAX_SEGMENT_SIZE) {
        $buflen = ($pos + MAX_SEGMENT_SIZE > $len) ? ($len - $pos) : MAX_SEGMENT_SIZE;
        $buf = substr($data, $pos, $buflen);
        ibase_blob_add($handle, $buf);
    }
    return ibase_blob_close($handle);
}
$blob = blob_create(file_get_contents('Desert.jpg'));
$query = ibase_query($this->db, "INSERT INTO \"ud_ab\" (FILES) VALUES (?)", $blob) or die(ibase_errmsg());

edited Aug 17, 2017 at 10:38

answered Aug 16, 2017 at 16:59

rstrelba

1,98416 silver badges16 bronze badges

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

1 Comment

Mark Rotteveel Over a year ago

I believe that in some older Firebird versions, the max segment size might be limited to 32K instead of 64K.

Collectives™ on Stack Overflow

How to add blob image FIrebird in php?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related