How to retrieve images from MySQL database and display in an html tag
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="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'];?>
Technically, you can too put image data in an img tag, using data URIs.
<img src="data:image/jpeg;base64,<?php echo base64_encode( $image_data ); ?>" />There are some special circumstances where this could even be useful, although in most cases you're better off serving the image through a separate script like daiscog suggests.