How To Insert Video In Mysql Database

The video has become an integral part of our lives. We capture, edit, and share videos on a daily basis. As a developer, it might be necessary to store video files in a database. In this tutorial, we will learn how to insert video files in the MySQL database.

Steps to insert video in MySQL database

1. Create a database table

First, let’s create a table in our database to store the video files. Here is an example of the SQL query to create the table:

1
2
3
4
5
6
CREATE TABLE videos (
  id INT(11) NOT NULL AUTO_INCREMENT,
  title VARCHAR(255) NOT NULL,
  content LONGBLOB NOT NULL,
  PRIMARY KEY (id)
);

This query will create a table with three columns – id, title, and content. The content column will store the video file in binary format.

2. Convert video file to binary

Before we can insert the video file into the database, we need to convert it to binary format.

We can use the file_get_contents() function to read the contents of the video file and then use the addslashes() function to escape any special characters in the binary string.

1
2
$video = file_get_contents('path/to/video.mp4');
$video = addslashes($video);

3. Insert the video file into the database

Now that we have the video file in binary format, we can insert it into the database using an SQL query.

1
INSERT INTO videos (title, content) VALUES ('My Video', '$video');

This query will insert the video file into the database with the title “My Video”.

Conclusion

In this tutorial, we learned how to insert video files in the MySQL database. We created a table to store the video files, converted the video file to binary format, and then inserted it into the database using an SQL query.

Storing video files in a database can be useful in certain situations, but it’s important to consider the impact on performance and disk space.

If you want to retrieve the video file from the database, you can use the SELECT statement and the appropriate functions to convert the binary data back to a video file.

1
2
3
SELECT content FROM videos WHERE id = 1;
$video = base64_encode($row['content']);
echo '<video controls><source src="data:video/mp4;base64,'.$video.'"></video>';

The above code will retrieve the video file from the database and display it in your HTML using the base64 encoding.