PHP - Creating a Database Table to Store Files in PHP

Creating a Database Table to Store Files in PHP

Q

How To Create a Table To Store Files in PHP?

✍: FYIcenter.com

A

If you using MySQL database and want to store files in database, you need to create BLOB columns, which can holds up to 65,535 characters. Here is a sample script that creates a table with a BLOB column to be used to store uploaded files:

<?php
  $con = mysql_connect("localhost", "", "");
  mysql_select_db("fyi");
  $sql = "CREATE TABLE fyi_files ("
      . " id INTEGER NOT NULL AUTO_INCREMENT" 
      . ", name VARCHAR(80) NOT NULL"
      . ", type VARCHAR(80) NOT NULL"
      . ", size INTEGER NOT NULL"
      . ", content BLOB"
      . ", PRIMARY KEY (id)"
      . ")";
  mysql_query($sql, $con); 
  mysql_close($con); 
?>

⇒Uploading Files to Web Servers in PHP

⇒⇒PHP Tutorials

2016-10-14, 1128👍, 0💬

💬 2017-02-20 Jonas: Thanks for the sample code!

Filtering Out Empty Files in PHP
Why Do You Need to Filter Out Empty Files in PHP? When you are processing uploaded files, you need to check for empty files, because they could be resulted from a bad upload process but the PHP engine could still give no error. For example, if a user typed a bad file name in the upload field and sub... 2016-10-14, 1199👍, 0💬

Creating a Database Table to Store Files in PHP
How To Create a Table To Store Files in PHP? If you using MySQL database and want to store files in database, you need to create BLOB columns, which can holds up to 65,535 characters. Here is a sample script that creates a table with a BLOB column to be used to store uploaded files: <?php $co... 2016-10-14, 1129👍, 0💬

Configuration Settings for File Upload in PHP
What Are the File Upload Settings in Configuration File in PHP? There are several settings in the PHP configuration file related to file uploading: file_uploads = On/Off - Whether or not to allow HTTP file uploads. upload_tmp_dir = directory - The temporary directory used for storing files when doin... 2016-10-14, 708👍, 0💬

Detecting File Uploading Errors in PHP
How To Detect File Uploading Errors in PHP? If there was a problem for a file upload request specified by the <INPUT TYPE=FILE NAME=fieldName...> tag, an error code will be available in $_FILES[$fieldName]['error']. Possible error code values are: UPLOAD_ERR_OK (0) - There is no error,... 2016-10-14, 629👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.