How to display image from database using php

Question

I am trying to display an image coming from the database and I was not able to display the image  but its showing like this user-1 jpg Please see my code can one guide me how to display the image    sqlimage    SELECT image FROM userdetail where  id     id1    imageresult1   mysql query  sqlimage    while  rows   mysql fetch assoc  imageresult1                 image    rows  image            print  image

User · Answer

put you  image in img tag of html   try this  echo   lt img src  your path to image    image      gt      instead of   print  image    your path to image would be absolute path of your image folder like eg   home son public html images  or as your folder structure on server   Update 2    if your image is resides in the same folder where this page file is exists you can user this  echo   lt img src     image      gt

User · Answer

For example if you use this code   you can load image from db  mysql  and display it in php5       lt  php     con  mysql connect  localhost    root             sdb  mysql select db  my database   con       sql    SELECT   FROM  news  WHERE 1       mq   mysql query  sql  or die   not working query        row   mysql fetch array  mq  or die  line 44 not working        s  row  photo       echo  row  photo        echo   lt img src     s    alt  HTML5 Icon  style  width 128px height 128px  gt         gt

User · Answer

lt  php      conn   mysql connect   localhost 3306   root            db   mysql select db   database name    conn        if   db            echo mysql error                q    SELECT image FROM table name where id 4        r   mysql query    q   conn       if  r             while  row   mysql fetch array  r                 header   Content-type  image jpeg               echo  row   image                   else          echo mysql error                gt   sometimes problem may  occures because of port number of mysql server is incoreect to avoid it just write port number with host name like this  localhost 3306   in case if you have installed two mysql servers on same system then write port according to that  in order to display any data from database please make sure following steps 1 proper connection with sql 2 select database 3 write query  4 write correct table name inside the query 5 and last is traverse through data

User · Answer

You need to do this to display image   sqlimage     SELECT image FROM userdetail where  id     id1    imageresult1   mysql query  sqlimage    while  rows mysql fetch assoc  imageresult1          image    rows  image        echo   lt img src   image   gt        echo   lt br gt         You need to use html img tag

User · Answer

If you want to show images from database then first you have to insert the images in database then you can show that image on page  Follow the below code to show or display or fetch the image   Here I am showing image and name from database   Note  I am only storing the path of image in database but actual image i am storing in photo folder   PHP Complete Code with design  show-code php      lt  DOCTYPE html gt   lt html gt   lt head gt   lt meta charset  utf-8  gt   lt meta name  viewport  content  width device-width  intial-scale 1 0   gt   lt link rel  stylesheet  href  https   maxcdn bootstrapcdn com bootstrap 3 3 7 css bootstrap min css  gt   lt title gt Show Image in PHP - Campuslife lt  title gt   lt style gt      body background-color   f2f2f2  color   333        main box-shadow  0  125rem  25rem rgba 0 0 0  075  important  margin-top  10px       h3 background-color   4294D1  color   f7f7f7  padding  15px  border-radius  4px  box-shadow  0 1px 6px rgba 57 73 76 0 35         img-box margin-top  20px        img-block float  left  margin-right  5px  text-align  center       p margin-top  0       img width  375px  min-height  250px  margin-bottom  10px  box-shadow  0  125rem  25rem rgba 0 0 0  075  important  border 6px solid  f7f7f7    lt  style gt   lt  head gt       lt body gt       lt  -------------------Main Content------------------------------ gt       lt div class  container main  gt           lt h3 gt Showing Images from database lt  h3 gt           lt div class  img-box  gt       lt  php          host   localhost            uname    root            pwd    123456            db name    master             file path    photo             result   mysqli connect  host  uname  pwd  or die  Could not connect to database    mysqli error             mysqli select db  result  db name  or die  Could not select the databse    mysqli error              image query   mysqli query  result  select img name img path from image table            while  rows   mysqli fetch array  image query                          img name    rows  img name                 img src    rows  img path              gt            lt div class  img-block  gt           lt img src   lt  php echo  img src    gt   alt    title   lt  php echo  img name    gt   width  300  height  200  class  img-responsive    gt           lt p gt  lt strong gt  lt  php echo  img name    gt  lt  strong gt  lt  p gt           lt  div gt            lt  php                 gt           lt  div gt       lt  div gt       lt  body gt   lt  body gt   lt  html gt    If you found any mistake then you can directly follow the tutorial which is i found from where  You can see the live tutorial step by step on this website   I hope may be you like my answer   Thank You  https   www campuslife co in Php how-to-show-image-from-database-using-php-mysql php  Output   Showing Images from Database  1   https   www campuslife co in Php image show-image1 png

User · Answer

Simply replace  print  image    with    echo   lt img src    image    gt

User · Answer

lt  php         connection  mysql connect  localhost    root                 sqlimage    SELECT   FROM userdetail where  id        id1             imageresult1   mysql query  sqlimage  connection          while  rows   mysql fetch assoc  imageresult1                       echo  lt img height  300  width  300  src  data image base64    rows  image      gt                gt

User · Answer

instead of print  image  you should go for print   lt img src  lt   image   gt  gt    and note that  image should contain the path of your image   So  If you are only storing the name of your image in database then instead of that you have to store the full path of your image in the database like  root user Documents image jpeg

User · Answer

Displaying an image from MySql Db     db   mysqli connect  localhost   root      DbName      sql    SELECT   FROM products WHERE id    id    sth    db- gt query  sql    result mysqli fetch array  sth   echo   lt img src  data image jpeg base64   base64 encode   result  image         gt

User · Answer

put this code to your php page    sql    SELECT   FROM userdetail    result   mysqli query  connection     sql    while   row   mysqli fetch array  result MYSQLI BOTH         echo   lt img src  images    row  image      gt        echo   lt p gt    row  text      lt  p gt        i hope this is work

User · Answer

sqlimage     SELECT image FROM userdetail where  id     id1        imageresult1   mysqli query  link   sqlimage        while  rows mysqli fetch assoc  imageresult1          echo   lt img src    Image    row  image        gt

[php] How to display image from database using php

Examples related to php

Examples related to mysql