CODEWITHSUNDEEP
phppostgresqlcodeigniterbase64
Denny Kurniawan
Denny Kurniawan

Reputation: 1905

Base64 decode image save into blob database

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.

Upvotes: 1

Views: 872

Answers (1)

Prabhu Nandan Kumar
Prabhu Nandan Kumar

Reputation: 1255

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.

Upvotes: 1

Related Questions