Tools, FAQ, Tutorials:
Creating a Database Table to Store Files in PHP
How To Create a Table To Store Files in PHP?
✍: FYIcenter.com
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 into Database in PHP
⇐ Filtering Out Empty Files in PHP
2016-10-14, 1650👍, 0💬
Popular Posts:
dev.FYIcenter.com is a Website for software developer looking for software development technologies,...
Where to find tutorials on PHP language? I want to know how to learn PHP. Here is a large collection...
How to access Request body from "context.Request.Body" object in Azure API Policy? Request body is t...
How to use .NET CLR Types in Azure API Policy? By default, Azure imports many basic .NET CLR (Common...
How to create a new API on the Publisher Dashboard of an Azure API Management Service? If you are ne...