Returning blob data from MySQL in PHP and converting to base64_encode to add to an array

Question

I'm attempting to retrieve all the data from a table in MySQL and add it to an array.

Click for Table columns structure

I want to convert the blob into an encoded string and add it to an array with the other two columns and then return it as a JSON string. See below for my attempted code:

<?php 
//Importing Database Script 
require_once('dbConnect.php');

//Creating sql query
$sql = "SELECT * FROM picture";

//getting result 
$r = mysqli_query($con,$sql);

//creating a blank array 
$result = array();

//looping through all the records fetched
while($row = mysqli_fetch_array($r)){

    //Pushing name and id in the blank array created 
    array_push($result,array(
        "pictureID"=>$row['pictureID'],
        "listingID"=>$row['listingID'],
        "listingImage"=>$row [base64_encode('listingImage')]
    ));
}

//Displaying the array in json format 
echo json_encode(array('result'=>$result));

mysqli_close($con);

The code is currently returning with a null value for the blob image.

of course all this mess could have been avoided if you had saved files on the filesystem as they are supposed to be. — e4c5
– e4c5, Commented May 6, 2016 at 3:52

ンドリューライアンア · Accepted Answer · 2016-05-06 03:46:22Z

1

Try to change the line :

"listingImage"=>$row [base64_encode('listingImage')]

to

"listingImage"=> base64_encode($row["listingImage"]);

answered May 6, 2016 at 3:46

ンドリューライアンア

1191 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Returning blob data from MySQL in PHP and converting to base64_encode to add to an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related