How to store file name in database with other info while uploading image to server using PHP

Question

Hi I have read many forums and websites that tell you how to upload an image to a server and I have managed to get this working  I can upload a file to a my server but storing the file name does work on the following example I found and I also need to create a form that allows more data to be entered to the database  I am stuck with this as a have done much PHP before  I have come to the end of trying different websites tutorials with no much success could anyone please help me  I need it done for a project I m doing    I am basically trying to make a CMS that allows users to upload a photo of a band member and have information stored about them so that it can be displayed on a webpage for the public to view      My Table looks like this    Field              Type             Null    Default      id                 int 10           No                    nameMember         varchar 25       No                    bandMember         text             No                    photo              varchar 30       No                    aboutMember        text             No                    otherBands         text             No         The form I want will look like this       lt h1 gt Adding a new Band Member or Affiliate lt  h1 gt         lt form method  post  action  addMember php  enctype  multipart form-data  gt          lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Member s Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  file  name  filep  size 35   gt               lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  title  Add data to the Database  value  Add Member   gt             lt  form gt    The Example that uploads an Image to the server and only  that is this     lt    if    POST  action       Load      folder    images     move uploaded file   FILES  filep    tmp name       folder    FILES  filep    name      echo    lt p align center gt File     FILES  filep    name    loaded        result   mysql connect  localhost                      or die   Could not save image name  Error      mysql error      mysql select db  project   or die  Could not select database    mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name          if  result    echo  Image name saved into database             gt    And the Examples form I have to use is this     lt form action addMember php method post enctype  multipart form-data  gt   lt table border  0  cellspacing  0  align center cellpadding  3  bordercolor   cccccc  gt   lt tr gt   lt td gt File  lt  td gt   lt td gt  lt input type  file  name  filep  size 45 gt  lt  td gt   lt  tr gt   lt tr gt   lt td colspan 2 gt  lt p align center gt   lt input type submit name action value  Load  gt   lt  td gt   lt  tr gt   lt  table gt   lt  form gt    PS  Images file is open for writing to

User · Answer

If you want to input more data into the form, you simply access the submitted data through $_POST.

If you have

<input type="text" name="firstname" />

you access it with

$firstname = $_POST["firstname"];

You could then update your query line to read

mysql_query("INSERT INTO dbProfiles (photo,firstname)
             VALUES('{$filename}','{$firstname}')");

Note: Always filter and sanitize your data.

User · Answer

Your part    result   mysql connect  localhost                      or die   Could not save image name  Error      mysql error      mysql select db  project   or die  Could not select database    mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name          if  result    echo  Image name saved into database       Doesn t make much sense  your connection shouldn t be named  result but that is a naming issue not a coding one   What is a coding issue is if  result   your saying if you can connect to the database regardless of the insert query failing or succeeding you will output  Image saved into database    Try adding do    realresult   mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name            and change the if  result  to  realresult  I suspect your query is failing  perhaps you have additional columns or something   Try copy pasting your query  replacing the     FILES  filep    name     with test and running it in your query browser and see if it goes in

User · Answer

Your part    result   mysql connect  localhost                      or die   Could not save image name  Error      mysql error      mysql select db  project   or die  Could not select database    mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name          if  result    echo  Image name saved into database       Doesn t make much sense  your connection shouldn t be named  result but that is a naming issue not a coding one   What is a coding issue is if  result   your saying if you can connect to the database regardless of the insert query failing or succeeding you will output  Image saved into database    Try adding do    realresult   mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name            and change the if  result  to  realresult  I suspect your query is failing  perhaps you have additional columns or something   Try copy pasting your query  replacing the     FILES  filep    name     with test and running it in your query browser and see if it goes in

User · Answer

If you want to input more data into the form, you simply access the submitted data through $_POST.

If you have

<input type="text" name="firstname" />

you access it with

$firstname = $_POST["firstname"];

You could then update your query line to read

mysql_query("INSERT INTO dbProfiles (photo,firstname)
             VALUES('{$filename}','{$firstname}')");

Note: Always filter and sanitize your data.

User · Answer

Adding the following avoids problems with quotes in file names  e g    freddy s pic jpg    which are acceptable on some operating systems   Before    pic    FILES  photo    name       After    pic  mysql real escape string   FILES  photo    name

User · Answer

Here is the answer for those of you looking like I did all over the web trying to find out how to do this task  Uploading a photo to a server with the file name stored in a mysql database and other form data you want in your Database  Please let me know if it helped    Firstly the form you need         lt form method  post  action  addMember php  enctype  multipart form-data  gt       lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Band Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo of the Member in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten  Maxium size of File is 35kb               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  hidden  name  size  value  350000  gt               lt input type  file  name  photo  gt                lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  name  upload  title  Add data to the Database  value  Add Member   gt             lt  form gt    Then this code processes you data from the form        lt  php     This is the directory where images will be saved  target    your directory    target    target   basename    FILES  photo    name         This gets all the other information from the form  name   POST  nameMember     bandMember   POST  bandMember     pic    FILES  photo    name      about   POST  aboutMember     bands   POST  otherBands         Connects to your Database mysqli connect  yourhost    username    password   or die mysqli error      mysqli select db  dbName   or die mysqli error          Writes the information to the database mysqli query  INSERT INTO tableName  nameMember bandMember photo aboutMember otherBands  VALUES    name     bandMember     pic     about     bands           Writes the photo to the server if move uploaded file   FILES  photo    tmp name     target         Tells you if its all ok echo  The file    basename    FILES  uploadedfile    name       has been uploaded  and your information has been added to the directory     else       Gives and error if its not echo  Sorry  there was a problem uploading your file        gt     Code edited from www about com

User · Answer

lt form method  post  action  addMember php  enctype  multipart form-data  gt       lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Band Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo of the Member in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten  Maxium size of File is 35kb               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  hidden  name  size  value  350000  gt               lt input type  file  name  photo  gt                lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  name  upload  title  Add data to the Database  value  Add Member   gt             lt  form gt    save it as addMember php   lt  php    This is the directory where images will be saved  target    your directory    target    target   basename    FILES  photo    name        This gets all the other information from the form  name   POST  nameMember     bandMember   POST  bandMember     pic    FILES  photo    name      about   POST  aboutMember     bands   POST  otherBands         Connects to your Database mysql connect  yourhost    username    password   or die mysql error      mysql select db  dbName   or die mysql error         Writes the information to the database mysql query  INSERT INTO tableName  nameMember bandMember photo aboutMember otherBands  VALUES    name     bandMember     pic     about     bands          Writes the photo to the server if move uploaded file   FILES  photo    tmp name     target        Tells you if its all ok echo  The file    basename    FILES  photo    name       has been uploaded  and your information has been added to the directory     else      Gives and error if its not echo  Sorry  there was a problem uploading your file        gt    in the above code one little bug  i fixed that bug

User · Answer

If you want to input more data into the form, you simply access the submitted data through $_POST.

If you have

<input type="text" name="firstname" />

you access it with

$firstname = $_POST["firstname"];

You could then update your query line to read

mysql_query("INSERT INTO dbProfiles (photo,firstname)
             VALUES('{$filename}','{$firstname}')");

Note: Always filter and sanitize your data.

User · Answer

Here is the answer for those of you looking like I did all over the web trying to find out how to do this task  Uploading a photo to a server with the file name stored in a mysql database and other form data you want in your Database  Please let me know if it helped    Firstly the form you need         lt form method  post  action  addMember php  enctype  multipart form-data  gt       lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Band Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo of the Member in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten  Maxium size of File is 35kb               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  hidden  name  size  value  350000  gt               lt input type  file  name  photo  gt                lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  name  upload  title  Add data to the Database  value  Add Member   gt             lt  form gt    Then this code processes you data from the form        lt  php     This is the directory where images will be saved  target    your directory    target    target   basename    FILES  photo    name         This gets all the other information from the form  name   POST  nameMember     bandMember   POST  bandMember     pic    FILES  photo    name      about   POST  aboutMember     bands   POST  otherBands         Connects to your Database mysqli connect  yourhost    username    password   or die mysqli error      mysqli select db  dbName   or die mysqli error          Writes the information to the database mysqli query  INSERT INTO tableName  nameMember bandMember photo aboutMember otherBands  VALUES    name     bandMember     pic     about     bands           Writes the photo to the server if move uploaded file   FILES  photo    tmp name     target         Tells you if its all ok echo  The file    basename    FILES  uploadedfile    name       has been uploaded  and your information has been added to the directory     else       Gives and error if its not echo  Sorry  there was a problem uploading your file        gt     Code edited from www about com

User · Answer

Your part    result   mysql connect  localhost                      or die   Could not save image name  Error      mysql error      mysql select db  project   or die  Could not select database    mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name          if  result    echo  Image name saved into database       Doesn t make much sense  your connection shouldn t be named  result but that is a naming issue not a coding one   What is a coding issue is if  result   your saying if you can connect to the database regardless of the insert query failing or succeeding you will output  Image saved into database    Try adding do    realresult   mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name            and change the if  result  to  realresult  I suspect your query is failing  perhaps you have additional columns or something   Try copy pasting your query  replacing the     FILES  filep    name     with test and running it in your query browser and see if it goes in

User · Answer

Adding the following avoids problems with quotes in file names  e g    freddy s pic jpg    which are acceptable on some operating systems   Before    pic    FILES  photo    name       After    pic  mysql real escape string   FILES  photo    name

User · Answer

You have an ID for each photo so my suggestion is you rename the photo  For example you rename it by the date   lt  php   date   getdate      name     date hours     name     date minutes     name     date seconds     name     date year     name     date mon     name     date mday     gt    note  don t forget the file extension of your file or you can generate random string for the photo  but I would not recommend that  I would also recommend you to check the file extension before you upload it to your directory    lt  php  if      FILES  photo    type       image jpeg                     FILES  photo    type       image pjpg                 amp  amp     FILES  photo    size    lt  100000000                                 move uploaded file   FILES  photo    tmp name     target  name                    if mysql query  your query                                            success handling                                   else                                          failed handling                                             else                                 error handling                 gt    Hope this might help

User · Answer

Here is the answer for those of you looking like I did all over the web trying to find out how to do this task  Uploading a photo to a server with the file name stored in a mysql database and other form data you want in your Database  Please let me know if it helped    Firstly the form you need         lt form method  post  action  addMember php  enctype  multipart form-data  gt       lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Band Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo of the Member in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten  Maxium size of File is 35kb               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  hidden  name  size  value  350000  gt               lt input type  file  name  photo  gt                lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  name  upload  title  Add data to the Database  value  Add Member   gt             lt  form gt    Then this code processes you data from the form        lt  php     This is the directory where images will be saved  target    your directory    target    target   basename    FILES  photo    name         This gets all the other information from the form  name   POST  nameMember     bandMember   POST  bandMember     pic    FILES  photo    name      about   POST  aboutMember     bands   POST  otherBands         Connects to your Database mysqli connect  yourhost    username    password   or die mysqli error      mysqli select db  dbName   or die mysqli error          Writes the information to the database mysqli query  INSERT INTO tableName  nameMember bandMember photo aboutMember otherBands  VALUES    name     bandMember     pic     about     bands           Writes the photo to the server if move uploaded file   FILES  photo    tmp name     target         Tells you if its all ok echo  The file    basename    FILES  uploadedfile    name       has been uploaded  and your information has been added to the directory     else       Gives and error if its not echo  Sorry  there was a problem uploading your file        gt     Code edited from www about com

User · Answer

lt form method  post  action  addMember php  enctype  multipart form-data  gt       lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Band Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo of the Member in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten  Maxium size of File is 35kb               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  hidden  name  size  value  350000  gt               lt input type  file  name  photo  gt                lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  name  upload  title  Add data to the Database  value  Add Member   gt             lt  form gt    save it as addMember php   lt  php    This is the directory where images will be saved  target    your directory    target    target   basename    FILES  photo    name        This gets all the other information from the form  name   POST  nameMember     bandMember   POST  bandMember     pic    FILES  photo    name      about   POST  aboutMember     bands   POST  otherBands         Connects to your Database mysql connect  yourhost    username    password   or die mysql error      mysql select db  dbName   or die mysql error         Writes the information to the database mysql query  INSERT INTO tableName  nameMember bandMember photo aboutMember otherBands  VALUES    name     bandMember     pic     about     bands          Writes the photo to the server if move uploaded file   FILES  photo    tmp name     target        Tells you if its all ok echo  The file    basename    FILES  photo    name       has been uploaded  and your information has been added to the directory     else      Gives and error if its not echo  Sorry  there was a problem uploading your file        gt    in the above code one little bug  i fixed that bug

User · Answer

If you want to input more data into the form, you simply access the submitted data through $_POST.

If you have

<input type="text" name="firstname" />

you access it with

$firstname = $_POST["firstname"];

You could then update your query line to read

mysql_query("INSERT INTO dbProfiles (photo,firstname)
             VALUES('{$filename}','{$firstname}')");

Note: Always filter and sanitize your data.

User · Answer

You have an ID for each photo so my suggestion is you rename the photo  For example you rename it by the date   lt  php   date   getdate      name     date hours     name     date minutes     name     date seconds     name     date year     name     date mon     name     date mday     gt    note  don t forget the file extension of your file or you can generate random string for the photo  but I would not recommend that  I would also recommend you to check the file extension before you upload it to your directory    lt  php  if      FILES  photo    type       image jpeg                     FILES  photo    type       image pjpg                 amp  amp     FILES  photo    size    lt  100000000                                 move uploaded file   FILES  photo    tmp name     target  name                    if mysql query  your query                                            success handling                                   else                                          failed handling                                             else                                 error handling                 gt    Hope this might help

User · Answer

Here is the answer for those of you looking like I did all over the web trying to find out how to do this task  Uploading a photo to a server with the file name stored in a mysql database and other form data you want in your Database  Please let me know if it helped    Firstly the form you need         lt form method  post  action  addMember php  enctype  multipart form-data  gt       lt p gt                Please Enter the Band Members Name               lt  p gt               lt p gt                Band Member or Affiliates Name               lt  p gt               lt input type  text  name  nameMember   gt               lt p gt                Please Enter the Band Members Position  Example Drums               lt  p gt               lt p gt                Band Position               lt  p gt               lt input type  text  name  bandMember   gt               lt p gt                Please Upload a Photo of the Member in gif or jpeg format  The file name should be named after the Members name  If the same file name is uploaded twice it will be overwritten  Maxium size of File is 35kb               lt  p gt               lt p gt                Photo               lt  p gt               lt input type  hidden  name  size  value  350000  gt               lt input type  file  name  photo  gt                lt p gt                Please Enter any other information about the band member here               lt  p gt               lt p gt                Other Member Information               lt  p gt   lt textarea rows  10  cols  35  name  aboutMember  gt   lt  textarea gt               lt p gt                Please Enter any other Bands the Member has been in               lt  p gt               lt p gt                Other Bands               lt  p gt               lt input type  text  name  otherBands  size 30   gt               lt br  gt               lt br  gt               lt input TYPE  submit  name  upload  title  Add data to the Database  value  Add Member   gt             lt  form gt    Then this code processes you data from the form        lt  php     This is the directory where images will be saved  target    your directory    target    target   basename    FILES  photo    name         This gets all the other information from the form  name   POST  nameMember     bandMember   POST  bandMember     pic    FILES  photo    name      about   POST  aboutMember     bands   POST  otherBands         Connects to your Database mysqli connect  yourhost    username    password   or die mysqli error      mysqli select db  dbName   or die mysqli error          Writes the information to the database mysqli query  INSERT INTO tableName  nameMember bandMember photo aboutMember otherBands  VALUES    name     bandMember     pic     about     bands           Writes the photo to the server if move uploaded file   FILES  photo    tmp name     target         Tells you if its all ok echo  The file    basename    FILES  uploadedfile    name       has been uploaded  and your information has been added to the directory     else       Gives and error if its not echo  Sorry  there was a problem uploading your file        gt     Code edited from www about com

User · Answer

Your part    result   mysql connect  localhost                      or die   Could not save image name  Error      mysql error      mysql select db  project   or die  Could not select database    mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name          if  result    echo  Image name saved into database       Doesn t make much sense  your connection shouldn t be named  result but that is a naming issue not a coding one   What is a coding issue is if  result   your saying if you can connect to the database regardless of the insert query failing or succeeding you will output  Image saved into database    Try adding do    realresult   mysql query  INSERT into dbProfiles  photo  VALUES      FILES  filep    name            and change the if  result  to  realresult  I suspect your query is failing  perhaps you have additional columns or something   Try copy pasting your query  replacing the     FILES  filep    name     with test and running it in your query browser and see if it goes in

[php] How to store file name in database, with other info while uploading image to server using PHP?

Examples related to php

Examples related to mysql

Examples related to database

Examples related to image-processing

Examples related to file-upload