How to retrieve images from MySQL database and display in an html tag

by

You can’t. You need to create another php script to return the image data, e.g. getImage.php. Change catalog.php to:

<body>
<img src="https://stackoverflow.com/questions/7793009/getImage.php?id=1" width="175" height="200" />
</body>

Then getImage.php is

<?php

  $id = $_GET['id'];
  // do some validation here to ensure id is safe

  $link = mysql_connect("localhost", "root", "");
  mysql_select_db("dvddb");
  $sql = "SELECT dvdimage FROM dvd WHERE id=$id";
  $result = mysql_query("$sql");
  $row = mysql_fetch_assoc($result);
  mysql_close($link);

  header("Content-type: image/jpeg");
  echo $row['dvdimage'];
?>

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. Php charset information [duplicate]
  4. Save the data into a database and return another value from database using PHP
  5. Math Symbol From Mysql To HTML? [closed]
  6. Thank you for helping [closed]
  7. Create hyperlink from html table row to open record on a new page
  8. Is the following code valid? [closed]
  9. How to insert images into a database using PHP [closed]
  10. Preserve Line Breaks From TextArea
  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. Delete multiple rows by selecting checkboxes using PHP
  15. “slash before every quote” problem [duplicate]
  16. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  17. How to add a delete button to a PHP form that will delete a row from a MySQL table
  18. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  19. Echo menu tree with recursive function
  20. How to display an BLOB image stored in MySql database?
  21. Sending HTML Code Through JSON
  22. Javascript function post and call php script
  23. PHP – Secure member-only pages with a login system
  24. PHP: Inserting Values from the Form into MySQL
  25. onbeforeprint() and onafterprint() equivalent for non IE browsers
  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. Displaying BLOB image from Mysql database into dynamic div in html
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment