How to store images in mysql database using php

Question

How can i store and display the images in a MySQL database  Till now i have only written the code to get the images from the user and store them in a folder  the code that i wrote till now is  HTML FILE   lt input type  file  name  imageUpload  id  imageUpload  gt    PHP FILE       target dir    uploads     target file    target dir   basename   FILES  imageUpload    name      uploadOk   1   imageFileType   pathinfo  target file PATHINFO EXTENSION     if  move uploaded file   FILES  imageUpload    tmp name     target file         echo  The file    basename    FILES  imageUpload    name       has been uploaded      else       echo  Sorry  there was an error uploading your file

User · Accepted Answer

I found the answer  For those who are looking for the same thing here is how I did it  You should not consider uploading images to the database instead you can store the name of the uploaded file in your database and then retrieve the file name and use it where ever you want to display the image   HTML CODE   lt input type  file  name  imageUpload  id  imageUpload  gt    PHP CODE  if isset   POST  submit              Process the image that is uploaded by the user       target dir    uploads         target file    target dir   basename   FILES  imageUpload    name          uploadOk   1       imageFileType   pathinfo  target file PATHINFO EXTENSION        if  move uploaded file   FILES  imageUpload    tmp name     target file             echo  The file    basename    FILES  imageUpload    name       has been uploaded          else           echo  Sorry  there was an error uploading your file                image basename    FILES  imageUpload    name     jpg       used to store the filename in a variable        storind the data in your database      query   INSERT INTO items VALUES    id    title    description    price    value    contact    image         mysql query  query        require  heading php        echo  Your add has been submited  you will be redirected to your account page in 3 seconds           header   Refresh 3  url account php   true  303       CODE TO DISPLAY THE IMAGE  while  row   mysql fetch row  result         echo   lt tr gt        echo   lt td gt  lt img src  uploads  row 6  jpg  height  150px  width  300px  gt  lt  td gt        echo   lt  tr gt  n

User · Answer

insert image zh  -while we insert image in database using insert query   Image     FILES  Image    name        if   Image               Image               else              file path    upload           file path    file path   basename    FILES  Image    name               if move uploaded file   FILES  Image    tmp name     file path

User · Answer

if isset   POST  form1           try                  user   POST  username              pass   POST  password             email   POST  email             roll   POST  roll             class   POST  class               if empty  user   throw new Exception  Name can not empty            if empty  pass   throw new Exception  Password can not empty            if empty  email   throw new Exception  Email can not empty            if empty  roll   throw new Exception  Roll can not empty            if empty  class   throw new Exception  Class can not empty               statement  db- gt prepare  show table status like  tbl std info              statement- gt execute             result  statement- gt fetchAll            foreach  result as  row           new id  row 10              up file   FILES  image    name              file basename substr  up file  0   strripos  up file                  file ext substr  up file  strripos  up file                   f1   new id   file ext           if   file ext    png   amp  amp   file ext    jpg   amp  amp   file ext    jpeg   amp  amp   file ext    gif                          throw new Exception  Only jpg  png  jpeg or gif Logo are allow to upload   Empty Logo Field                      move uploaded file   FILES  image    tmp name       std photo    f1              statement  db- gt prepare  insert into tbl std info  username image password email roll class  value                            statement- gt execute array  user  f1  pass  email  roll  class               success  Registration Successfully Completed            echo  success            catch Exception  e                 msg  e- gt getMessage

User · Answer

lt  --    THIS PROGRAM WILL UPLOAD IMAGE AND WILL RETRIVE FROM DATABASE  UNSING BLOB  IF YOU HAVE ANY QUERY CONTACT rahulpatel541 gmail com    CREATE TABLE   images       id  int 100  NOT NULL AUTO INCREMENT     name  varchar 100  NOT NULL     image  longblob NOT NULL    PRIMARY KEY   id     ENGINE InnoDB    -- gt   lt  -- this form is user to store images-- gt   lt form action  index php  method  post   enctype  multipart form-data  gt  Enter the Image Name  lt input type  text  name  image name  id      gt  lt br   gt    lt input name  image  id  image  accept  image JPEG  type  file  gt  lt br   gt  lt br   gt   lt input type  submit  value  submit  name  submit    gt   lt  form gt   lt br   gt  lt br   gt   lt  -- this form is user to display all the images-- gt   lt form action  index php  method  post   enctype  multipart form-data  gt  Retrive all the images   lt input type  submit  value  submit  name  retrive    gt   lt  form gt      lt  php   THIS IS INDEX PHP PAGE   connect to database db name is images         mysql connect             OR DIE  mysql error             mysql select db      OR DIE   Unable to select db  mysql error       to retrive send the page to another page if isset   POST  retrive           header  location search php          to upload if isset   POST  submit       if isset   FILES  image                name   POST  image name             email   POST  mail             fp addslashes file get contents   FILES  image    tmp name        will store the image to fp                              our sql query                  sql    INSERT INTO images VALUES  null      name      fp                                   mysql query  sql  or die  Error in Query insert      mysql error          gt      lt  php   SEARCH PHP PAGE       connect to database db name   images          mysql connect  localhost    root       OR DIE  mysql error             mysql select db   image   OR DIE   Unable to select db  mysql error       display all the image present in the database           msg              sql  select   from images           if mysql query  sql                          res mysql query  sql               while  row mysql fetch array  res                                      id  row  id                         name  row  name                         image  row  image                        msg     lt a href  search php id    id    gt  lt img src  data image jpeg base64   base64 encode  row  image           gt     lt  a gt                                     else              msg   Query failed     gt   lt div gt   lt  php echo  msg    gt

[php] How to store images in mysql database using php

Examples related to php

Examples related to html

Examples related to mysql

Examples related to image-uploading