How to upload images into MySQL database using PHP code

Question

I am trying to save images in my database from HTML form  I have written PHP code to accomplish this task  The program is not generating any error message  but also not inserting image data in MySQL database  Kindly check it  Here i am sharing a excerpt from my code             -------------------     IMAGE QUERY      ---------------          file      FILES  image    tmp name        if  isset  file               echo  Please select an Image             else                image check   getimagesize   FILES  image    tmp name            if  image check  false                   echo  Not a Valid Image                   else                   image   file get contents    FILES  image    tmp name              image name     FILES  image    name            if   image query   mysql query   insert into product images values  1   image name   image                          echo  current id             echo  Successfull                     else                     echo mysql error                                      -----------------     IMAGE QUERY END     ---------------------         lt form action  insert product php  method  POST  enctype  multipart form-data   gt  lt  br gt              File           lt input type  file  name   image   gt       lt  form gt       Error Message   You have an error in your SQL syntax  check the manual that   corresponds to your MySQL server version for the right syntax to use   near    at line 1

User · Answer

Just few more details    Add mysql field     image  blob    Get data from image     image   addslashes file get contents   FILES  image    tmp name         Insert image data into db     sql    INSERT INTO  product images    id    image   VALUES   1      image         Show image to the web     lt img src  data image png base64   base64 encode  row  image       gt     End

User · Answer

This is the perfect code for uploading and displaying image through MySQL database    lt html gt   lt body gt   lt form method  post  enctype  multipart form-data  gt   lt input type  file  name  image   gt   lt input type  submit  name  submit  value  Upload   gt   lt  form gt   lt  php     if isset   POST  submit                if getimagesize   FILES  image    tmp name     FALSE                 echo   error                else                 image     FILES  image    tmp name             image   addslashes file get contents  image            saveimage  image                    function saveimage  image                 dbcon mysqli connect  localhost   root      dbname             qry  insert into tablename  name  values    image              result mysqli query  dbcon  qry           if  result                        echo    lt br  gt Image uploaded                header  location urlofpage php                      else                       echo   error                      gt   lt  body gt   lt  html gt

User · Answer

Firstly  you should check if your image column is BLOB type   I don t know anything about your SQL table  but if I ll try to make my own as an example   We got fields id  int   image  blob  and image name  varchar 64     So the code should look like this  assume ID is always  1  and let s use this mysql query     image   addslashes file get contents   FILES  image    tmp name        SQL Injection defence   image name   addslashes   FILES  image    name      sql    INSERT INTO  product images    id    image    image name   VALUES   1      image       image name      if   mysql query  sql        Error handling     echo  Something went wrong            You are doing it wrong in many ways  Don t use mysql functions - they are deprecated  Use PDO or MySQLi  You should also think about storing files locations on disk  Using MySQL for storing images is thought to be Bad Idea     Handling SQL table with big data like images can be problematic   Also your HTML form is out of standards  It should look like this    lt form action  insert product php  method  POST  enctype  multipart form-data  gt       lt label gt File   lt  label gt  lt input type  file  name  image    gt       lt input type  submit    gt   lt  form gt      Sidenote   When dealing with files and storing them as a BLOB  the data must be escaped using mysql real escape string    otherwise it will result in a syntax error

[php] How to upload images into MySQL database using PHP code

Examples related to php

Examples related to html

Examples related to mysql

Examples related to database

Examples related to image-uploading