Base64 decode image save into blob database

Question

I am using PostgreSQL for my database and codeigniter for my php framework, I have problem when try to save blob image from base64 decode inside my foreach.

This is my code:

foreach($master->spesimen  as $spesimen){
                        $data_spesimen = array(
                            "indexspec" => $spesimen->indexspec,
                            "namafile" => $spesimen->nama,
                            "nama" => $spesimen->nama,
                            "imgspec" =>  base64_decode($spesimen->namafile),
                            "ref_mfpp" => $kode,
                            "useri" => $username
                        );
                        $this->kirim->specfpp($data_spesimen);
                    }

I got error from postgres :

Message: pg_escape_literal(): Failed to escape

How to fix this? Thanks in advance.

why not just save the image on a directory and just save its path to the database? — elegisandi, Aug 01 '17 at 05:31
hai @elegisandi I want save image to database, I don't want put it into file. — Denny Kurniawan, Aug 01 '17 at 05:46

Prabhu Nandan Kumar · Accepted Answer · 2017-08-01T06:24:03.030

You can try following code :

foreach($master->spesimen  as $spesimen){
                            $data_spesimen = array(
                                "indexspec" => $spesimen->indexspec,
                                "namafile" => $spesimen->nama,
                                "nama" => $spesimen->nama,
                                "imgspec" => pg_escape_bytea(base64_decode($spesimen->namafile)),
                                "ref_mfpp" => $kode,
                                "useri" => $username
                            );
                            $this->kirim->specfpp($data_spesimen);
                        }

To understand more about your issue click here .

Please let me know its helpful or not .

Edited answer Thanks @Denny Kurniawan for your confirmation.

I use pg_escape_bytea(base64_decode($spesimen->namafile)) and its work, thank you very much. — Denny Kurniawan, Aug 01 '17 at 05:53

Base64 decode image save into blob database

1 Answers1