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, 538👍, 0💬