How to display image from database using php [duplicate]

by

Displaying an image from MySql Db.

$db = mysqli_connect("localhost","root","","DbName"); 
$sql = "SELECT * FROM products WHERE id = $id";
$sth = $db->query($sql);
$result=mysqli_fetch_array($sth);
echo '<img src="data:image/jpeg;base64,'.base64_encode( $result['image'] ).'"/>';

More Related Contents:

  1. PHP DateTime supported formats
  2. Can I call a PHP function in a JavaScript click handler?
  3. How to create a chat program using php and mysqli for chatting [closed]
  4. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  5. Can I store images in MySQL [duplicate]
  6. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  7. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  8. Insert multiple rows with one query MySQL
  9. Why is using a mysql prepared statement more secure than using the common escape functions?
  10. MySQL Join two tables with comma separated values
  11. localhost vs. 127.0.0.1 in mysql_connect()
  12. “slash before every quote” problem [duplicate]
  13. iPhone emoticons insert into MySQL but become blank value
  14. Inserting into MySQL from PHP (jQuery/AJAX)
  15. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  16. Selecting all columns that start with XXX using a wildcard?
  17. How to delete mysql row after time passes?
  18. Echo menu tree with recursive function
  19. How to select multiple rows from mysql with one query and use them in php
  20. php run once and insert twice in mysql database
  21. Connect DATABASE Error TYPE: 2002: Permission denied
  22. Laravel nested relationships
  23. getting the value of an extra pivot table column laravel
  24. php sample script for pagination [closed]
  25. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  26. When should I close a database connection in PHP?
  27. Backup a mysql database and download as a file
  28. Is a BLOB converted using the current/default charset in MySQL?
  29. php connection pooling mysql [duplicate]
  30. PHP/MySQL Pagination

Leave a Comment