{"id":123044,"date":"2022-02-01T18:15:26","date_gmt":"2022-02-01T18:15:26","guid":{"rendered":"https:\/\/phppot.com\/?p=16090"},"modified":"2022-02-01T18:15:26","modified_gmt":"2022-02-01T18:15:26","slug":"php-file-upload-to-server-with-mysql-database","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/02\/01\/php-file-upload-to-server-with-mysql-database\/","title":{"rendered":"PHP File Upload to Server with MySQL Database"},"content":{"rendered":"
by Vincy<\/a>. Last modified on February 1st, 2022.<\/div>\n

File upload is an important component in building websites. This article will help you to implement a file upload to the server feature with PHP and a MySQL database.<\/p>\n

Example use cases of where the file upload may be needed in a website,<\/p>\n

Let us see how to code PHP file upload for a website. You can split this article into the following sections.<\/p>\n

    \n
  1. PHP file upload \u2013 A quick example.<\/li>\n
  2. File upload \u2013 server-side validation.<\/li>\n
  3. Upload file to the server with database.<\/li>\n
  4. Upload file as a blob to the database.<\/li>\n<\/ol>\n
    \n

    PHP file upload \u2013 Quick example<\/h2>\n
    <?php if (isset($_FILES['upload_file'])) { move_uploaded_file($_FILES[\"upload_file\"][\"tmp_name\"], $_FILES[\"upload_file\"][\"name\"]);\n}\n?>\n<form name=\"from_file_upload\" action=\"\" method=\"post\" enctype=\"multipart\/form-data\"> <div class=\"input-row\"> <input type=\"file\" name=\"upload_file\" accept=\".jpg,.jpeg,.png\"> <\/div> <input type=\"submit\" name=\"upload\" value=\"Upload File\">\n<\/form>\n<\/pre>\n<\/div>\n
    This quick example shows a simple code to achieve PHP file upload. It has an HTML form to choose a file to upload. Let the form with the following attributes for supporting file upload.<\/p>\n
      \n
    1. method=post<\/em><\/li>\n
    2. enctype=multipart\/form-data<\/em><\/li>\n<\/ol>\n
      By choosing a file, it will be in a temporary directory. The $_FILES[\u201cupload_file\u201d][\u201ctmp_name\u201d] has that path. The PHP move_uploaded_file() uploads the file from this path to the specified target.<\/p>\n\n\n\n\n\n\n\n\n
      $_FILES[\u2018<file-input-name>\u2019][\u2018tmp_name\u2019]<\/td>\nPHP file upload temporary path<\/td>\n<\/tr>\n
      $_FILES[\u2018<file-input-name>\u2019][\u2018name\u2019]<\/td>\nFile name with extension<\/td>\n<\/tr>\n
      $_FILES[\u2018<file-input-name>\u2019][\u2018type\u2019]<\/td>\nFile MIME type. Eg: image\/jpeg<\/td>\n<\/tr>\n
      $_FILES[\u2018<file-input-name>\u2019][\u2018size\u2019]<\/td>\nFile size (in bytes)<\/td>\n<\/tr>\n
      $_FILES[\u2018<file-input-name>\u2019][\u2018error\u2019]<\/td>\nFile upload error code if any<\/td>\n<\/tr>\n
      $_FILES[\u2018<file-input-name>\u2019][\u2018full_path\u2019]<\/td>\nFull path as sent by the browser<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      The form allows multi-file upload<\/a> by having an array of file input.<\/p>\n
      PHP file upload configuration<\/h2>\n
      Ensure that the server environment has enough settings to upload files<\/a>.<\/p>\n