How to store directly in MySQL

Author: Florian Dittmer translation: netmad

If you want to save binary data, such as pictorial files and html files, save directly in your MySQL database, then this article is written for you!

I will tell you how to store these files through the HTML form, how to access and use these files.

This article overview:

Create a new database in MySQL

An example of how to store files

An example of how to access a file

Create a new Database in MySQL

First, you must create a new database in your MySQL, we will store those binary files in this database. In the example, I will use the following structure. In order to establish a database, you must do the following steps:

Enter the MySQL controller

Enter the command "CREATE DATABASE BINARY_DATA;"

Enter the command "use binary_data;"

Enter the command "create table binary_data (id int (4) Not null auto_increment primary key,

Description Char (50), Bin_Data Longblob, FileName Char (50), FileSize Char (50), FileType Char (50)); "(Can't break)

If there is no accident, the database and table should be established.

An example of how to store files With this example you can transfer files into the database via HTML form. .

STORE.PHP3

// store.php3 - by florian dittmer

?>