php-mysqlHow to store a BLOB in a MySQL database using PHP?

Storing a BLOB (Binary Large Object) in a MySQL database using PHP can be done by using the mysqli_query() function. The following example code will store a BLOB in the files table of the mydb database:

$conn = mysqli_connect("localhost", "my_user", "my_password", "mydb");
$sql = "INSERT INTO files (name, type, size, content ) ".
"VALUES ('$fileName', '$fileType', '$fileSize', '$content')";
$result = mysqli_query($conn, $sql);

The output of the above code will be a TRUE or FALSE value, depending on whether the query was successful or not.

Code explanation

1. mysqli_connect(): Establishes a connection to the MySQL database.
2. $sql: The SQL query used to insert the BLOB into the database.
3. $result: Stores the result of the query.
4. mysqli_query(): Executes the SQL query.

Helpful links

• MySQL: Inserting BLOBs with PHP
• PHP: mysqli_query()

Edit this code on GitHub