dr637349
2013-09-06 18:31
浏览 65
已采纳

显示存储在数据库中的图像

I have images that are base64 encoded as blobs in my sql database.

using a php script I can properly display the picture in my browser using.

echo '<img src="data:image/jpeg;base64,' . $fetch_row['object']. '" />';

however, I would like to create a view that would display the photo directly or by accessing the php file and returning the picture in a column. I have tried using something like: in mysql

concat('<img src="data:image/jpeg;base64,',`object`,'" />')
or concat('<img src=/image.php? blah blah blah)

any ideas?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题