how to pass a blob in php as a parameter and uploading it to a MySQL database?

Question

I want to create a function that will receive values as parameters and upload them to a MySQL database. My problem is passing a blob to the function and uploading it to the database. My function currently looks like this:

public function addPost($id,$title,$description,$submitted_by,$screenshot)
{
    $conn = $this->connect(); //connect to the database 

    $sql = "insert into complaint values('null','$title','$description',now(),'0000-00-0000:00:00.000000','$id','$status','$image','$screenshot')";
    $result = mysqli_query($conn,$sql); 

    if($result)
    {
        return true;
    }
    else
    {
        return false; 
    }
}`

http://stackoverflow.com/a/38829952/267540 – e4c5 Aug 10 '16 at 08:13 — e4c5, Aug 10 '16 at 08:13

mishanon · Accepted Answer · 2016-08-10T08:27:59.917

0

You can use these functions: base64_encode, base64_decode.
And just decoding and encoding blob value

for example:

$encode_image = base64_encode($image);
$sql = "insert into complaint values('null','$title','$description',now(),'0000-00-0000:00:00.000000','$id','$status','$encode_image','$screenshot')";
$result = mysqli_query($conn,$sql);

edited Aug 10 '16 at 08:27

answered Aug 10 '16 at 08:16

mishanon

705
5
11

and when you get post from db, you should use $image = base64_decode($db_image); – mishanon Aug 10 '16 at 08:29

how to pass a blob in php as a parameter and uploading it to a MySQL database?

1 Answers1