Displaying BLOB image from Mysql database into dynamic div in html

by

1) Base64 option

Work with a single line, image/png for a png image and image/jpeg for a jpg one : 

echo '<img src="data:image/png;base64,'.base64_encode($blob).'"/>';

example :

<div style="background-color:black; text-align:center; padding: 5px;">
  <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAwBAMAAACh2TSJAAAALVBMVEUAAADtNTX////3n5/+9fX719f7zMz5tLTzfHzuQED//f31jY3ybGzxXV3wVFRaxp+rAAAAAXRSTlMAQObYZgAAALVJREFUOMut0rENAjEQRNHdC4kY0QBaAQUQX0QAFSAKIKQEKiAA6VqgIkriApuV1x7pQPz0aWwHljLMpZ0CRDBGoXmeghGYKFJsUo90giAImCgV5OJF+oOgKE48MlGgs2VLBIunWesw0a1ZHqF82c7GmmIfUSpgotOly29DFPFJFDEhkgIT/V5mZuvj6XofKrHU6vyI4u37IYi36aN4h5tL7PJyif1dvCgEpapzISbCTEj5R78BZq5A5Ldh2XYAAAAASUVORK5CYII">
</div>

2) Dedicated page

With many big picture on the same page, the base64 may be not the good choice

Base64 is cool, but a bit heavy (usually around twice as the binary value encoded) and can’t be cached by the browser as it’s a part of the page, and not a page by itself (like a picture).

In this case, the best is to use a specific php page to display your picture :

On the main page use instead of base 64 : echo '<img src="https://stackoverflow.com/questions/34111390/image.php?id=".$id.'"/>'; with the id of the line you want the image.

On your image.php, for the basic you should use this :

// << include the $pdo here
$query = $pdo->prepare("SELECT `content` FROM `adsubm` WHERE `id` = :id" );
$query->execute(array(':id'=>$_GET['id']));
$data = $query->fetch();

if(empty($data)))
    header("HTTP/1.0 404 Not Found");
else {
    header('Content-type: image/jpeg');
    echo $data['content'];
}

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. HTML Form/PHP connected but MySQL is empty
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Php charset information [duplicate]
  5. Save the data into a database and return another value from database using PHP
  6. Math Symbol From Mysql To HTML? [closed]
  7. Thank you for helping [closed]
  8. Create hyperlink from html table row to open record on a new page
  9. Is the following code valid? [closed]
  10. How to insert images into a database using PHP [closed]
  11. How to upload images into MySQL database using PHP code
  12. Fetching data from MySQL database to HTML dropdown list
  13. HTML – Change\Update page contents without refreshing\reloading the page
  14. “slash before every quote” problem [duplicate]
  15. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  16. Dynamic table in HTML using MySQL and php
  17. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  18. Echo menu tree with recursive function
  19. How to display an BLOB image stored in MySql database?
  20. Sending HTML Code Through JSON
  21. Javascript function post and call php script
  22. PHP – Secure member-only pages with a login system
  23. PHP: Inserting Values from the Form into MySQL
  24. onbeforeprint() and onafterprint() equivalent for non IE browsers
  25. Creating dynamic tables in HTML using MySQL and PHP
  26. Create table with PHP and populate from MySQL
  27. Turkish characters are not displayed correctly [duplicate]
  28. mysql_fetch_array skipping first row
  29. Using PHP to upload file and add the path to MySQL database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment