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

Question

I created a MySQL database with a table using phpmyadmin   I created this table with a BLOB column to hold a jpeg file   I have issues with regards to the php variable  result here   My code so far   catalog php     lt body gt   lt  php    link   mysql connect  localhost    root          mysql select db  dvddb       sql    SELECT dvdimage FROM dvd WHERE id 1      result   mysql query   sql      mysql close  link      gt   lt img src    width  175  height  200    gt   lt  body gt    How can I get the variable  result from PHP into the HTML so I can display it in the  lt img gt  tag

User · Answer

I have added slashes before inserting into database so on the time of fetching i removed slashes again stripslashes() and it works for me. I am sharing the code which works for me.

How i inserted into mysql db (blob type)

$db = mysqli_connect("localhost","root","","dName"); 
$image = addslashes(file_get_contents($_FILES['images']['tmp_name']));
$query = "INSERT INTO student_img (id,image) VALUES('','$image')";  
$query = mysqli_query($db, $query);

Now to access the image

$sqlQuery = "SELECT * FROM student_img WHERE id = $stid";
$rs = $db->query($sqlQuery);
$result=mysqli_fetch_array($rs);
echo '<img src="data:image/jpeg;base64,'.base64_encode( stripslashes($result['image']) ).'"/>';

Hope it will help someone

Thanks.

User · Answer

add  row   mysql fetch object  result   after your mysql query      your html  lt img src   lt  php echo  row- gt dvdimage    gt   width  175  height  200    gt

User · Answer

You need to retrieve and disect the information into what you need   while  row   mysql fetch array  result      echo  img src     row  filename      width  175  height  200    gt

User · Answer

Technically  you can too put image data in an img tag  using data URIs    lt img src  data image jpeg base64  lt  php echo base64 encode   image data      gt     gt    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

User · Answer

You can t   You need to create another php script to return the image data  e g  getImage php   Change catalog php to    lt body gt   lt img src  getImage php id 1  width  175  height  200    gt   lt  body gt    Then getImage php is   lt  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      gt

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

Examples related to php

Examples related to mysql

Examples related to html