Using PHP to upload file and add the path to MySQL database

Question

Upload php      lt  php      This is the directory where images will be saved   target    pics     target    target   basename    FILES  Filename    name          This gets all the other information from the form   Filename   POST  Filename      Description   POST  Description      pic    FILES  Filename    name             Connects to your Database  mysql connect  localhost    root       or die mysql error       mysql select db  altabotanikk   or die mysql error           Writes the information to the database  mysql query  INSERT INTO picture  Filename Description   VALUES    Filename     Description            Writes the Filename to the server  if move uploaded file   FILES  Filename    tmp name     target            Tells you if its all ok      echo  The file    basename    FILES  uploadedfile    Filename       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       And here is the form in a separate file       lt form method  post  action  upload php  enctype  multipart form-data  gt        lt p gt Photo  lt  p gt        lt input type  file  name  Filename  gt         lt p gt Description lt  p gt        lt textarea rows  10  cols  35  name  Description  gt  lt  textarea gt        lt br  gt        lt input TYPE  submit  name  upload  value  Add   gt    lt  form gt       The errors are      Undefined index  Filename on Line 17       the      Filename   POST  Filename        and    Undefined index  uploadedfile on Line 35       the echo  The file    basename    FILES  uploadedfile    Filename       has been uploaded  and your information has been added to the directory       echo  lt pre gt   print r   FILES true    lt  pre gt         gives me     Array          Filename    gt  Array                          name    gt  Laserkanon jpg               type    gt  image jpeg               tmp name    gt  C  WampServer tmp php11D4 tmp               error    gt  0               size    gt  41813

User · Answer

mysql connect  localhost    root       or die mysql error      mysql select db  altabotanikk   or die mysql error        These are deprecated use the following        Connects to your Database              link   mysqli connect  localhost    root              and to insert data use the following    sql    INSERT INTO  Table-Name  Column-Name  VALUES    filename

User · Answer

First you should use print r   FILES  to debug  and see what it contains     your uploads php would look like     This is the directory where images will be saved  target    pics     target    target   basename    FILES  Filename    name        This gets all the other information from the form  Filename basename    FILES  Filename    name      Description   POST  Description        Writes the Filename to the server if move uploaded file   FILES  Filename    tmp name     target           Tells you if its all ok     echo  The file    basename    FILES  Filename    name       has been uploaded  and your information has been added to the directory          Connects to your Database     mysql connect  localhost    root       or die mysql error          mysql select db  altabotanikk   or die mysql error             Writes the information to the database     mysql query  INSERT INTO picture  Filename Description      VALUES    Filename     Description         else         Gives and error if its not     echo  Sorry  there was a problem uploading your file           gt    EDIT  Since this is old post  currently it is strongly recommended to use either mysqli or pdo instead mysql  functions in php

[php] Using PHP to upload file and add the path to MySQL database

Examples related to php

Examples related to html

Examples related to mysql

Examples related to web

Examples related to mysql-loadfile