Upload video files via PHP and save them in appropriate folder and have a database entry

Question

I want the user to be able to upload video files to my site and I want them arranged in proper folders plus a database entry so that later I can know the person who uploaded each particular file   My HTML form is here    lt form method  post  enctype  multipart form-data  gt       lt div gt  lt  php echo  message    gt  lt  div gt       lt  php echo  max file size tag    gt       lt input type  file  accept  video    ID  fileSelect  runat  server  size  20  name  filename  action   vids file-upload php  gt       lt select name  course  gt           lt option value  select  selected gt Select lt  option gt           lt option value  java  gt Java lt  option gt           lt option value  python  gt Python lt  option gt           lt option value  vb  gt Visual Basic lt  option gt           lt option value  c  gt C C   lt  option gt           lt option value  ruby  gt Ruby lt  option gt       lt  select gt       lt input type  submit  value  Upload  name  submit  gt   lt  form gt    And my PHP is here    lt  php   folder    isset   POST  course      message    1    define  DESTINATION FOLDER     folder    define  MAX FILE SIZE   0       Upload success URL  User will be redirected to this page after upload  define  SUCCESS URL   learn learnbrix com        Allowed file extensions  Will only allow these extensions if not empty     Example   exts   array  avi   mov   doc     exts   array        rename file after upload  false - leave original  true - rename to some unique filename define  RENAME FILE   true     message    renamed      put a string to append to the uploaded file name  after extension      this will reduce the risk of being hacked by uploading potentially unsafe files     sample strings  aaa  my  etc  define  APPEND STRING           message    string append      Need uploads log  Logs would be saved in the MySql database  define  DO LOG   false       MySql data  in case you want to save uploads log  define  DB HOST            host  usually localhost define  DB DATABASE            database name define  DB USERNAME            username define  DB PASSWORD            password     NOTE  when using log  you have to create MySQL table first for this script  Copy-paste following into your MySQL admin tool  like PhpMyAdmin  to create a table If you are on cPanel  then prefix  uploads log on line 205 with your username  so it would be like myusername uploads log  CREATE TABLE  uploads log     log id int 11  unsigned NOT NULL auto increment    log filename varchar 128  default       log size int 10  default 0    log ip varchar 24  default       log date timestamp    PRIMARY KEY   log id     KEY  log filename                                                                                    END OF SETTINGS    DO NOT CHANGE BELOW                                                                          Allow script to work long enough to upload big files  in seconds  2 days by default   set time limit 172800       following may need to be uncommented in case of problems    ini set  session gc maxlifetime   10800     function showUploadForm  message          max file size tag         if  MAX FILE SIZE  gt  0           convert to bytes      max file size tag     lt input name  MAX FILE SIZE  value     MAX FILE SIZE 1024     type  hidden   gt  n             Load form template   include   upload html          errors list  errors   array      message           we should not exceed php ini max file size  ini maxsize   ini get  upload max filesize    if   is numeric  ini maxsize       if  strpos  ini maxsize   M       false       ini maxsize   intval  ini maxsize  1024 1024    elseif  strpos  ini maxsize   K       false       ini maxsize   intval  ini maxsize  1024    elseif  strpos  ini maxsize   G       false       ini maxsize   intval  ini maxsize  1024 1024 1024    if   ini maxsize  lt  MAX FILE SIZE 1024       errors      Alert  Maximum upload file size in php ini  upload max filesize  is less than script s MAX FILE SIZE         show upload form if   isset   POST  submit         showUploadForm join     errors          process file upload else      while true            make sure destination folder exists    if    file exists DESTINATION FOLDER           errors      Destination folder does not exist or no permissions to see it         break              check for upload errors     error code     FILES  filename    error       if   error code    UPLOAD ERR OK         switch  error code           case UPLOAD ERR INI SIZE              uploaded file exceeds the upload max filesize directive in php ini          errors      File is too big  1             break        case UPLOAD ERR FORM SIZE              uploaded file exceeds the MAX FILE SIZE directive that was specified in the HTML form          errors      File is too big  2              break         case UPLOAD ERR PARTIAL              uploaded file was only partially uploaded            errors      Could not upload file  1              break         case UPLOAD ERR NO FILE              No file was uploaded           errors      Could not upload file  2              break         case UPLOAD ERR NO TMP DIR              Missing a temporary folder           errors      Could not upload file  3              break         case UPLOAD ERR CANT WRITE           Failed to write file to disk        errors      Could not upload file  4           break      case 8           File upload stopped by extension        errors      Could not upload file  5           break         switch       leave the while loop   break        get file name  not including path   filename    basename   FILES  filename    name         filename of temp uploaded file  tmp filename     FILES  filename    tmp name      file ext    strtolower  strrchr  filename        if   strpos  file ext          false       no dot  strange    errors      Suspicious file name or could not determine file extension      break     file ext    substr  file ext  1      remove dot     check file type if needed if  count  exts           some day maybe check also   FILES  user file    type     if    in array  file ext   exts          errors      Files of this type are not allowed for upload        break            destination filename  rename if set to  dest filename    filename  if  RENAME FILE       dest filename   md5 uniqid rand    true            file ext       append predefined string for safety  dest filename    dest filename   APPEND STRING      get size  filesize   intval   FILES  filename    size        filesize  tmp filename       make sure file size is ok if  MAX FILE SIZE  gt  0  amp  amp  MAX FILE SIZE 1024  lt   filesize       errors      File is too big  3       break     if    move uploaded file  tmp filename   DESTINATION FOLDER    dest filename        errors      Could not upload file  6       break     if  DO LOG         Establish DB connection    link    mysql connect DB HOST  DB USERNAME  DB PASSWORD     if    link         errors      Could not connect to mysql        break         res    mysql select db DB DATABASE   link     if    res         errors      Could not select database        break         m ip   mysql real escape string   SERVER  REMOTE ADDR        m size    filesize     m fname   mysql real escape string  dest filename      sql    insert into  uploads log  log filename log size log ip  values    m fname    m size    m ip        res    mysql query  sql     if    res         errors      Could not run query        break         mysql free result  res      mysql close  link        if  DO LOG       redirect to upload success url header  Location      SUCCESS URL   die     break         while true       Errors  Show upload form    message   join     errors    showUploadForm  message        gt    I have no knowledge of PHP  so I don t know what s going wrong  I d also like to add the capability to accept names and their email addresses

User · Answer

PHP file  name is upload php        lt  php                       File Upload Code d                                                   target dir    uploaded          target file    target dir   basename   FILES  fileToUpload    name          uploadOk   1       imageFileType   pathinfo  target file PATHINFO EXTENSION           Check if file already exists     if  file exists  target file             echo  Sorry  file already exists             uploadOk   0                 Check file size -- Kept for 500Mb     if    FILES  fileToUpload    size    gt  500000000            echo  Sorry  your file is too large             uploadOk   0                Allow certain file formats     if  imageFileType     wmv   amp  amp   imageFileType     mp4   amp  amp   imageFileType     avi   amp  amp   imageFileType     MP4             echo  Sorry  only wmv  mp4  amp  avi files are allowed             uploadOk   0                Check if  uploadOk is set to 0 by an error     if   uploadOk    0            echo  Sorry  your file was not uploaded           if everything is ok  try to upload file       else           if  move uploaded file   FILES  fileToUpload    tmp name     target file                 echo  The file    basename    FILES  fileToUpload    name       has been uploaded              else               echo  Sorry  there was an error uploading your file                                                                            File Upload Code u                                                                                     Connectivity for DATABASE d                                          servername    localhost        username    root        password            dbname    test           Create connection      conn   new mysqli  servername   username   password   dbname          Check connection     if   conn- gt connect error            die  Connection failed       conn- gt connect error              else       vidname     FILES  fileToUpload    name              vidsize     FILES  fileToUpload    size              vidtype     FILES  fileToUpload    type               sql    INSERT INTO videos  name  size  type  VALUES    vidname    vidsize    vidtype          if   conn- gt query  sql      TRUE          else           echo  Error       sql     lt br gt      conn- gt error                  conn- gt close                          Connectivity for DATABASE u                                            gt

User · Answer

Could you suggest a simpler code main thing is uploading the file Data base entry is secondary    --- As per OP s request  ---   Image and video uploading code  tested with PHP Version 5 4 17   HTML form   lt  DOCTYPE html gt    lt head gt   lt title gt  lt  title gt   lt  head gt    lt body gt    lt form action  upload file php  method  post  enctype  multipart form-data  gt   lt label for  file  gt  lt span gt Filename  lt  span gt  lt  label gt   lt input type  file  name  file  id  file    gt    lt br   gt   lt input type  submit  name  submit  value  Submit    gt   lt  form gt    lt  body gt   lt  html gt    PHP handler  upload file php   Change upload folder to preferred name  Presently saves to upload    lt  php   allowedExts   array  jpg    jpeg    gif    png    mp3    mp4    wma     extension   pathinfo   FILES  file    name    PATHINFO EXTENSION    if      FILES  file    type       video mp4         FILES  file    type       audio mp3         FILES  file    type       audio wma         FILES  file    type       image pjpeg         FILES  file    type       image gif         FILES  file    type       image jpeg      amp  amp     FILES  file    size    lt  20000   amp  amp  in array  extension   allowedExts          if    FILES  file    error    gt  0            echo  Return Code        FILES  file    error       lt br   gt            else           echo  Upload        FILES  file    name       lt br   gt        echo  Type        FILES  file    type       lt br   gt        echo  Size         FILES  file    size     1024      Kb lt br   gt        echo  Temp file        FILES  file    tmp name       lt br   gt         if  file exists  upload       FILES  file    name                   echo   FILES  file    name       already exists                 else               move uploaded file   FILES  file    tmp name           upload       FILES  file    name           echo  Stored in       upload       FILES  file    name                      else       echo  Invalid file         gt

User · Answer

sample code    lt em gt  lt b gt   lt h2 gt Upload Save and Download video  lt  h2 gt   lt form method  POST  action    enctype  multipart form-data  gt   lt input type  file  name  video   gt   lt input type  submit  name  submit  value  Upload   gt  lt  b gt   lt  form gt  lt  em gt    lt  php gt  include  connect php     errors 1    Targeting Folder  target  videos    if isset   POST  submit        Targeting Folder   target  target basename   FILES  video    name       Getting Selected video Type  type pathinfo  target PATHINFO EXTENSION      Allow Certain File Format To Upload  if  type   mp4   amp  amp   type   3gp   amp  amp   type   avi      echo  Only mp4 3gp avi file format are allowed to Upload      errors 0        checking for Exsisting video Files   if file exists  target       echo  File Exist       errors 0          filesize   FILES  video    size      if  filesize gt 250 2000000     echo  You Can not Upload Large File more than 500MB  by Default ini setting   lt a     href  http   www codenair com 2018 03 how-to-upload-large-file-in-php html  gt How to   upload large file in php lt  a gt          errors 0           if  errors    0      echo   Your File Not Uploaded        else     Moving The video file to Desired Directory    uplaod success move uploaded file   FILES  video    tmp name    target     if  uplaod success       Getting Selected video Information      name   FILES  video    name         size   FILES  video    size         result mysqli query  con  INSERT INTO VIdeos            name size type VALUES     name        size        type            if  result  TRUE       echo  Your video   name  Successfully Upload and Information Saved Our  Database                         gt

User · Answer

HTML Code   lt html gt   lt body gt    lt head gt   lt title gt  lt  title gt   lt  head gt    lt body gt    lt form action  upload php  method  post  enctype  multipart form-data  gt       lt label for  file  gt  lt span gt Filename  lt  span gt  lt  label gt       lt input type  file  name  file  id  file    gt        lt br   gt   lt input type  submit  name  submit  value  Submit    gt   lt  form gt      lt  php                                      DATABASE CONNECTIVITY d                           servername    localhost        username    root        password            dbname    test           Create connection      conn   new mysqli  servername   username   password   dbname          Check connection     if   conn- gt connect error            die  Connection failed       conn- gt connect error              else                                      DATABASE CONNECTIVITY u                                                          Retrieve data from DB d                           sql    SELECT name  size  type FROM videos        result    conn- gt query  sql        if   result- gt num rows  gt  0           output data of each row     while  row    result- gt fetch assoc                        path    uploaded      row  name                 echo  path     lt br gt                     else           echo  0 results              conn- gt close                                        Retrieve data from DB d                         gt     lt  body gt   lt  html gt

[php] Upload video files via PHP and save them in appropriate folder and have a database entry

Examples related to php