将Base64图像插入到PHP PDO阵列中

Question

I'm trying to insert Blob images retrieved from MySQL into an array using a while loop.

The database statement selected all images then i need to pass them all into an array.

So in theory, i should have an array of base64 encoded image corresponding to each record from my database.

Any help will be appreciated.

$sql = "SELECT img from artistlocation";

    try{
        $db = new db();
        $db = $db->connect(); 
        $stmt = $db->query($sql);
        $data = array();
        while($result = $stmt->fetch(PDO::FETCH_OBJ))

        {
            //$result = base64_encode(); ---- Something here im guessing
            $data[] = $result;
        }
       print_r ($data);
    }
    catch(PDOException $e){
        echo '{"error": {"text": '.$e->getMessage().'}';
    }

Answer 1

So the answer to this question came from AbraCadaver.

 $sql = "SELECT img from artistlocation";

    try{
        $db = new db();
        $db = $db->connect(); 
        $stmt = $db->query($sql);
        $data = array();
        while($result = $stmt->fetch(PDO::FETCH_OBJ))    
        {
            $data[] = base64_encode($result->img);
        }

Thanks guys for the help!